Principal Data & Analytics Engineer

synergenx; Houston (TX); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) with Company Match

Paid Time Off and Holidays

Life Insurance

Disability Insurance

Professional development

Job summary

SynergenX Health is seeking a Principal Data & Analytics Engineer to lead end-to-end data solutions in a hybrid Houston environment. You will architect and build production pipelines, models, and dashboards while collaborating with Operations, Finance, and Clinical teams.

This senior IC role requires strong SQL, Python/PySpark, Databricks, and Azure Data Factory experience. You’ll mentor engineers, drive data quality, and modernize pipelines to support analytics and AI initiatives.

Qualifications

• 7+ years of progressive experience in data engineering, analytics engineering, BI engineering, or a related discipline.
• Advanced SQL skills, including developing, optimizing, and troubleshooting complex data transformations.
• Strong Python and/or PySpark development experience.
• Strong hands-on experience with Databricks and Apache Spark.
• Strong Microsoft Azure experience, particularly Azure Data Factory and Azure data services.
• Strong data modeling skills, including dimensional models and star schemas.
• Experience building and supporting production ETL/ELT pipelines.
• Experience implementing automated data quality validation, monitoring, and production alerting.
• Working knowledge of Power BI architecture, semantic models, and DAX.
• Experience with Git, CI/CD, and modern software/data engineering practices.
• Demonstrated ability to troubleshoot complex data discrepancies across multiple systems.
• Ability to work with nontechnical stakeholders and translate business needs into technical solutions.

Responsibilities

• Own complex data solutions from start to finish, including discovery, requirements, architecture, development, testing, deployment, documentation, monitoring and production support.
• Build production data pipelines and analytical products using SQL, Python/PySpark, Databricks, and Azure tools.
• Turn business processes into reliable data logic by partnering with Operations, Finance, Pharmacy, Clinical Operations, Marketing, and others.
• Investigate difficult data discrepancies and identify root causes of metric changes across systems.
• Understand downstream impact of changes on Power BI reports, KPIs and financial calculations.
• Build quality and monitoring into solutions with automated validation, anomaly detection, and alerts.
• Modernize legacy pipelines, improve performance, migrate workloads to standardized Azure/Databricks patterns.
• Strengthen analytics layer with robust datasets and semantic models for consistent metrics.
• Improve engineering practices: Git, CI/CD, testing, documentation, reusable patterns, data lineage.
• Mentor Data Engineers, BI developers, analysts; conduct reviews and help resolve technical issues.
• Integrate enterprise source systems and data ingestion strategies across sources.

Skills

Advanced SQL

Python/PySpark

Databricks

Azure Data Factory

Azure Data Services

Data Modeling

ETL/ELT

Data quality monitoring

Git/CI/CD

Power BI

APIs & integrations

Tools

Databricks

Azure Databricks

SQL

Python

Job description

Principal Data & Analytics Engineer

SynergenX Health

Job Type: Full-Time | Exempt

Schedule: Monday–Friday | 8:00 AM – 5:00 PM

Work Location: Houston, TX / Hybrid (2-3 days a week)- Northwest Houston Corporate Headquarters

Principal Data & Analytics Engineer

Build the Data Foundation Behind a Growing Healthcare Leader

At SynergenX Health, technology and data help us improve patient care, strengthen operations, and make better business decisions. As one of the nation’s leading hormone optimization and wellness organizations, we’re investing in modern Azure and Databricks solutions to support our continued growth.

We’re looking for an experienced Principal Data & Analytics Engineer who enjoys solving complex problems, working directly with business stakeholders, and building reliable data solutions from discovery through production.

This is a senior, hands-on individual contributor role that combines data engineering, analytics engineering, solution architecture, and business problem solving. You’ll personally investigate, design, build, test, deploy, and monitor solutions while serving as a senior technical resource for our Data & AI team.

Reports to: Senior Manager, Data & AI
Role Type: Senior Individual Contributor
Location: Houston, TX
Work Arrangement: Hybrid — 2–3 days per week onsite

What You’ll Do

• Own complex data solutions from start to finish. Lead discovery, requirements gathering, architecture, development, testing, deployment, documentation, monitoring, and production support.

• Build production data pipelines and analytical products. Develop ETL/ELT pipelines, Databricks workflows, curated datasets, dimensional models, semantic models, and integrations using SQL, Python/PySpark, Azure Data Factory, and Databricks.

• Turn business processes into reliable data logic. Partner with Operations, Finance, Pharmacy, Clinical Operations, Marketing, and other teams to understand their workflows and create consistent data definitions and solutions.

• Investigate difficult data discrepancies. Trace unexpected metric changes across source systems, pipelines, transformations, and reporting layers. Identify root causes and implement lasting fixes.

• Understand the downstream impact of changes. Evaluate how updates to shared datasets and business logic affect Power BI reports, KPIs, financial calculations, operational workflows, and dependent systems.

• Build quality and monitoring into every solution. Implement automated validation, reconciliation, anomaly detection, monitoring, and alerting to identify pipeline failures, data drift, and unexpected historical changes.

• Modernize existing data solutions. Refactor legacy pipelines, eliminate duplicated logic, improve performance, and migrate appropriate workloads to standardized Azure and Databricks patterns.

