Senior Data Warehouse and ETL Developer

Profile

Senior Data Warehouse and ETL Developer','Full-time','IT','Days','Days','80','80','None','None','WASHINGTON-FEDERAL WAY-FEDERAL WAY-HERON BLDG','','!*!Summary

The Senior Data Warehouse and ETL Developer is
responsible for having sound understanding of BI best practices, relational
structures, and dimensional data modeling, structured query language (SQL)
skills, data warehouse and reporting techniques.  Collaborate with the
Warehouse Architect, IT Development staff, and Business partners to develop and deploy applications and
extracts for our Operational Data Store (ODS) employing SSIS, SSRS, and TSQL
skillsets.  The role will involve
designing, developing, and supporting new and current ETL processes employing
industry standards and best practices to enhance loading of data from and into
different source/ target systems. 

The
Senior Data Warehouse Developer will also collaborate with the team to review,
analyze, modify, and create ETL processes, utilizing SSIS, testing, debugging,
integration and implementation processes. 
This role will also include development of documentation of the
technical needs for ETL processes and databases, and ensuring optimal technical
infrastructure is utilized.  This
position involves delivery of very large and complex data integration projects.
The successful candidate must have significant experience and expertise with
implementation best practices, in addition to a high degree of technical
excellence.

 

Essential Duties and Responsibilities

·       
Designs,
builds and supports data warehouse components, such as ETL processes, data
marts, reports, and reporting environments

·       
Designs
dimensional models with conformed dimensions, following the business’ processes

·       
Develops
and automates ETL processes, including error and reconciliation handling,
utilizing Microsoft SQL Server Integration Services (SSIS) and Transact SQL
(TSQL)

·       
Creates
processes for maintaining or/and capturing metadata

·       
Studies
and understands the company’s business processes and applications, including
their effect on data and reporting, and applies the knowledge gained in
designing extracts and reports

·       
Identifies
and documents all requirements for data warehouse components and reports by
working with end users and business analysts

·       
Performs
capacity planning, supporting, troubleshooting, and ETL performance
modification

·       
Assembles
performance statistics, analyzes them, and makes recommendations for
improvements

·       
Establishes
system documentation and ensures it is continually sustained.

 

','!*!Education and Experience

·       
Bachelor’s
degree or higher in Computer Science or the equivalent from another other
related field highly preferred

·       
Possess
five years’ work experience supporting and developing data warehouses

·       
Experience
creating metadata, developing ETL processes, and using several reporting tools;
and performing data cleansing functions

·       
Five
or more years of experience working with Microsoft SQL Server and SQL Server
Integration Service (SSIS)

·       
Strong
knowledge of the fundamentals of data warehousing, and experience supporting
and developing data warehouses

·       
Healthcare
data experience preferred, including strong knowledge of associated regulations
regarding data security and privacy

·       
Possess
excellent skill in communicating in writing and speaking with clients, senior
managers, and staff

·       
Proficient
at working independently and in a team setting','We’re an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.','2017-R0139391','QualChoice Health','Senior Data Warehouse and ETL Developer

Company info

Sign Up Now - WashingtondcCrossing.com