Senior Data Architect - Hybrid

Alberta Energy Regulator; Calgary; Hybrid; CAD 116,000 - 147,000; Full time

Job summary

An established industry player is seeking a Senior Data Architect to lead the design and delivery of scalable and secure data architecture. In this pivotal role, you will collaborate with various stakeholders to translate business needs into effective data solutions. This hybrid position offers a unique blend of hands-on architecture and strategic alignment, ensuring the evolution of enterprise data practices. Join a forward-thinking organization that values innovation, diversity, and collaboration, and be part of shaping a sustainable future in Alberta.

Benefits

Flexible Work Program

Defined benefit pension plans

Generous vacation entitlement

Flexible benefits program options

Great benefits from day one

Qualifications

• 7-10 years of experience in data architecture and design.
• Expertise in cloud data architecture and scalable solutions.
• Strong leadership and mentorship capabilities.

Responsibilities

• Lead data architecture and design efforts across projects.
• Translate business requirements into data models.
• Guide teams in data architecture options and solutions.

Skills

Data Architecture

Data Modeling

SQL Scripting

Cloud Data Solutions

Leadership

Mentorship

Performance Tuning

Education

Bachelor's degree in Computer Science

Tools

ER/Studio

Microsoft Visio

Job description

Location: Calgary, Alberta

Employment Type: Full Time – Permanent

Salary Range: SP4, Level 6, $116,960.00 - $146,200.00 per year. The final compensation for this position will be determined based on individual factors, including education, qualifications, experience, and internal equity.

Senior Data Architect - Hybrid

The Opportunity

The Alberta Energy Regulator (AER) is currently seeking a Senior Data Architect to join the Information Management Technology (IMT) branch. The Senior Data Architect leads the design and delivery of scalable, secure, and business-aligned data architecture across multiple projects. In this strategic role, you will guide data architects and modelers, ensuring alignment with enterprise modeling standards and semantic consistency.

In this role you will collaborate with Solution Architects and Product Owners to translate business requirements into effective data solutions, while working with the Data Practice Leads to drive governance, standardization, integration and the evolution of enterprise architecture practices.

This is ablended role: parthands-on architecture and modeling, partmentorship and coordination, and partstrategic alignmentwith the broader enterprise data ecosystem.

What your day-to-day will look like:

• Collaborate with the Product Owner and Solution Architect to lead the data architecture and design efforts. Implement scalable, secure, and high-performing solutions across multiple projects, ensuring alignment with business needs and enterprise strategy.

• Translate business and system requirements intoconceptual, logical, and physical data modelsthat support operational systems and analytics platforms, ensuring alignment with enterprise model.

• Guide Data and Solution Architects with data architecture options, ensuring solutions align with application and infrastructure designs and meet business needs.

• Design and implementdata access mechanisms(e.g., views, stored procedures, materialized views) to enable performant, secure data APIs for consuming systems and services.

• Developdata sharing strategiesand technical solutions that enable governed, secure, and efficient data exchange across systems and external stakeholders.

• Conductdata migration assessmentsand develop implementation plans to support legacy modernization, cloud transitions, and new platform adoption.

• Collaborate with thePrincipal/Enterprise Data Modelerto:

  • Align project-level data models to theenterprise data model(s)and semantic standards

  • Apply standardized conceptual/logical models in solution delivery

  • Harmonize project-specific terms, definitions, and domain boundaries with enterprise-level data design

• Partner with theData Architecture and Data Engineering Practice Leadsto define, refine, and promoteenterprise-wide best practicesfor:

  • Data architecture and integration standards and templates, naming conventions and metadata management.

  • Performance tuning, data security and privacy, and strategies to ensure data availability, SLAs, and failover for robust and resilient solutions.

  • Adoption, adherence, and continuous evolution of architecture patterns.

• Support governance and compliance with different architecture domains through project delivery

• Providetechnical leadership and mentorshipto project-level Data Architects and Data Engineers, ensuring consistent quality, reusability, and standards compliance.

• Maintain comprehensivedata architecture documentation, including data models, mappings, lineage, and flows to support traceability, reuse, and audit-readiness.

What we’re looking for in you:

• Bachelor's degree in Computer Science, Information Systems, or a related field.

• 7–10 years of progressive experience in data architecture and design for software development, including at least 5 years of delivering enterprise IT data services solutions for analytics.

• Proven expertise in designing and delivering end-to-end data architecture solutions, including conceptual, logical, and physical data models, data flows, mappings, and other key artifacts for both technical and non-technical audiences.

• Extensive experience in cloud data architecture, with a strong track record of implementing scalable, secure, and resilient data solutions from design to deployment—preferably within regulated industries such as oil and gas or government.

• Expert-level proficiency in data modeling using tools such as ER/Studio, Microsoft Visio, or equivalent and SQL scripting (DDL/DML), with hands-on experience optimizing data solutions for performance, scalability, and maintainability.

• Strong leadership and mentorship capabilities, with the ability to guide technical teams, communicate complex architectural patterns clearly, and foster alignment across business and IT stakeholders.

• Highly organized and adaptable, with a demonstrated ability to manage multiple initiatives in fast-paced environments, prioritize effectively, and respond to evolving business needs and timelines.

Additional Information:

• All applicants must be legally entitled to work in Canada at the time of application.

• Should an individual with the required qualifications not be available, applicants with closely related qualifications may be considered. As a result, the position may be redesigned and/or reclassified.

• If you need accommodation during any stage of the recruitment process, please email [e-mail]. Information relating to the need for accommodation and accommodation measures will be addressed confidentially.

What we offer you:

• Great benefits from your first day of work

• Flexible Work Program - hybrid work and flexible hours

• Defined benefit pension plans

• Flexible benefits program options, including Personal & Health spending account(s)

• Generous vacation entitlement and flex days

More information about working at the AER including our comprehensive Total Rewards package can be found in the careers section of our website https://www.aer.ca/providing-information/about-the-aer/careers/what-we-offer.

Our Commitment to Diversity:

At the AER, our values of Accountability, Collaboration, Transparency, and Trust & Respect are foundational to our culture – a culture where every individual, regardless of race, colour, religion, gender, national origin, age, disability, or any other legally protected factors, thrives and contributes their unique perspectives.

Our commitment to diversity, equity, and inclusion fuels innovation, creating a brighter, more sustainable Alberta for all. Join us in shaping this dynamic future.

Application closing date: May 16, 2025, at midnight

#LI-HYBRID