Enterprise Data Warehouse Architect

Job Description

Enterprise Data Warehouse Architect
On behalf of our Public Insurance client, Procom is searching for an Enterprise Data Warehouse Architect for a 6-month role. This position is a remote position based in Winnipeg, Manitoba.

Enterprise Data Warehouse Architect - Job Description:
The project involves supporting the modernization of  data ecosystem and implementing a Microsoft Fabric-based data platform. The role will focus on defining current, transition, and target-state data architectures, and establishing data integration and modeling approaches to align with business and technology roadmaps.

Enterprise Data Warehouse Architect - Responsibilities:
• Assess current-state data architectures, data models, integrations, and data flows.
• Define target-state and transition-state data architectures aligned with business and technology strategies.
• Develop architecture roadmaps supporting migration to Microsoft Fabric and modern data platform capabilities.
• Design and maintain conceptual, logical, and physical data models.
• Design and document end-to-end data flows, integration patterns, and data lifecycle processes.
• Analyze existing systems and identify opportunities for rationalization, modernization, and improved data quality.
• Collaborate with data and systems architects, enterprise architects, product managers, delivery teams, and business stakeholders.
• Establish standards, principles, and best practices for data architecture, modeling, and governance.
• Support implementation teams by providing architecture guidance, reviews, and recommendations.

Enterprise Data Warehouse Architect - Mandatory Skills:
• 10+ years of experience in Data Architecture.
• Experience with Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory, medallion architecture, and analytics capabilities.
• Expertise in conceptual, logical, and physical data modeling.
• Experience designing data integration, transformation, and end-to-end data flows.
• Advanced written and oral communications skills.
• Advanced problem-solving and analytical skills.
• Leadership skills to lead data transformation and engineering development.

Enterprise Data Warehouse Architect – Nice-to-Have Skills:
• Experience with architecture and data modeling tools, preferably Sparx Enterprise Architect.
• Experience with data governance, metadata management, and master data management.
• Experience with Power BI and enterprise analytics.
• Experience with the open group architecture framework (TOGAF) or another enterprise architecture framework.
• Demonstrated ability to work independently in complex enterprise environments.

Enterprise Data Warehouse Architect – Assignment Length:
This is a 6-month contract position with the potential for two 12-month extensions.


Enterprise Data Warehouse Architect - Assignment Location:
Remote work based in Winnipeg, Manitoba, Canada.