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.
Job Description
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 DataStage 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 HealthPartners 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 rolesExperience with Microsoft Tools, SQL Server, SSIS, and TFSDemonstrated experience with PL / SQL and knowledge of Oracle RDBMS (features, functions, and utilities)Ability to estimate data development efforts and manage tasks independentlyStrong documentation and diagramming skills, as well as excellent verbal and written communication skillsDemonstrated experience performing data integration utilizing ETL tools to develop, implement, and optimize ETL workflows and transformationsDemonstrated experience integrating data feeds from third-party data stores to build data warehouse solutions and create integration (exports) to other internal database systemsPreferred Qualifications :
Practical experience using commonly accepted data warehouse methods such as the Kimball or Inmon models, early binding, and late bindingExperience with AIX 5.x or equivalent UNIX operating systemExperience with IBM DataStage Tools and Clarity data models and Clarity ETL administrationFamiliarity with SDLC (systems development life cycle) such as Agile / Lean and data modeling tools such as Erwin or EmbarcaderoUnderstanding of data models, staging, landing, and data cohorts, ODS, OLAP, multi-dimensional analysis, and various schemasExperience with the Epic EMR system#J-18808-Ljbffr