We are looking for a seasoned data professional to support the Client Data Delivery Team in designing and building scalable, future-proof data assets within the Microsoft Azure ecosystem. This role involves technical consulting, hands-on development, and leadership in data modelling, orchestration, and semantic layer design. Key Responsibilities: • Provide technical consulting to the Data Engineering Manager during the design phase. • Collaborate with a small team of Business Data Engineers to build new data assets. • Lead the design and development of dimensional data models and Power BI semantic models. • Replace legacy SAP Business Objects universes with modern Azure-based solutions. • Utilize Azure Data Factory (ADF), stored procedures, and Azure Synapse for data processing. • Guide the team on best practices, architecture, and documentation standards. • Engage with stakeholders to ensure solutions are aligned with business needs. • Integrate metadata sourcing from Collibra and support model curation using tools like Tabular Editor. • Participate in agile ceremonies, code reviews, and solution design reviews. Required Skills & Experience: 12 years of experience in data engineering domain with 5 years of experience in designing Data Warehouses, Medallion Architecture Experience to translate technical business requirements in data models. Proven experience in designing and implementing dimensional models and semantic layers. Strong expertise in Azure Synapse/ MS Fabric, and other related Azure Data management services such as ADF, SQL database, ADLS/ Storage Accounts, and Power BI. Familiarity with metadata management tools (e.g., Collibra) and model curation tools (e.g., Tabular Editor). Excellent communication and stakeholder management skills. Experience working in agile environments and leading technical teams.