Description

You will design and implement scalable, enterprise-wide data architectures supporting analytics and reporting.

Responsibilities

• Lead the transformation of transactional data into dimensional models using Kimball methodology.
• Architect, manage, and evolve the Enterprise Data Warehouse (EDW), including data lineage and relationships.
• Design and maintain data pipelines using Azure Data Factory and Azure Synapse pipelines.
• Design and implement Power BI dashboards and reports that support executive decision-making.
• Define and enforce data governance frameworks, metadata management, and architectural standards.

Required Skills

• 12+ years overall experience in data architecture, warehousing, and BI.
• 8+ years building relational and dimensional data models using Kimball methodology.
• 5+ years developing Power BI reports and datasets.
• 5+ years working with EDWs and ETL processes.
• 2+ years hands-on experience with Azure Synapse pipelines.
• Strong expertise in Microsoft SQL Server, T-SQL, SSIS, and DAX.
• Proven experience designing Tabular models in Power BI Premium.
• Solid understanding of Azure Data Lake and Azure data platform services.
• Excellent communication and stakeholder management skills.

Preferred Skills

• Experience with data governance frameworks like DAMA-DMBOK.
• Familiarity with data catalog and metadata tools (Azure Purview, Collibra).

Key Skills

Education

Bachelor's degree