• Strengthen the analytics layer. Develop and optimize datasets and semantic models that support consistent metrics and trustworthy historical reporting.

• Improve engineering practices. Help establish practical standards for Git, CI/CD, testing, documentation, reusable development patterns, data lineage, and deployment.

• Serve as a senior technical partner. Mentor Data Engineers, BI developers, and analysts; conduct code and design reviews; and help resolve challenging technical issues.

• Integrate enterprise source systems. Evaluate databases, APIs, SaaS platforms, EHR and pharmacy systems, financial applications, and other sources to determine appropriate ingestion strategies.

• Support Data & AI initiatives. Build dependable data foundations and integrations for automation, AI/ML, and advanced analytics.

Required Qualifications

• 7+ years of progressive experience in data engineering, analytics engineering, BI engineering, or a related discipline.

• Demonstrated success independently delivering complex data solutions from initial requirements through production.

• Advanced SQL skills, including developing, optimizing, and troubleshooting complex data transformations.

• Strong Python and/or PySpark development experience.

• Strong hands-on experience with Databricks and Apache Spark.

• Strong Microsoft Azure experience, particularly Azure Data Factory and Azure data services.

• Strong data modeling skills, including dimensional models, star schemas, and analytical data models.

• Experience building and supporting production ETL/ELT pipelines.

• Experience implementing automated data quality validation, monitoring, and production alerting.

• Working knowledge of Power BI architecture, semantic models, and DAX sufficient to evaluate downstream analytical impacts.

• Experience with Git, CI/CD, and modern software and data engineering practices.

• Demonstrated ability to troubleshoot complex data discrepancies across multiple systems.

• Ability to investigate source systems, understand business processes, and deliver solutions when requirements are initially ambiguous.

• Ability to work directly with nontechnical stakeholders and translate business needs into technical solutions.

• Strong written documentation and verbal communication skills.

Preferred Qualifications

• Healthcare, pharmacy, EHR, or other regulated-data experience.

• Experience working with HIPAA-regulated data.

• Microsoft Fabric experience.

• Experience with Databricks Lakehouse, Delta Lake, and Unity Catalog.

• API integration experience.

• Experience with Azure DevOps.

• Experience modernizing legacy data warehouses or pipelines.

• Experience integrating operational and transactional systems with analytics platforms.

• Databricks Data Engineer certification.

• Microsoft Fabric or Power BI certification.

• Experience supporting AI/ML or automation workloads.

Ideal Technical Stack

Candidates should bring strong experience with the core technologies below, along with exposure to relevant supporting tools.

Data Engineering & Processing

• Azure Data Factory

• Azure Databricks

• Apache Spark

• ETL/ELT Pipelines

• Databricks Workflows

• Data Integration

• Delta Lake / Lakehouse Architecture — Preferred

Programming & Integrations

• SQL

• Python

• PySpark

• APIs and Enterprise System Integrations

Data Modeling & Analytics

• Dimensional Modeling

• Star Schemas

• Curated Analytical Datasets

• Microsoft Power BI

• Semantic Models

• DAX

• Consistent KPI and Metric Definitions

Cloud & Governance

• Microsoft Azure Data Services

• Microsoft Fabric — Preferred

• Unity Catalog — Preferred

• Data Lineage

• Data Quality Validation

• Monitoring and Alerting

Development & Deployment

• Git

• CI/CD

• Automated Testing

• Code and Design Reviews

• Technical Documentation

• Azure DevOps — Preferred

Why Join SynergenX?

• Medical, Dental, and Vision Insurance

• 401(k) with Company Match

• Paid Time Off and Paid Holidays

• Company-Paid Life Insurance

• Short- and Long-Term Disability

• Employee Assistance Program

• Professional development opportunities

• Hybrid work arrangement in Houston

• Opportunity to influence enterprise data architecture and engineering standards

• Meaningful projects supporting clinical, pharmacy, financial, and operational teams

• A growing healthcare organization investing in its data and technology capabilities

Work Environment

This is a hybrid position based in Houston, Texas, with 2–3 days per week onsite for collaboration with the Data & AI team and business stakeholders.

Candidates must be able to reliably commute to the Houston office and meet the onsite requirements.

As a senior individual contributor, you’ll remain actively involved in production development while providing technical guidance, mentoring teammates, and helping shape solution design.

Employment Requirements

• Must be legally authorized to work in the United States.

• SynergenX Health is unable to provide current or future employment visa sponsorship for this position.

• Successful completion of all pre-employment screening requirements.

Why This Opportunity?

Your work will help teams trust their data, understand performance, and make decisions that support patient care and business growth.

You’ll have the opportunity to solve challenging problems across multiple business functions, modernize important data systems, and influence how we build and maintain our enterprise data platform. From investigating an unexpected financial metric to designing a scalable Databricks pipeline, you’ll bring both technical depth and business understanding to the solution.

If you enjoy taking ownership, working through ambiguity, and building data products that people depend on, we’d love to hear from you.

Equal Employment Opportunity

SynergenX Health is an Equal Opportunity Employer. We are committed to an inclusive workplace and make employment decisions based on qualifications, merit, and business needs. We consider all qualified applicants without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, disability, genetic information, protected veteran status, or any other status protected by applicable federal, state, or local law.