What are the responsibilities and job description for the Enterprise Data Warehouse Architect position at Jobgether?
This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Enterprise Data Warehouse Architect based in Canada.
This role offers the opportunity to shape the architecture of a modern enterprise data ecosystem during a major transformation.
You will define current-state, transition-state, and target-state architectures aligned with business and technology strategies.
A key focus will be supporting the modernization of the data platform through Microsoft Fabric and cloud-based capabilities.
You will design data models, integration patterns, data flows, and architecture roadmaps that enable scalable analytics and information management.
The role involves close collaboration with enterprise architects, technical teams, product leaders, delivery teams, and business stakeholders.
You will also help establish data architecture, modeling, governance, and integration standards across a complex enterprise environment.
This is a high-impact contract engagement suited to an experienced architect who can operate independently and provide clear technical leadership.
- Assess current-state data architectures, models, integrations, systems, and data flows to identify modernization opportunities.
- Define transition-state and target-state data architectures aligned with business objectives, technology strategies, and industry best practices.
- Develop architecture roadmaps supporting migration to Microsoft Fabric and adoption of modern data platform capabilities.
- Design and maintain conceptual, logical, and physical data models that support enterprise data requirements.
- Design and document end-to-end data flows, integration patterns, transformation approaches, and data lifecycle processes.
- Analyze existing systems and recommend opportunities for rationalization, modernization, improved data quality, and greater architectural efficiency.
- Collaborate with data architects, systems architects, enterprise architects, product managers, delivery teams, and business stakeholders to align data architecture with business capabilities.
- Establish and promote standards, principles, patterns, and best practices for data architecture, modeling, governance, and integration.
- Provide architectural guidance, technical reviews, and recommendations to implementation and engineering teams.
- Evaluate and recommend approaches for data integration, reporting, analytics, information management, and enterprise data platforms.
- Contribute to the continued evolution of enterprise data architecture, governance, metadata management, and master data practices.
Requirements:
- 10 years of professional experience in data architecture, with demonstrated ownership of complex enterprise data initiatives.
- Proven experience defining current-state, transition-state, and target-state architectures and developing data modernization roadmaps.
- Hands-on experience with Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory, medallion architecture, and analytics capabilities.
- Strong experience with cloud-based data modernization and contemporary enterprise data platforms.
- Advanced expertise in conceptual, logical, and physical data modeling.
- Strong experience designing data integration, transformation processes, and end-to-end data flows.
- Experience with architecture and data modeling tools, preferably Sparx Enterprise Architect.
- Experience with business architecture or enterprise architecture in complex organizations.
- Strong understanding of data governance, metadata management, and master data management.
- Experience with Power BI and enterprise analytics environments.
- Familiarity with TOGAF or another recognized enterprise architecture framework.
- Advanced written and verbal communication skills, with the ability to explain complex technical concepts clearly to both technical and non-technical audiences.
- Strong analytical, problem-solving, and decision-making abilities, combined with meticulous attention to detail.
- Ability to manage competing priorities, adapt to changing requirements, and work effectively across multiple initiatives.
- Strong interpersonal and leadership skills, with the ability to influence stakeholders and guide data transformation across projects, departments, and divisions.
- Demonstrated ability to work independently and deliver practical architectural solutions within complex enterprise environments.
Benefits:
- 6-month contract initially, with potential continuation at the client's discretion.
- Remote working arrangement.
- 8 billable working hours per day.
- Opportunity to contribute to a large-scale enterprise data modernization initiative.
- Exposure to Microsoft Fabric, cloud data platforms, enterprise architecture, analytics, and data governance.
- Opportunity to influence target-state architecture, modernization roadmaps, and long-term data strategy.
- Collaboration with senior technical, business, and delivery stakeholders across a complex enterprise environment.
How Jobgether works:
We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.
We appreciate your interest and wish you the best!
Why Apply Through Jobgether?
Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.
#LI-CL1