Senior Data Engineer and Consultant Data Engineer

About HCA Healthcare - India

HCA Healthcare - India functions as a crucial center for innovation and operations that supports the mission of HCA Healthcare, which is dedicated to enhancing and protecting human life. HCA Healthcare delivers patient-focused care across approximately 190 hospitals and 2,400 care sites in the US and UK. Globally, HCA’s workforce shares a unified commitment to patients, enhancing care both at the bedside and beyond. The India hub plays an essential role by leveraging technology and innovation to improve healthcare services.

Role Responsibilities and Expectations

• Develop and manage complex SQL and T-SQL queries, including stored procedures, views, functions, joins, aggregations, and thorough data validation logic.
• Design and support SQL Server databases, applying fundamental database design methods, data extraction/loading techniques, indexing, and operational maintenance.
• Optimize query performance by diagnosing slow executions, analyzing query plans, refining T-SQL code, and addressing data pipeline inefficiencies.
• Work extensively with Microsoft Fabric, handling data workloads by loading, storing, transforming, and extracting data to meet business use cases.
• Create reliable data movement patterns for batch processing, extraction, reconciliation, and reporting to support downstream analytics.
• Effectively communicate technical details to diverse audiences, including both technical teams and non-technical or member-facing stakeholders.
• Exhibit strong problem-solving skills, thorough documentation, and ownership of assigned tasks and troubleshooting efforts.

Preferred Skills

• Familiarity with OneLake and lakehouse or warehouse patterns in Microsoft Fabric environments.
• Knowledge of Microsoft Purview for data governance aspects including cataloging, lineage tracing, and handling sensitivity classifications.
• Experience utilizing emerging Microsoft Fabric tools such as Data Agents.
• Hands-on exposure to Fabric Data Factory components like notebooks, pipelines, semantic models, Direct Lake, and integration with Power BI.
• Competence in automation, monitoring, alerting, continuous integration/deployment, source control, and deployment methodologies for data integration systems.
• Skill in supporting secure data sharing protocols, member data extracts, managing data contracts, and designing repeatable onboarding procedures.

Educational & Eligibility Criteria

Candidates should have credentials such as B.Tech or B.E. degree in any specialization or any graduate degree holder.