Senior ETL Developer (Microsoft SSIS)
The Senior Developer will help lead the planning, design, and enhancements for all data warehousing relating to Client’s business intelligence (BI). The individual will also serve as a project lead for new initiatives that include acquisitions, competitive intelligence, and joint initiatives with specific Brands. The position reports to the Director of Business Intelligence resident to our Tacoma HQ and has the flexibility to work remote.
PRIMARY RESPONSIBILITIES: - ETL data warehousing design, development, and utilizing star-schema (dimensional) data models. - Design and implement data staging, including staging database design and staging logic. - Designing ETL processes in SSIS, including data read/write, filtering and merging, data transformations, error handling, process design and logging. - Proven success building data warehouses for business intelligence solutions. - Change dimensions and data archiving utilizing specific transformations. - Develop and organize high-quality documentation. - Ability to understand the business solution that the data warehouse serves. - Facilitate all aspects of architecting, designing, developing, testing and implementing ETL solutions . - Performs analysis and provides insight into potential process improvements (performance tuning). - Embraces open dialogue and free exchange of ideas.
TOOLS: - Database: SQL Server 2000, 2005, 2008; Oracle - ETL Tools: SSIS - Scripting: Windows Scripting, Power Shell, PERL, Java Scripting, Stored Procedures - OLAP Tools: SSAS (MDX Expressions) - Programming Languages: C#, VB.NET
Desired Skills & Experience
REQUIREMENTS: - 5-10 years development experience with significant experience in ETL design and development in SSIS - Strong technologist with excellent data analysis and ETL architecture/design/development skills - Knowledge of SQL Server (TSQL, data types, Enterprise Manager, error handling) . - Experience with business intelligence teams for multi-product organization a plus. - Ability to provide hands-on leadership to other developers - Strong communication skills (written, verbal) and consultative abilities. - Experience with E/R Studio a plus. - Experience working with ETL/SSIS end user reporting tools. - In-depth knowledge of data modeling , designing databases, metadata, and using/managing metadata. - Project management (full life cycle) experience. - Experience with new initiatives implementation.