Description

Role Overview

We are looking for a highly experienced Data Warehouse Engineer (10+ years) to design, develop, and optimize enterprise-scale cloud data warehouse solutions on Microsoft Azure. The role involves building scalable data pipelines, data models, and analytics solutions to support business intelligence and reporting needs.

Key Skills:

• Strong experience in SSRS (SQL Server Reporting Services)
• Hands-on expertise in Azure Synapse Analytics
• Proficiency in Azure Data Factory (ADF) and Azure Databricks
• Experience with Azure Data Lake Storage Gen2
• Knowledge of Azure Analysis Services
• Strong SQL development and performance tuning skills
• Experience with CI/CD pipelines, Git, Jenkins, and Azure DevOps

Responsibilities:

• Data Architecture & Development
• Design and implement cloud-based data warehouse solutions using Azure Synapse Analytics
• Build ETL/ELT pipelines using Azure Data Factory and Databricks
• Develop and maintain dimensional data models (fact and dimension tables) in the Gold layer of Medallion architecture
• Integrate structured and unstructured data from multiple sources into Azure Data Lake and Synapse
• Performance Optimization
• Optimize SQL queries, indexes, and partitioning strategies
• Manage Synapse compute resources for performance and cost efficiency
• Data Engineering & Migration
• Work on ingestion, transformation, and loading of enterprise data
• Analyse and modernize legacy systems including COBOL programs, copybooks, JCL workflows, CICS/IMS transactions, DB2 schemas, and VSAM files
• DevOps & Deployment
• Implement CI/CD pipelines for data solutions
• Use Git, Jenkins, and Azure DevOps for version control and automation
• Stakeholder Management
• Collaborate with business users, analysts, and architects
• Translate business requirements into scalable technical solutions
• Provide technical guidance and problem-solving support

Requirements:

• 10+ years of experience in data warehousing and Azure data platform
• Strong analytical, communication, and stakeholder management skills
• Experience in enterprise-scale data warehouse implementations
• Ability to work in complex, distributed data environments

Key Skills

Education

Any Graduate