About the job
Overview
At Abax Health, we are dedicated to bridging the gaps in care and enhancing the connectivity of healthcare data to elevate patient and provider outcomes. We are in search of a proficient Senior Database Engineer who will spearhead the design, optimization, and management of enterprise-level data systems that drive our analytics, reporting, and business intelligence initiatives. This pivotal role combines extensive technical database expertise with architectural leadership, ensuring performance, scalability, and data integrity throughout our data ecosystem.
The Senior Database Engineer will operate at the crossroads of engineering and business operations, tasked with maintaining fast, reliable, and scalable data pipelines and warehouses as we transition from an early-stage client base to a multifaceted enterprise.
Key Responsibilities
- Architect and enhance data warehouse platforms and the supporting database systems.
- Design and implement efficient data ingestion and transformation pipelines (ETL/ELT) utilizing tools such as ADF, DBT, or equivalents to guarantee reliable data ingestion from diverse sources (SFTP, HL7, FHIR, etc.).
- Develop and sustain logical and physical data models that back internal analytics, dashboards, and client-facing reporting applications.
- Optimize database performance, scalability, and reliability through tuning, indexing strategies, and proactive monitoring across both production and staging environments.
- Lead strategic data initiatives by establishing architectural standards that promote scalability, efficiency, and cost-effectiveness across the data platform.
- Collaborate with software engineering, implementation, operations, and business teams to ensure alignment on data requirements and governance practices.
- Administer, maintain, and monitor database systems to uphold availability, integrity, recoverability, and secure access in compliance with disaster recovery and business continuity best practices.
- Implement source control and DevOps methodologies (e.g., GitHub, ADO, etc.) for database change management, CI/CD automation, and deployment of database alterations.
- Mentor junior engineers in SQL development, reporting, analytics, and performance tuning best practices.
- Establish and enforce data governance standards for security, compliance, and consistency across all environments.
Qualifications
- Over 10 years of experience in database engineering, architecture, or administration, particularly with production-grade SQL Server environments.
- Demonstrated experience in designing and automating ETL pipelines and data warehouse solutions that support analytics, reporting, and business intelligence platforms (e.g., Power BI, Tableau).
- Deep expertise in database performance tuning, optimization, and maintenance.
- Solid understanding of data governance standards and best practices.
- Effective communication skills for cross-functional collaboration.

