Principal Data & Analytics Engineer

SynergenX Health Holdings LLC; Houston (TX); Hybrid; USD 128,000 - 173,000; Full time

Benefits offered by this job

Medical, Dental, Vision Insurance

401(k) with Company Match

Paid Time Off and Holidays

Company-Paid Life Insurance

Disability Insurance

Employee Assistance Program

Professional development opportunities

Job summary

SynergenX Health Holdings LLC is hiring a hands-on Principal Data & Analytics Engineer in Houston, TX (hybrid). You will design and deliver production data solutions, build ETL/ELT pipelines, and develop analytics capabilities using Azure and Databricks.

You will partner with Operations, Finance, Pharmacy, and Clinical Operations to translate business needs into reliable data logic, implement data quality and monitoring, and mentor other engineers in modern data practices.

Qualifications

• Strong SQL, data engineering, and analytics engineering capabilities.
• Proven ability to deliver end-to-end data solutions independently.
• Hands-on experience with Databricks, Spark, and Azure Data Factory.

Responsibilities

• Own complex data solutions from discovery to production support.
• Build ETL/ELT pipelines and analytics products using Azure Databricks and SQL.
• Partner with cross-functional teams to define data logic and data quality.

Skills

SQL

Python/PySpark

Azure Data Factory

Databricks

Data modeling

Power BI

Git/CI/CD

Azure Data Services

Tools

Databricks

Apache Spark

Azure Databricks

Job description

SynergenX Health Holdings LLC seeks a hands-on Principal Data & Analytics Engineer to design and deliver end-to-end, production data solutions. This senior individual contributor role is based in Houston, Texas (hybrid) and focuses on building reliable data pipelines and analytics capabilities using Azure and Databricks.

Key Responsibilities

• Own complex data solutions from discovery and requirements gathering through architecture, development, testing, deployment, documentation, monitoring, and production support.
• Build production data pipelines and analytical products, including ETL/ELT pipelines, Databricks workflows, curated datasets, dimensional models, semantic models, and integrations using SQL, Python/PySpark, Azure Data Factory, and Databricks.
• Translate business processes into dependable data logic by partnering with Operations, Finance, Pharmacy, Clinical Operations, Marketing, and other teams to define consistent data and deliver solutions.
• Investigate difficult data discrepancies by tracing unexpected metric changes across source systems, pipelines, transformations, and reporting layers, then implementing lasting fixes.
• Assess downstream impact when shared datasets and business logic change, including effects on Power BI reports, KPIs, financial calculations, operational workflows, and dependent systems.
• Embed quality and monitoring in every solution through automated validation, reconciliation, anomaly detection, monitoring, and alerting for pipeline failures, data drift, and unexpected historical changes.
• Modernize existing data solutions by refactoring legacy pipelines, removing duplicated logic, improving performance, and migrating appropriate workloads to standardized Azure and Databricks patterns.
• Strengthen the analytics layer by developing and optimizing datasets and semantic models for consistent metrics and trustworthy historical reporting.
• Improve engineering practices by helping establish standards for Git, CI/CD, testing, documentation, reusable development patterns, data lineage, and deployment.
• Act as a senior technical partner by mentoring Data Engineers, BI developers, and analysts, and by conducting code and design reviews to resolve challenging technical issues.
• Integrate enterprise source systems by evaluating databases, APIs, SaaS platforms, EHR and pharmacy systems, financial applications, and other sources to determine ingestion strategies.
• Support Data & AI initiatives by building dependable data foundations and integrations that enable automation, AI/ML, and advanced analytics.

Required Qualifications

• 7+ years of progressive experience in data engineering, analytics engineering, BI engineering, or a related discipline.
• Proven ability to deliver complex data solutions independently, from initial requirements through production.
• Advanced SQL skills, including development, optimization, and troubleshooting of complex data transformations.
• Strong hands-on experience with Databricks and Apache Spark.
• Strong Python and/or PySpark development experience.
• Strong Microsoft Azure experience, especially 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.
• 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.

Technology Stack

• Azure Data Factory, Azure Databricks, Apache Spark, SQL, Python, PySpark, Databricks Workflows
• ETL/ELT Pipelines
• Microsoft Power BI, DAX
• Dimensional Modeling, Star Schemas, Semantic Models
• Delta Lake, Lakehouse Architecture, Unity Catalog
• Microsoft Azure Data Services, Microsoft Fabric
• Git, CI/CD, Azure DevOps, APIs, EHR

Benefits

• 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

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.

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 reliably commute to the Houston office and meet the onsite requirements. As a senior individual contributor, you will 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.

Role Details

• Location: Houston, TX (hybrid)
• Compensation: USD 150,000 per yearly
• Experience: 7+ years