Azure Data Integration Architect Data Mart

Job Title:

Azure Data Integration Architect with Data Mart Exp

Duration:
Contract

The Senior Azure Data Integration Architect is responsible for designing, developing, and optimizing enterprise data solutions across EDW, ODS, and Data Marts, leveraging Azure Data Factory for data integration. The role focuses on performance, scalability, reliability, and data quality to support analytics, reporting, and regulatory needs.

• Design and maintain EDW, ODS, and Data Mart architectures and data models.
• Develop and manage Azure Data Factory (ADF) pipelines for batch and incremental data loads.
• Implement ETL/ELT processes from multiple source systems (on-prem, cloud, APIs).
• Ensure data consistency, reconciliation, and flow across ODS, EDW, and Data Marts.
• Optimize pipelines and queries for performance, scalability, and cost efficiency.
• Apply tuning techniques such as partitioning, indexing, and parallel processing.
• Monitor production pipelines, troubleshoot failures, and meet SLA requirements.
• Implement data validation, error handling, and operational controls.
• Collaborate with business, analytics, and platform teams to deliver data solutions.

• Strong experience in EDW, ODS, and Data Mart design
• Hands‑on expertise with Azure Data Factory
• Strong SQL and data performance tuning skills
• Experience with enterprise data integration and ETL frameworks
• Hands‑on expertise on Business Intelligence (OBIEE and Power BI)
• Knowledge of cloud-based data platforms (Azure preferred)