Data Architect
NetworkPedia
Job Title – Senior Data Architect (Enterprise Data Warehouse & Business Intelligence)
Location – Edmonton, AB (Remote) (Travel once a month for onsite meetings in Edmonton, AB)
Employment Type – Contract
Interview Mode – Virtual Interview
About the Role
The Government of Alberta is seeking an experienced Senior Data Architect to support the Justice Information Management System (JIMS) 3.0 initiative, a strategic enterprise data modernization program focused on transforming multiple legacy court reporting data marts into a centralized Enterprise Data Warehouse (EDW) environment.
This project will consolidate and modernize several independent IBM Cognos reporting solutions into an integrated, scalable, and governed reporting architecture that enhances data accessibility, reporting efficiency, historical data preservation, and enterprise-wide analytics capabilities.
The ideal candidate will possess extensive experience in data architecture, enterprise data warehousing, ETL development, data modeling, business intelligence, Power BI, SQL Server, and enterprise data governance within large and complex public‑sector environments.
Project Overview
The JIMS 3.0 program is designed to modernize reporting and analytics across Alberta Justice by replacing multiple standalone court‑related reporting data marts with a centralized Enterprise Data Warehouse. The initiative will deliver:
- Integrated enterprise reporting architecture
- Improved data governance and quality
- Enhanced reporting performance and responsiveness
- Preservation of historical court data
- Improved business intelligence and analytics capabilities
- Reduced reporting complexity and maintenance costs
Key Responsibilities
Data Warehouse Design & Data Modeling
- Review and analyze existing reporting data marts and warehouse structures
- Perform detailed data profiling and source system analysis
- Design enterprise data models, dimensions, facts, mappings, and transformation specifications
- Update and enhance existing JOIN data models to support new reporting requirements
- Identify and define dimensional models and fact tables for enterprise reporting solutions
ETL Development & Data Integration
- Design, develop, test, and optimize ETL processes
- Stage and transform source data into enterprise reporting structures
- Validate data quality, completeness, and integrity throughout data movement processes
- Support ongoing enhancements and maintenance of delivered data warehouse components
Business Intelligence & Reporting
- Develop and support Power BI reports and dashboards for testing and validation purposes
- Support business intelligence initiatives utilizing enterprise reporting platforms
- Validate dimensions, facts, metrics, and reporting outputs
- Assist with user acceptance testing and quality assurance activities
Architecture Governance & Stakeholder Engagement
- Facilitate enterprise architecture reviews and design governance activities
- Provide architectural guidance, consulting, and recommendations to project teams
- Participate in architecture review boards and solution design sessions
- Collaborate with business, technical, and executive stakeholders to ensure alignment with enterprise strategies
Project Support & Knowledge Transfer
- Address minor enhancements and fixes within delivered data marts
- Support project closeout activities including lessons learned and recommendations
- Provide documentation, knowledge transfer, and operational guidance
Mandatory Skills & Qualifications
Education
- College Diploma or bachelor’s degree in computer science, Information Technology, Data Management, or a related field
- 8+ years of experience designing, planning, implementing, and supporting enterprise solution databases in large and complex environments
- 8+ years of experience documenting enterprise database architectures and data solutions
- 8+ years of experience with enterprise architecture principles, methodologies, standards, and governance frameworks
Data Warehouse & Data Modeling
- 5+ years of experience designing and implementing enterprise architecture database plans and data models aligned to business capabilities
- 5+ years of experience implementing SQL-based Data Warehouse solutions
- 5+ years of experience developing and supporting SQL databases
- 5+ years of experience querying and analyzing data using Transact-SQL (T-SQL)
Business Intelligence & Analytics
- 5+ years of experience with enterprise reporting and analytics platforms including Microsoft Power BI and Microsoft SQL Server Reporting Services (SSRS)
- 5+ years of experience working with cloud computing environments and/or big data platforms
- 2+ years of experience using enterprise architecture and data modeling tools such as Power Designer, ER/Studio, ERwin, BPwin, and Rational Rose
Project Delivery & Leadership
- 3+ years of experience managing or supporting Agile-based application development initiatives
- Experience providing leadership, planning, estimation, architectural guidance, and solution presentations
- Experience performing threat and risk assessments and presenting mitigation recommendations to senior leadership
Preferred Qualifications
- TOGAF Certification (The Open Group Architecture Framework)
- Public Sector or Government of Alberta experience
- Experience working within justice, legal, court, or law enforcement data environments
- Experience with Enterprise Data Warehouse modernization projects
- Experience with Azure-based analytics and reporting environments
- Excellent verbal and written communication skills
- Strong analytical and problem‑solving abilities
- Ability to work independently and collaboratively within diverse teams
- Strong conflict resolution and stakeholder management skills
- Ability to manage competing priorities in a fast‑paced environment
Work Environment & Additional Details
- Remote within Canada
- Occasional onsite meetings in Edmonton, Alberta (approximately 15% of total engagement)
- Candidates must be legally eligible to work within Canada
- Contractor must provide their own computer and equipment compatible with Azure Virtual Desktop (AVD)
- Enhanced Security Clearance may be required
- Additional security clearances, including RCMP-level clearances, may be required during the engagement
Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Data Architect in Edmonton, AB vacancy
$128k - $180k per year
...vision, making it a dynamic and fulfilling workplace. Together, we transcend the ordinary and achieve extraordinary results. Data Architect We are seeking an experienced Data Architect to join our team at Lantern. In this role you will play a crucial role in designing...Suggested- Lead revolutionary data initiatives as a Senior Microsoft Fabric & Power BI Architect in a hybrid model. Shape the future of data management and reporting systems. We seek an architect to spearhead a vital modernization project for our Housing Division, focusing on creating...Suggested
- A government agency in Canada is seeking a Senior Data Architect to lead the design and delivery of data architectures for the OneData Alberta and Crosswalk initiatives. This role plays a critical part in establishing data governance, fostering innovation, and ensuring alignment...Suggested
- ...Data Architect position is responsible for establishing effective data practices in line with organizational goals. This role involves designing enterprise-level data storage and access solutions, integrating information from various sources, and leading key data projects while...SuggestedInternshipRemote workFlexible hours
Servus Credit Union
Edmonton, AB10 hours ago - ...Scope: Justice Information Management System (JIMS) 3.0 is a data integration project aimed to amalgamate, re-design and implement... ...historical data Improved data governance This Senior Data Architect role will: review existing data marts, perform detailed data...SuggestedRemote jobInternship
- ...Project Name: One Data Alberta Program and Crosswalk Scope: The Data Centre of Excellence (DCoE) requires a Senior Data Architect to support the delivery of key roadmap items for the OneData Alberta and Crosswalk initiatives. The Government of Alberta's approach...Remote jobShift work
- Drive data architecture at Servus Credit Union, focusing on innovative data practices and solutions. This remote role seeks seasoned experts... ...and data management. Join Servus Credit Union as a Data Architect, responsible for designing enterprise-level data storage solutions...Remote work
Servus Credit Union
Edmonton, AB10 hours ago - ...Staffing/Consulting organization recruiting for a long-term contract role for one of our premier clients in Canada, for a Mainframe Architect position. Location: Canada (Remote). Employment type: Contract. Seniority level: Mid-Senior. Responsibilities ~ Designing...Long term contractContract workRemote work
- ...challenging work assignments in a supportive work environment which promotes personal and professional growth. We are seeking a Data Science Student for our Canadian Industrial Division district office in Edmonton, AB, that is available for 8 or 12 months starting...Temporary workInternshipWork at officeRemote work
- ...div.unify-button-container .unify-apply- Job Title: Enterprise Architect - Network & Connectivity City: Edmonton State/Province: Alberta... ...secure, scalable, and resilient connectivity across campuses, data centers, airports, and edge environments. This role focuses on...Long term contractFull time
- ...a company that has made a commitment to excellence? We are looking for a dynamic and results-focused Cloud and Infrastructure Architect for our Edmonton branch to design and deliver solutions across infrastructure, M365 and Azure Cloud – Public, Private, datacenter...Permanent employment
$104.1k - $138k per year
...Senior Landscape Architect – Alberta Landscape Architecture & Urban Design Location: Edmonton, Alberta As a senior member of the Landscape Architecture & Urban Design team, you will contribute to a diverse portfolio of projects in a leadership role while helping...Contract workWork at officeFlexible hours$50k per year
...On behalf of our public sector client, Affinity is looking for a Data Analyst to provide advanced data and analytical support to establish foundational enterprise data capabilities required for technology governance, financial oversight, asset and contract visibility, digital...Long term contractContract work- ...Project Name SAP Supply Chain Management (SCM) Solution Architect Scope The SAP SCM Solution Architect is the strategic leader... ..., enterprise wide perspective , ensuring that all systems, data flows, and business processes work together as a cohesive, scalable...Long term contractContract work
- ...We are seeking a highly experienced Operational Technology (OT) Architect to lead the design, security, and evolution of OT network environments... ...deployment and operation of process historians and industrial data platforms Conduct OT risk assessments, threat modeling, and...Long term contractFull timeTemporary workRemote work
- ...Position Title: AWS Solutions Architect- AI/ML Employment Time: Full-Time This Is a fully remote position with travel required.... ...and innovate in the cloud. We work at the intersection of cloud, data, and AI to solve real business problems and not just implement technology...Long term contractFull timeRemote work
- A leading technology consulting firm is looking for a Data Architect in Edmonton, Canada, to lead the design and implementation of data architectures for a public trustee solution. The ideal candidate will possess strong expertise in Microsoft Dynamics and cloud technologies...
$60k - $80k per year
...diverse portfolio across multifamily, high-end residential, and commercial projects. This is an excellent opportunity for an Intern Architect with excellent design skills to step into a highly involved, leadership-track role, working closely with the Principal across design...Permanent employmentInternship$26.05 - $33.17 per hour
...advanced Excel skills and strong proficiency with Microsoft Word and Google Apps strong mathematical, analytical problem solving and data entry skills excellent communication and customer service skills ability to work with tight deadlines Rate of Pay $26.05- $33...Hourly payFull timeTemporary workSeasonal workLocal area- ...Salesforce Solution Architect, Service Cloud Join to apply for the Salesforce Solution Architect, Service Cloud role at NeuraFlash Overview At NeuraFlash, part of Accenture, we are redefining the future of business through AI and groundbreaking technologies...Remote work
$41.64k per year
...Job Responsibility: As the TPP (Tracked Prescription Program) Data Entry Clerk , you will enter data from tracked prescriptions into a prescription database and handle telephone calls and emails placed to and received from TPP members, the public, and related organizations...Permanent employmentFull timeWork at office- ...Position Title: AWS Solutions Architect – Migration and Modernization Employment Time: Full-Time This Is a fully remote position.... ...and innovate in the cloud. We work at the intersection of cloud, data, and AI to solve real business problems and not just implement technology...Full timeRemote work
- ...meaningfully improve the wellbeing of our communities and the environment we all share. We are a multi-disciplinary practice of architects, interior designers, urban designers and planners, structural, mechanical and electrical engineers, landscape architects and...Full time
$64 - $80 per hour
Are you a Data Platform Developer GCP with experience supporting Data Analytics platform?. Our Alberta-based Financial client is seeking a Data Platform Developer for a 5 month contract. Client: Financial Services Duration: 5 months with a possibility for an extension...Contract workImmediate startRemote work- A leading consulting firm in Edmonton is seeking a skilled Data Solutions Developer to develop ETL standards and support data warehousing. The ideal candidate will have significant experience in ETL development, data quality assurance, and effective communication with diverse...
- Take on the role of Senior Operations Research Architect to revolutionize supply chains. Collaborate remotely to craft innovative optimization... ...optimization models • Background in working with high-volume data systems Harness your expertise to lead game-changing optimization...Remote work
$130k - $180k per year
...ordinary and achieve extraordinary results. Position Summary We are hiring an experienced Azure Infrastructure and Identity Architect to lead our most complex Microsoft Azure and Identity engagements to build the AI Foundations for our clients. This is a senior,...- Drive impactful data centre projects as a Senior Project Manager at Turner & Townsend in Edmonton. Lead large-scale construction efforts while managing stakeholder relationships and project complexities effectively. Turner & Townsend is looking for a dedicated Senior Project...Full time
- ...Project Name: Data Projects Scope: The Data and Content Management Division uses a one-government approach to information and privacy governance, decision-making, and service delivery across the Government of Alberta (GoA) balanced with individual client needs. This...Remote jobShift work
$68.2k - $98.9k per year
...passionate about collaboration and innovation? Do you want to be part of a global team committed to make community impact? Join our Enterprise Data & Analytics team as a Data Consultant to support data-driven decision-making and contribute to the future of our organization. We...Long term contractFull timeTemporary workPart timeCasual workFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Architect. Be the first to apply!
