Description
This position will play a key role in enhancing EPAs Digital Regulatory Assurance System. The position is in a high performing team, working in a fast-paced, agile environment.
A. Reducing duplication in EPEA and WA Monitoring Report Templates
• Identify overlapping parameters, metrics, and calculations across monitoring and reporting templates across programs and regulatory regimes.
• Define and maintain canonical data elements (e.g., facility, authorization, activity, parameter, time, location) to support consistent interpretation and reuse.
• Rationalize template designs to reduce redundancy and prepare them for ingestion into standardized data structures.
B. Designing Streamlined Data Structures
• Translate manual, upload oriented reporting templates into analytics ready data structures, including:
– Object / fact tables (e.g., sample observations, measurements, monitoring events)
– Dimension tables (e.g., facility, source, program, parameter, geography, time)
• Lead and steward the Unified Business Object model for EPEA Approvals and related regulatory domains by defining:
– Core business objects
– Attributes and relationships
– Authoritative definitions shared across DRAS and the DMP
• Define structural standards, including:
– Row level grain
– Column and attribute consistency
– Versioning, corrections, and historical traceability
• Document and maintain a traceable record of architectural decisions and their rationale.
• Translate finalized data model designs into engineering specifications (e.g., schemas, ingestion contracts, transformation expectations, and data quality rules)for the data engineering team, provide design guidance during pipeline build, review platform implementations for structural conformance and surface any deviation from canonical model intent before data reaches analytical layers.
C. Preparing Data for Advanced Analytics (Databricks)
• Design data structures that support advanced analytical use cases, including:
– Aggregation and roll ups
– Trend analysis
– Anomaly and outlier detection
– Future machine learning and predictive use cases
• Ensure data structures are:
– Normalized where semantic clarity and governance are required
– Denormalized where performance and analytical usability matter
• Establish and maintain a structured model feedback loop with the data analysts, including regular review of validation findings, edge case reports, and prototyping results to inform schema evolution decisions.
• Plan for schema evolution, enabling future environmental monitoring and reporting needs to be accommodated with minimal disruption while preserving analytical continuity.
Incumbency:
• Net new role
Scoring Methodology:
Financial/Pricing: 10%
Resource Qualifications: 30%
Interview Process: 60%
Qualifications
The Prospective Contingent Resource’s relevant qualifications are to be detailed within the attached resume in order to validate the relevancy/duration of all claimed experience.
Qualification
Description
Expected
Current
Must Have
Education
Yes/No- Attach a College or Bachelor degree in Computer Science or a related field of study
Attach a College or Bachelor degree in Computer Science or a related field of study to the end of the resume
Yes
Yes
No
Work Experience
Duration – Experience designing, planning, implementing and supporting enterprise solution…
Experience designing, planning, implementing and supporting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta.
8
years
years
Duration – Experience documenting enterprise solution databases in an environment equivalent in…
Experience documenting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta.
8
years
years
Duration – Experience with enterprise architecture principles and associated best practices…
Experience with enterprise architecture principles and associated best practices, methods, standards, tools, policies, and processes.
8
years
years
Duration – Experience working as a Data Architect in an enterprise IT environment equivalent in…
Experience working as a Data Architect in an enterprise IT environment equivalent in size and complexity to the Government of Alberta.
8
years
years
Nice to Have
Professional Licenses/Certification
Yes/No -Attach a Certification in The Open Group Architecture Framework (TOGAF).
Attach a Certification in The Open Group Architecture Framework (TOGAF) to the bottom of the resume
Yes
Yes
No
Work Experience
Duration – Experience Designing and implementing enterprise architecture database plans and…
Experience Designing and implementing enterprise architecture database plans and models that help align an organization’s data, information or technology with it’s required business capabilities in a large enterprise IT environment equivalent size and complexity to the Government of Alberta.
5
years
years
Duration – Experience in performing threat and risk assessments and presenting recommendations…
Experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management.
3
years
years
Duration – Experience in using a tool for architecture models such as: PowerDesigner, ER Studio…
Experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose.
2
years
years
Duration – Experience project managing application development projects using Agile sprint…
Experience project managing application development projects using Agile sprint development.
3
years
years
Duration – Experience with enterprise business intelligence products such as Microsoft Power BI
Experience with enterprise business intelligence products such as Microsoft Power BI
5
years
years
Yes/No – Experience providing leadership, planning, estimating, and presentations of ideas and so…
Experience providing leadership, planning, estimating, and presentations of ideas and solutions.
Yes
Yes
No