ZONES Developer, Lead in Auburn, Washington

Developer, Lead Location: Washington- Auburn Description Company Overview Technology positively affects business. At Zones, Inc. we get IT - for over 30 years as a global provider of IT solutions, we've perfected the art of IT solutions. Our reach spans to more than 80 countries, from Seattle to Sydney, Dallas to New Delhi with partners like Microsoft, Apple, Cisco, Dell Lenovo and more. Join our team and you'll build a solid career working on the cutting edge of IT sales, technology solutions, engineering, operations, logistics and more. Our careers are centered around our main areas of expertise Data Center, Mobility, Unified Communications, Cloud, Security, Software, and Internet of Things (IoT). Do you have what IT takes? Let's talk, a new career - IT all starts at careers.zones.com Job Duties: Responsible for the technical implementation of current and future data warehouse, business intelligence solutions and data migration strategies. Implement new business intelligence and data warehouse requirements through the use of SQL, ETL, business intelligence tools, and database programming and reporting tools. Meet with customer business and technical leaders to identify and scope the business opportunities, document and vet business requirements, identify effective reporting techniques, identify the best data sources for reach report field, identify risks and constraints, and design reporting formats. Develop, implement, and maintain ETL (extract, transform, and load) solutions to bring new data into the data warehouse. Develop optimized database design to achieve acceptable performance by tuning view, tables and indexes for proper response time. Develop new capabilities and architectures that capitalize on the development of client portal, and ad-hoc BI capabilities. Full life-cycle development and maintenance of data warehouse, ETL, and business intelligence solutions. Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners. Provide guidance and recommendation on BI reporting packages. Develop ETL Packages using Microsoft SQL Server 2008 R2/2012 Integration Services. Implementation/Maintenance of Data Warehouse / Cube building. Optimize the ETL Packages. Analyze system issues reported by users and present workable solutions. Deploy ETL Packages/Cubes on Development/Test environment, and provide deployment instruction for further deployment on production. Will use the following: C#, Java, SQL, Business Intelligence Stack, SQL Server, Oracle. Minimum Educ/Exp: Bachelor degree or equivalent in Engg/CS/CIS/IT or related and five years of progressive related work experience. At least one year of experience using C#, Java, SQL, Business Intelligence Stack, SQL Server, Oracle. At Zones, we take great pride in offering a full spectrum of comprehensive, flexible benefit programs to our employees: Medical/dental/vision coverage 401(k) plan with matching provision Life insurance Paid vacation time Financial protection benefits Group discounts & perks Wellness programs And more Zones is also proud to be a certified Minority Business Enterprise (MBE), Corporate Plus member of the Northwest MSDC (Minority Supplier Development Council), and Equal Employment Opportunity Employer (EEOE) committed to diversity and inclusion. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, sexual orientation, national origin, age, citizenship, marital status, disability, gender identity or Veteran status. We offer employment and advancement opportunities to every applicant. Come join our team. Let's talk. At Zones, we don’t just acknowledge diversity, we make it the foundation of how we conduct business and how