Lead Data Engineer (etl, Ssis, Power BI Azure Ecosystems and Azure Fabric) - Remote - 6 Months Contract - Direct Client

Key Responsibilities: • Lead end-to-end design, development, and maintenance of enterprise data solutions and pipelines. • Support ongoing operations and drive enhancements in existing data warehouse and reporting environments. • Architect and optimize ETL workflows using SSIS and SQL Server for high-volume data processing. • Implement and manage Power BI dashboards and reports for business insights and analytics. • Apply strong Data Warehouse (DW) design principles—data modeling, schema design, and performance tuning. • Collaborate with business and technical stakeholders to gather requirements and translate them into scalable data solutions. • Integrate modern Azure data services (preferably Azure Fabric) to enhance data engineering capabilities. • Ensure adherence to data governance, security, and quality standards across all systems. Required Skills & Experience: • 8+ years of hands-on experience in Data Engineering, ETL, and Data Warehousing. • Strong proficiency in SSIS, SQL Server, and Power BI. • Solid understanding of Data Warehouse concepts, dimensional modeling, and ETL frameworks. • Experience in performance tuning of complex SQL queries and large datasets. • Exposure to Azure ecosystem (Azure Data Factory, Data Lake, Synapse, Azure Fabric is a strong plus). • Proven ability to lead and mentor teams while collaborating across cross-functional projects. • Excellent problem-solving, communication, and documentation skills. Nice to Have: • Experience integrating Azure Fabric into existing data architectures. • Familiarity with DevOps practices for data (CI/CD, automation, version control). • Understanding of data governance frameworks and compliance standards.