19 Nov
|
NetworkPedia
|
Edmonton
19 Nov
NetworkPedia
Edmonton
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 – ContractInterview Mode – Virtual InterviewAbout the RoleThe 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) workplace.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 OverviewThe 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 architectureImproved data governance and qualityEnhanced reporting performance and responsivenessPreservation of historical court dataImproved business intelligence and analytics capabilitiesReduced reporting complexity and maintenance costsKey ResponsibilitiesData Warehouse Design & Data ModelingReview and analyze existing reporting data marts and warehouse structuresPerform detailed data profiling and source system analysisDesign enterprise data models, dimensions, facts, mappings, and transformation specificationsUpdate and enhance existing JOIN data models to support new reporting requirementsIdentify and define dimensional models and fact tables for enterprise reporting solutionsETL Development & Data IntegrationDesign, develop, test,
and optimize ETL processesStage and transform source data into enterprise reporting structuresValidate data quality, completeness, and integrity throughout data movement processesSupport ongoing enhancements and maintenance of delivered data warehouse componentsBusiness Intelligence & ReportingDevelop and support Power BI reports and dashboards for testing and validation purposesSupport business intelligence initiatives utilizing enterprise reporting platformsValidate dimensions, facts, metrics, and reporting outputsAssist with user acceptance testing and quality assurance activitiesArchitecture Governance & Stakeholder EngagementFacilitate enterprise architecture reviews and design governance activitiesProvide architectural guidance, consulting, and recommendations to project teamsParticipate in architecture review boards and solution design sessionsCollaborate with business, technical, and executive stakeholders to ensure alignment with enterprise strategiesProject Support & Knowledge TransferAddress minor enhancements and fixes within delivered data martsSupport project closeout activities including lessons learned and recommendationsProvide documentation, knowledge transfer, and operational guidanceMandatory Skills & QualificationsEducationCollege Diploma or bachelor's degree in computer science, Information Technology, Data Management, or a related field8+ years of experience designing, planning, implementing, and supporting enterprise solution databases in large and complex environments8+ years of experience documenting enterprise database architectures and data solutions8+ years of experience with enterprise architecture principles, methodologies, standards,
and governance frameworksData Warehouse & Data Modeling5+ years of experience designing and implementing enterprise architecture database plans and data models aligned to business capabilities5+ years of experience implementing SQL-based Data Warehouse solutions5+ years of experience developing and supporting SQL databases5+ years of experience querying and analyzing data using Transact-SQL (T-SQL)Business Intelligence & Analytics5+ 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 platforms2+ years of experience using enterprise architecture and data modeling tools such as Power Designer, ER/Studio, ERwin, BPwin, and Rational RoseProject Delivery & Leadership3+ years of experience managing or supporting Agile-based application development initiativesExperience providing leadership, planning, estimation, architectural guidance, and solution presentationsExperience performing threat and risk assessments and presenting mitigation recommendations to senior leadershipPreferred QualificationsTOGAF Certification (The Open Group Architecture Framework)Public Sector or Government of Alberta experienceExperience working within justice, legal, court, or law enforcement data environmentsExperience with Enterprise Data Warehouse modernization projectsExperience with Azure-based analytics and reporting environmentsExcellent verbal and written communication skillsStrong analytical and problem‐solving abilitiesAbility to work independently and collaboratively within diverse teamsStrong conflict resolution and stakeholder management skillsAbility to manage competing priorities in a fast‐paced environmentWork Environment & Additional DetailsRemote within CanadaOccasional onsite meetings in Edmonton, Alberta (approximately 15% of total engagement)Candidates must be legally eligible to work within CanadaContractor must provide their own computer and equipment compatible with Azure Virtual Desktop (AVD)Enhanced Security Clearance may be requiredAdditional security clearances, including RCMP-level clearances, may be required during the engagement
📌 Data Architect (Edmonton)
🏢 NetworkPedia
📍 Edmonton