Description
ETL Developer ---Minneapolis, MN
Job Summary - This 3 month contract opportunity is for a ETL Developer role within a government sector. The individual in this role will primarily be responsible for providing ETL services for the build and design of the data warehouse.
In conjunction with other technical staff on the project team, work could include:
- Design, develop and deploy ETL solutions using SQL Server Integration Services (SSIS)
- Migrations and integrations of code to production warehouse
- Map new data sources into existing data feeds
- Establish and document regular, automated ETL processes
- Provide ETL mentoring for newly trained county IT staff person
- Design and create data models, schemas, tables, views and stored procedures for the data warehouse which fulfills operational, audit and regulatory requirements.
- Perform analysis on report needs and assist with the development of report specifications
- Ensure technical documentation is complete
Skill Sets Needed:
- Highly experienced with ETL framework design, implementation and best practices
- Strong experience in designing & developing ETL packages using SQL Integration Services (SSIS)
- Highly experienced with relational data modelling
- Solid understanding of data warehouse principles and structure
- Extensive experience writing complex SQL statements and T-SQL programming such as, Stored Procedure, Functions etc.
- Extensive experience working with Microsoft SQL Server
- Experience with VB or C# Scripting
- Experience with XML
- Experience with QA best practices
- Demonstrated ability to analyze data for business rules definition and validation
- Prior experience with health care payer data and/or EDI transactions preferred
- Experience with data modelling tools such as Power Designer, Irwin etc.
- Strong analytical and technical skills
- Good verbal and written communication
- Ability to mentor others
List of Deliverables, eg what the consultant(s) will be expected to accomplish:
- Regular status reports
- Preparation and implementation of scripts to manage migration of data from old and new claims system into one warehouse following county standard operating procedures
- Preparation of extracts from new data source into existing data feeds following organization standard operating procedures
- Complete set of technical and process documentation of scripts created, extracts implemented, and other work performed
- Knowledge transfer to county staff person
- Active project team member