Note: The job is a remote job and is open to candidates in USA. Gainwell Technologies is seeking an experienced Power BI & Databricks ETL Engineer to build scalable data pipelines and analytics solutions. The role focuses on transforming and governing data with Databricks and Azure, developing Power BI models and reports, and supporting healthcare and Medicaid analytics while ensuring performance, security, quality, and deployment standards.
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
- Implement data models using Data Lake, ensuring reliability, versioning, and auditability
- 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
- Support multi-environment deployment activities across DEV / STG / UAT / PRD
- 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
- Familiarity with enterprise BI integrations and governed analytics platforms
- Knowledge of claims processing, member, provider enrollment and management
- 6 or more years of experience programming or testing experience working 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
- Experience with Medicaid quality, compliance, or program integrity reporting
- Healthcare domain experience with PBM/PBA data, including pharmacy and program analytics
Benefits
- Work flexibility
- Learning and career development
- Technical credentials and certifications
- Generous, flexible vacation policy
- Educational assistance
- Comprehensive leadership and technical development academies
- United States remote opportunity
- 401(k) employer match
- Comprehensive health benefits
Company Overview
Company H1B Sponsorship