Sr. ETL Data Developer

SV Tech Systems is a leading provider of recruitment and staffing services for various industries. We provide staffing services to firms throughout the United States and Canada, attracting top talent with the aim of nurturing sound work ethics and solid values amongst a highly motivated and diverse workforce.

This is a contract role for Health Partner in Eden Prairie, MN, requiring SSIS and Epic Clarity experience.

Senior ETL Data Designer - Contract

Contract opportunity for an ETL Data Developer consultant to work on the Epic Integration project. The ETL Data Development Team designs, builds, tests, implements, and supports the Client enterprise data environments, including Epic's Clarity ETL, in-house Clinical Data Warehouse, and other Client data stores. This position uses standard concepts, practices, and procedures, meeting technical specifications designed by the Data Designer Analysts.

The ETL Data Developer consultant will use the Microsoft SSIS ETL toolset (and IBM Data Stage if applicable), following standard development life-cycle processes (Agile/Lean) to gather technical specifications and create technical coding specifications, including production, testing, and implementation plans.

Accountabilities:

• Collaborate with technical team members, business liaisons, and end-users to deliver Data Integration ETL solutions
• Develop, implement, and optimize ETL workflows and transformations
• Implement standards and procedures for ETL development and tool configurations
• Triage the resolution of complex data integration ETL issues in a timely manner
• Serve as a key contributor to the design and development of exception handling, data standardization procedures, and Quality Assurance controls
• Collaborate with the Health Partners Reporting and Analytics teams to understand and document complex business issues
• Develop ETL packages to design specifications and update package specifications with changes

Required Qualifications:

• 3+ years of experience with ETL development and support, preferably with clinical care delivery and data warehouse development roles
• Experience with Microsoft Tools, SQL Server, SSIS, and TFS
• Demonstrated experience with PL/SQL and knowledge of Oracle RDBMS (features, functions, and utilities)
• Ability to estimate data development efforts and manage tasks independently
• Strong documentation and diagramming skills, as well as excellent verbal and written communication skills
• Demonstrated experience performing data integration utilizing ETL tools to develop, implement, and optimize ETL workflows and transformations
• Demonstrated experience integrating data feeds from third-party data stores to build data warehouse solutions and create integration (exports) to other internal database systems

Preferred Qualifications:

• Practical experience using commonly accepted data warehouse methods such as the Kimball or Inmon models, early binding, and late binding
• Experience with AIX 5.x or equivalent UNIX operating system
• Experience with IBM Data Stage Tools and Clarity data models and Clarity ETL administration
• Familiarity with SDLC (systems development life cycle) such as Agile/Lean and data modeling tools such as Erwin or Embarcadero
• Understanding of data models, staging, landing, and data cohorts, ODS, OLAP, multi-dimensional analysis, and various schemas
• Experience with the Epic EMR system