Sr. ETL Data Developer
At a glance
Senior Data Engineering role at SV Tech Systems Inc. Eden Prairie · contract.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Build and tune ETL workflows that move data between clinical and other data stores
- Create ETL packages from design specifications, then revise those specifications as requirements change
- Set up development standards and tool configurations, including controls for data quality and exceptions
- Investigate difficult integration failures and work with technical, reporting and business teams to resolve them
- Document technical designs and prepare coding, testing and implementation plans
What you bring
- At least three years developing and supporting ETL, preferably in clinical care or data warehousing
- A bachelor's degree or equivalent experience, plus hands-on work with SQL Server, SSIS and TFS
- Experience using PL/SQL and working with Oracle databases
- You can estimate development effort, organize your work independently and produce clear technical documentation
Who this fits
This senior contract role suits an experienced ETL developer who can deliver data integrations and support them through testing and implementation. The work is onsite in Eden Prairie, Minnesota.
From the employer
SV Tech Systems prides itself in being the leading provider of recruitment and staffing services for a wide range of industries. We provide staffing services to firms throughout the United States and Canada. We attract the best pool of talent with the aim of nurturing sound work ethics and solid values amongst a highly motivated and diverse workforce.
Hi,
This is a contract role for Health Parnter in Eden Prairie, MN. Must have SSIS and Epic Clarity.
Senior ETL Data Designer
7777 Golden Triangle Drive, Eden Prairie, MN 55344
Contract
Job Description:
Contract opportunity for an ETL Data Developer consultant to work in the Eden Prairie office building as part of our Epic Integration project. The ETL Data Development Team designs, builds, tests, implements and supports the Client enterprise data environments including but limited to: Epic's Clarity ETL, in-house Clinical Data Warehouse, Epic custom Registry database, and other Client data stores. This position uses standard concepts, practices, and procedures that meet the technical specifications as designed by the Data Designer Analysts. The ETL Data Developer consultant will make use of the Microsoft SSIS ETL toolset (and IBM DataStage if applicable) and utilizes the ETL standard processes and procedures to move data, manage metadata, and ensure the integrity, validity, security and auditability of the data. This role follows standard development life-cycle processes (Agile/Lean) to gather technical specifications and create technical coding specifications including production, testing, and implementation plans. Hands-on experience in ETL development of data warehouses with technologies appropriate for the platform where development occurs will be a plus.
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
• Serves 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 the ETL packages to design specifications
• Update package specifications with changes
REQUIRED QUALIFICATIONS:
• Bachelors degree or equivalent experience
• 3+ years experience with ETL development and support & preferably with clinical care delivery and data warehouse development roles
• Experience with Microsoft Tools & SQL Server, SSIS, TFS
• Demonstrated experience with PL/SQL and knowledge of Oracle RDBMS (features, functions, & utilities)
• Ability to estimate data development efforts
• Ability to manage tasks and work independently
• Strong documentation and diagramming skills
• 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 DataStage Tools
• Experience with 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 Epic EMR system
ETL, Epic Clarity, SSIS, IBM Data Stage, Data Model, Pl/ SQL, TFS, RDBMS, Agile or Lean, Kimball or Inmon, UNIX, Erwin
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.