Remote Power BI & Databricks ETL Architect

Gainwell Technologies; Northern (KY); Hybrid; USD 95,000 - 136,000; Full time

Benefits offered by this job

Flexible vacation policy

Educational assistance

401(k) match

Health benefits

Leadership academies

Job summary

Gainwell Technologies is seeking a highly skilled Power BI & Databricks ETL Engineer to design, build, and maintain scalable data pipelines and analytics solutions. You will transform raw data into reliable datasets using Databricks and deliver insights via Power BI dashboards and reports.

The ideal candidate has strong ETL development, cloud data platforms (Azure) experience, and deep data visualization expertise.

Qualifications

• 6 or more years of experience programming or testing experience with relevant programming languages, relational databases, operating systems and software.
• Experience supporting state Medicaid agencies, MMIS modernization, or Medicaid managed care analytics.
• Familiarity with T-MSIS, CMS reporting requirements, and state-specific Medicaid data standards.
• Knowledge of Medicaid claims adjudication, eligibility determination processes, provider enrollment, and encounter submission workflows.

Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines using Databricks.
• Ingest data from multiple sources including relational databases, APIs, files, and cloud storage.
• Implement data transformation, cleansing, validation, and enrichment logic to ensure data quality and consistency.
• Optimize Spark jobs for performance, scalability, and cost efficiency.
• Design and develop Power BI semantic models, dashboards, and reports to support business decision-making.
• Implement performance-optimized DAX calculations, measures, and KPIs.
• Apply dimensional modeling concepts (star/snowflake schemas) for analytics use cases.
• Partner with stakeholders to translate business requirements into technical solutions and visual insights.
• Maintain data mapping documents, transformation specifications, and runbook inputs.
• Work with cloud data platforms (primarily Microsoft Azure) including Azure Data Lake Storage and related services.
• Implement data governance, security, and access controls (e.g., row-level security in Power BI).
• Support CI/CD pipelines for data and BI artifacts.
• Provide technical input on feasibility, risks, and delivery trade-offs to engagement leadership.
• Enforce delivery standards across documentation, peer reviews, testing, and release readiness.
• Monitor data pipelines and resolve data quality or performance issues proactively.
• Healthcare domain experience with PBM/PBA data, including pharmacy and program analytics.

Skills

Power BI

Databricks

ETL pipelines

Azure

Data modeling

Tools

Azure Data Lake Storage

Power BI Desktop

Job description

Gainwell Technologies is seeking a highly skilled Power BI & Databricks ETL Engineer to design, build, and maintain scalable data pipelines and analytics solutions. You will transform raw data into reliable datasets using Databricks and deliver insights via Power BI dashboards and reports.

The ideal candidate has strong ETL development, cloud data platforms (Azure) experience, and deep data visualization expertise.