Description

Lead the design, optimization, and modernization of enterprise data warehousing and platform operations across SQL Server, cloud platforms, and reporting layers.

This role is on-site.

Responsibilities

• Provide end-to-end ownership of EDW and data platform operations, including SQL Server, data marts, and reporting integrations.
• Design and optimize high-volume ETL/ELT pipelines using Informatica PowerCenter, IICS, and SSIS.
• Drive the modernization roadmap toward cloud data platforms like Azure Fabric and Databricks.
• Ensure data quality, integrity, and reconciliation across clinical, financial, and operational datasets.
• Collaborate with stakeholders to translate business KPIs into scalable data models and SSRS/Tableau dashboards.

Required Skills

• 5+ years of experience with SQL Server EDW architecture, performance tuning, and indexing.
• Advanced SQL proficiency, including complex joins, window functions, and stored procedures.
• Strong understanding of data warehousing concepts: star schema, data marts, and dimensional modeling.
• Hands-on expertise with Informatica PowerCenter/IICS and SSIS for advanced pipeline development and orchestration.
• Experience with ETL performance tuning, batch/streaming ingestion, and job scheduling tools.
• Familiarity with data quality frameworks, metadata lineage, and Git/version control.
• Understanding of CI/CD basics for ETL deployments.

Preferred Skills

• Exposure to Databricks and Spark for cloud-scale data processing.
• Knowledge of Azure Fabric and Lakehouse concepts.

Key Skills

Education

Any Gradute