Senior Data Engineer

Overview: Our client is seeking an experienced Data Consultant with strong architecture and hands-on technical skills to lead analytics and data engineering projects. The ideal candidate will architect end-to-end solutions using Microsoft Fabric and Synapse Analytics, drive the development of impactful dashboards (such as inventory reporting), and guide data teams in extracting and shaping data from SAP for business-critical use cases. Key Responsibilities: • Lead the design and architectural development of comprehensive data analytics solutions using Microsoft Fabric, Synapse Analytics, and Power BI. • Engage directly with business stakeholders to gather and clarify requirements; translate those into scalable, maintainable technical solutions. • Direct and mentor a team of junior data engineers and Power BI developers throughout all project phases, ensuring high-quality deliverables. • Oversee and contribute hands-on to project tasks, splitting time approximately 50/50 between architecture/design and implementation/coding. • Extract, transform, and load (ETL) data from SAP (including ECC and S/4HANA) systems—leveraging CDC or Table connectors as needed. • Build robust data models and create interactive dashboards/reports in Power BI, with a particular focus on inventory, finance, manufacturing, and order management use cases. • Collaborate with stakeholders to create an inventory dashboard by sourcing, validating, and modeling required SAP data. • Stay ahead of data migration and integration trends, supporting future movement from ECC to S/4HANA. • Serve as the primary point of contact for all project communication and technical guidance. • Manage project timelines, risks, and deliverables from end to end. Required Qualifications: • Extensive hands-on experience architecting and implementing analytics/data engineering solutions using Microsoft Fabric and Azure Synapse Analytics. • Advanced proficiency designing Power BI solutions as an architect; able to deliver reporting frameworks and dashboards that scale. • Solid experience with SAP data extraction and integration concepts, ideally working with both ECC and S/4HANA (experience with CDC connector for S4, Table connectors for ECC appreciated). • Capable of hands-on coding and technical execution (SQL, DAX, dataflow orchestration) in tandem with high-level architectural duties. • Demonstrated ability to drive projects from requirements analysis through to delivery—leading the team and setting technical direction. • Prior experience integrating SAP financial, manufacturing, and order data into Azure cloud data lake architectures. • Strong interpersonal and communication skills, with the ability to translate business needs into technical requirements for the team.