Senior Microsoft Data Engineer

Role: Senior Microsoft Data Engineer (5+ yrs)

About the Role

The ideal candidate is someone who has spent several years passionate about building core data engineering expertise, has exhibited leadership in end-to-end data solution implementations, and can clearly articulate the architecture, technical decisions, and challenges they solved.

Key Responsibilities

• Design and develop scalable and eicient data solutions across both on- premises SQL Server and Azure Data Services/Databricks.
  
• Provide experience based technical leadership in migrating legacy on- premises data processes to Azure cloud technology stacks.
• Ensure process performance, data security, and integrity across hybrid solutions built in SQL Server (on-premises), Azure Data Services (Databricks, Data Factory, Azure SQL, and Synapse Analytics).
• Optimize large data loads, complex SQL workloads, and storage/compute performance across environments.
• Build and maintain ETL pipelines using Azure Data Factory, SSIS, Synapse Pipelines, and Databricks.
• Collaborate closely with analytics and BI teams to deliver solutions aligned with governance and Azure best practices.
• Provide technical mentorship to junior engineers in both on-premises and cloud data engineering.
• Demonstrate ownership and initiative by engaging with leaders and colleagues to fully understand requirements, contribute to solution designs, participate in reviews, and drive overall excellence.

• Required Experience & Skills

• Bachelors degree in Information Technology, Computer Science, or a related field, or equivalent experience.
• 5 to 8+ years of hands-on experience in a Data Engineer or similar role with expertise in both on-premises SQL Server and Azure cloud technologies.
• Expert-level skills in SQL Server (T-SQL, indexing, partitioning, performance tuning, query optimization).
• Strong proficiency in Azure Data Services:

1. Azure Databricks
2. Azure SQL Database
3. Azure Data Lake Storage
4. Azure Data Factory
5. Azure Synapse Analytics
   
6. Hands-on experience building large-scale ETL/ELT pipelines using ADF, SSIS, Synapse, or Databricks.
7. Proven experience migrating on-premises SQL Server databases to Azure cloud environments.
8. Clear understanding of dimensional modelling theory and practices.
9. Strong problem-solving attitude with the ability to articulate sophisticated technical scenarios.
10. Solid understanding of data governance, security, and compliance in cloud environments.
11. Ability to work in fast-paced, collaborative environments with good communication skills.

    Preferred Skills

12. Experience with distributed compute paradigms (Spark/Databricks).
13. Exposure to workload management & cost optimization across Azure services.
14. Experience guiding or mentoring peers.