Job Summary: 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.