SENIOR DATA ENGINEER - SQL Server

Job Title: Data Engineer - SQL Server & Microsoft Fabric

Experience: 5-8 Years

We are seeking an experienced Data Engineer with strong expertise in SQL Server, ETL development, and Microsoft Fabric to design, build, and optimize scalable data solutions. The ideal candidate will have hands-on experience in data warehousing, data integration, data modeling, and modern cloud-based analytics platforms, particularly Microsoft Fabric.

• Design, develop, and maintain data pipelines and ETL/ELT solutions.
• Develop and optimize complex SQL queries, stored procedures, functions, and views in SQL Server.
• Build and manage data solutions using Microsoft Fabric components such as Data Factory, Lakehouse, Data Warehouse, Real-Time Analytics, and Power BI.
• Integrate data from multiple sources into enterprise data platforms.
• Create and maintain dimensional data models (Star/Snowflake schemas).
• Ensure data quality, governance, security, and performance optimization.
• Implement data transformation workflows using Fabric Data Factory and notebooks.
• Collaborate with business stakeholders, data analysts, and architects to understand data requirements.
• Monitor and troubleshoot data pipelines and production data issues.
• Support reporting and analytics initiatives through Power BI integration.

• Strong experience with Microsoft SQL Server (SQL Development, Performance Tuning, Query Optimization).
• Experience in Microsoft Fabric.
• Hands-on experience with:
  • Fabric Data Factory
  • Fabric Lakehouse
  • Fabric Data Warehouse
  • OneLake
  • Fabric Notebooks
  • Power BI
• Strong understanding of ETL/ELT concepts.
• Experience with data modeling and data warehousing concepts.
• Proficiency in T-SQL, Stored Procedures, Views, Triggers, and Functions.
• Experience working with large-scale datasets and enterprise data platforms.
• Knowledge of CI/CD and DevOps practices for data engineering.

• Experience with Azure Data Factory (ADF).
• Knowledge of PySpark, Spark SQL, or Python.
• Experience with Delta Lake and Data Lake architectures.
• Familiarity with Azure Synapse Analytics, Databricks, or Azure Data Services.
• Understanding of data governance and security best practices.

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
• 5+ years of experience in Data Engineering.
• Microsoft Fabric or Azure Data Engineering certifications are preferred.

Keywords: SQL Server, Microsoft Fabric, Data Engineer, Fabric Data Factory, Lakehouse, OneLake, Power BI, ETL, ELT, Data Warehouse, T-SQL, Azure Data Factory, PySpark, Data Modeling.