Data Engineer (Data Quality & ETL)

EmergenceTek Group Inc.; United States; Remote; USD 95,000 - 135,000; Full time

Benefits offered by this job

Fully remote

EST core hours

Competitive compensation

W2 only – no C2C

Job summary

EmergenceTek Group is hiring a Data Engineer to support a regional health plan's data engineering team. This full-time W2 role is fully remote with EST core hours, embedded with the client's data group to maintain high-quality, reliable, and secure data systems across on-premise and cloud environments.

You will validate data movement across ETL and streaming, build automation for data quality, and document workflows and governance.

Qualifications

• 3+ years of experience in data analysis and data management, preferably in a health care environment.
• 3+ years of experience in data warehousing, or with data vaults (raw and business), medallion architecture, or comparable analytics solutions
• 1-3 years of experience with Azure Databricks
• 1-3 years of experience with at least one programming language (preferably MS SQL or Python)
• Experience with data mining, ETL, and medium-scale, complex datasets in a business environment
• Advanced knowledge of OLAP
• Dimensional and star schema modeling skills
• Experience developing dashboards and scorecards in reporting tools is preferred

Responsibilities

• Validate data movement and delivery artifacts across ETL and data streaming. Help tune and stabilize those processes
• Validate data pipelines, identify defects, and confirm they meet business requirements
• Build and maintain an automation framework that improves data quality and increases delivery throughput
• Create and maintain documentation and guardrails for data quality in line with enterprise data governance needs
• Document data engineering workflows, data models, and mission-critical enterprise ETL tasks
• Work with senior data engineers, analysts, and business customers to gather and define requirements
• Develop, modify, or propose datasets that meet reporting and analytics needs
• Improve team processes, automating where needed and providing self-service solutions where they apply
• Share technical expertise with users across the organization and mentor other data engineers

Skills

Data analysis

Data management

Data warehousing

Azure Databricks

MS SQL

Python

OLAP

Dimensional modeling

Star schema

Education

MS degree

Microsoft SQL Server certification

Tools

SSRS

SSAS

SSMS

SSIS

Tableau

Power BI

Informatica

Job description

We're hiring a Data Engineer to support a leading regional health plan's data engineering team. This is a full-time W2 position with ETG. You will work embedded with the client's data engineering group to keep data systems (across on-premise and cloud environments) high quality, reliable, and secure.

• Fully remote, EST core working hours


• Competitive compensation:


• This is a W2 position only. No C2C, no third-party submissions, and no visa sponsorship available.

What you'll do

• Validate data movement and delivery artifacts across ETL and data streaming. Help tune and stabilize those processes


• Validate data pipelines, identify defects, and confirm they meet business requirements


• Build and maintain an automation framework that improves data quality and increases delivery throughput


• Create and maintain documentation and guardrails for data quality in line with enterprise data governance needs


• Document data engineering workflows, data models, and mission-critical enterprise ETL tasks


• Work with senior data engineers, analysts, and business customers to gather and define requirements


• Develop, modify, or propose datasets that meet reporting and analytics needs


• Improve team processes, automating where needed and providing self-service solutions where they apply


• Share technical expertise with users across the organization and mentor other data engineers

What we're looking for

• 3+ years of experience in data analysis and data management, preferably in a health care environment


• 3+ years of experience in data warehousing, or with data vaults (raw and business), medallion architecture, or comparable analytics solutions


• 1-3 years of experience with Azure Databricks


• 1-3 years of experience with at least one programming language (preferably MS SQL or Python)


• Experience with data mining, ETL, and medium-scale, complex datasets in a business environment


• Advanced knowledge of OLAP


• Dimensional and star schema modeling skills


• Experience with reporting and data tools such as SSRS, SSAS, SSMS, SSIS, Tableau, Power BI, or Informatica is preferred


• Experience developing dashboards and scorecards


• Strong verbal and written communication, able to explain complex analysis in business terms to analysts and business teams

Nice to Have

• Knowledge of healthcare claims processing systems (Facets preferred), health care delivery, and medical terminology


• Understanding of automation and scripting frameworks


• Experience with Azure Data Lakes


• MS degree or Microsoft SQL Server certification is a plus

About ETG

EmergenceTek Group is a boutique IT consulting firm that has worked with healthcare, manufacturing, and other high-trust industries since 2012. Work alongside senior engineers on long-term engagements, supported by a leadership team that stays in the work. You'll build real domain expertise working on meaningful problems.