Project Name:
JIMS 3.0 (Justice Information Management System)
Scope:
Justice Information Management System (JIMS) 3.0 is a data integration project aimed to amalgamate, re-design and implement several disjointed reporting data marts containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent data mart and views. This project will replace the existing six stand-alone IBM Cognos BI data marts JIMS, Crown File Ownership (CFO), Court Case Management (CCM), Courtroom Utilization, Courtroom Activity, and Case Adjournment) with a well-integrated data warehouse. The existing data marts extract, process, re-structure and aggregate data required for strategic, operational and ad hoc reporting of court data stored in the Justice Online Information Network (JOIN) database. The goal of the project is to evolve availability, governance and reporting of court data by implementing a more efficient, user-friendly, faster and cost-effective reporting architecture. The following benefits will be realized through the project:
Integrated and dynamic architecture
Interactive reporting
Reporting lag
Preservation of historical data
Improved data governance
This Senior Data Architect role will:
review existing data marts,
perform detailed data profiling,
analyze and create design and mapping specifications,
identify Dimensions required for Facts,
complete detailed data profiling of tables included in Facts,
develop and test Extract Transform Load (ETL) processes,
develop Power BI reports for testing for several Dimensions,
testing of Dimensions and Fact for quality assurance
update JOIN as-is data models for new Fact attributes,
stage the required data
address minor fixes in delivered data marts,
provide feedback and lessons learned at project close out.
Duties:
Facilitate the effective definition and management of the data architecture (e.g. principles, strategies, architectures, methods, design principles, models, standards, guidelines, plans, etc.);
Encourage data models and practices that reduce data redundancy by promoting reuse/sharing (in keeping with the IMT strategy);
Identify and document enterprise data requirements;
Encourage practices that improve data quality;
Develop and lead the transition plans that will guide current data to its ideal future state;
Lead or assist in communication activities surrounding the Sectors and Government of Alberta Enterprise Architecture (GAEA) data architecture;
Contribute to the definition and development of the enterprise architecture framework, and associated corporate solution design and delivery methods, thus improving the proactive alignment of data architecture;
Respond to requests for extensions to the scope of the data architecture;
Provide information, advice, guidance, and consultancy to initiatives/projects that are defining or aligning to the data architecture – thus promoting compliance to the data architecture and IMT strategies;
Establish and participate in design reviews, regular or ad-hoc architectural reviews – ensuring correct interpretation of the data architecture, and IMT strategies; and
Provide support to other members of the enterprise architecture team as required
Data Architect - Senior (REMOTE) JP995 • Edmonton, AB, Canada
At Stantec, we have some of the world’s leading professionals passionate about enabling our business to be its best.Our business teams include finance, procurement, human resources, information tec... Voir plus
A leading cybersecurity firm is seeking a Principal Consultant for their Zero Trust Advisory practice in Toronto.This role involves leading complex client engagements and transforming security arch... Voir plus
A leading digital transformation firm in Canada seeks an experienced Senior Digital Architect to lead the solution architecture for digital services.This role involves guiding teams in implementati... Voir plus
Job Title – Senior Data Architect (Enterprise Data Warehouse & Business Intelligence).Location – Edmonton, AB (Remote) (Travel once a month for onsite meetings in Edmonton, AB).Interview Mode – Vir... Voir plus
Senior Azure Databricks Architect.Python skills and a passion for building scalable data solutions in the cloud? Join our team to lead architecture, optimize pipelines, and drive innovation across ... Voir plus
A leading global professional services firm is looking for a Snowflake Data Architect to join their AI & Data practice.The role involves leading solution architecture for Snowflake projects, develo... Voir plus
Data Elephant is a boutique data and analytics consulting firm based in Vancouver, BC, helping Canadian organizations develop data strategies, modernize their data platforms and unlock the power of... Voir plus
AltaML is a leading North American applied AI company with extensive experience in building and operationalizing AI software solutions.We are a company like no other – we believe in making small be... Voir plus
Senior Information Architect /Data Engineer (Remote Initially).Job Openings Senior Information Architect /Data Engineer (Remote Initially).About the job Senior Information Architect /Data Engineer ... Voir plus
Elevate data ecosystems as a Senior Solutions Architect, focusing on Databricks and AWS.This role allows you to design impactful, cloud-native data architectures remotely.As a key player in our arc... Voir plus
A leading recruitment agency is seeking a Senior Information Architect / Data Engineer for a remote position.The role involves leading the architecture of a cloud data platform, requiring extensive... Voir plus
A client in the Fintech space is looking for a Lead Architect to evolve their core technology architecture across cloud infrastructure, distributed systems, data platforms, and AI-enabled systems.T... Voir plus
A leading financial data company is seeking an Equity Research Analyst to build a premier data product for investors.This remote role requires a strong finance background and 2-5 years of relevant ... Voir plus
Get AI-powered advice on this job and more exclusive features.This range is provided by Confidential Company.Your actual pay will be based on your skills and experience — talk with your recruiter t... Voir plus
Stantec is looking for a Senior Application Architect that will be responsible for designing and overseeing the architecture of various software systems.The Senior Application Architect role ensure... Voir plus
A leading data consulting firm in Canada is seeking a Senior Databricks Architect to guide clients through their data modernization journeys.In this senior technical leadership role, you will be re... Voir plus
Seeking a Senior Data Architect for a full-time, 12-month contract to design and implement cloud-based semantic architectures, knowledge graphs, and AI-enabled data services.Role involves data gove... Voir plus
A leading technology solutions provider is seeking a Senior Solutions Architect specializing in Databricks and AWS.This fully remote role requires 8+ years of experience, where you'll lead the desi... Voir plus
A growing technology firm in Toronto, Ontario is seeking a Lead Data Engineer to spearhead the migration of its data infrastructure from a monolithic to a microservices-based architecture.This is a... Voir plus
A leading PHP framework company is seeking a Solutions Architect to drive revenue growth and market expansion.Responsibilities include managing key enterprise accounts and closing complex sales cyc... Voir plus
