Remote Data Engineer: Databricks Medallion Pipelines

GovCIO; Harrisburg (Dauphin County); Remote; USD 130,000 - 160,000; Full time

Job summary

GovCIO is seeking a Data Engineer to design and build enriched datasets using medallion architecture in Databricks, sourcing data from the VA CDW and other systems. You will deliver analytics-ready data for Power BI semantic models and collaborate with clients to clarify requirements, track work in JIRA, and ensure high-quality pipelines.

The role emphasizes independent problem-solving, strong communication with stakeholders, and experience with healthcare data and federal environments.

Qualifications

• Bachelor's degree and 12+ yrs of experience (or commensurate experience).
• Hands-on experience building data pipelines and transformations in Databricks (PySpark and/or SQL).
• Strong SQL skills, including complex joins, aggregations, and performance tuning.
• Experience working with Power BI, including preparing data for semantic models.
• Familiarity with GitHub for version control and collaborative development.
• Experience using JIRA or similar tools to track and manage work.
• Strong communication skills and comfort working directly with clients/stakeholders.
• Understanding of medallion (bronze/silver/gold) data architecture principles.

Responsibilities

• Design, build, and maintain enriched datasets following medallion architecture (bronze, silver, gold layers) in Databricks.
• Develop, orchestrate, and monitor Databricks jobs and pipelines.
• Write efficient, well-structured SQL to transform and model healthcare data.
• Prepare and optimize gold-layer datasets for consumption by Power BI semantic models.
• Manage code and version control through GitHub, following team branching and review practices.
• Log, track, and update work items in JIRA.
• Partner directly with clients and stakeholders to understand requirements, clarify data definitions, and validate outputs.
• Troubleshoot data quality issues and ensure accuracy and consistency across pipelines.
• Write ad hoc queries to support client requests, investigations, and one-off analyses.
• Perform data validation and quality assurance checks on pipelines and enriched datasets to ensure accuracy, completeness, and consistency.
• Document data lineage, transformation logic, and business rules for enriched datasets.
• Collaborate with Power BI developers and data scientists on the broader team to ensure datasets meet downstream reporting and analytical needs.

Skills

PySpark

SQL

Power BI

GitHub

JIRA

Communication

Medallion architecture

Databricks

Education

Bachelor's degree

Tools

Databricks

GitHub

JIRA

Power BI

Job description

GovCIO is seeking a Data Engineer to design and build enriched datasets using medallion architecture in Databricks, sourcing data from the VA CDW and other systems. You will deliver analytics-ready data for Power BI semantic models and collaborate with clients to clarify requirements, track work in JIRA, and ensure high-quality pipelines.

The role emphasizes independent problem-solving, strong communication with stakeholders, and experience with healthcare data and federal environments.