Senior Data Architect - Hybrid

Location:

Calgary, Alberta

Employment Type:

Full Time – Permanent

Salary Range:

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 a blended role: part hands-on architecture and modeling, part mentorship and coordination, and part strategic alignment with the broader enterprise data ecosystem.

What your day-to-day will look like:

- Lead data architecture efforts with Product Owners and Solution Architects to deliver scalable, secure solutions aligned with business goals.

- Translate requirements into data models that support both operational systems and analytics.

- Advise on architecture options to ensure consistency with application, infrastructure, and business needs.

- Design and implement secure data access mechanisms for downstream APIs and services.

- Develop secure data sharing strategies for internal and external exchange.

- Conduct data migration assessments and create implementation plans for legacy modernization and cloud transitions.

- Align project data models with enterprise standards by working closely with the Enterprise Data Modeler.

- Define and promote best practices for data modeling, integration, naming conventions, and metadata management.

- Mentor Data Architects and Engineers to ensure quality and adherence to standards.

- Maintain comprehensive architecture documentation for traceability and audit readiness.

- Ensure consistency and integrity across development, testing, and production environments.

- Collaborate with developers and architects to uphold data quality, validation, and automation best practices.

What we’re looking for in you:

- Bachelor's degree in computer science, information systems, or a related field.

- 10+ years of experience in data architecture and design for enterprise solutions. - 5+ years supporting Agile delivery with adaptive data modeling.

- Proven ability to translate business needs into scalable data models.

- Expertise in full-stack data architecture (conceptual, logical, physical).

- Strong SQL skills; hands-on with Microsoft SQL Server and Azure Cosmos DB.

- Expert in IDERA ER/Studio for data modeling.

- Experience with cloud-based data architectures and CI/CD pipelines.

- Familiarity with DevOps practices.

- Proficient in hybrid data environments (relational + NoSQL/document stores).

- Skilled in distributed data modeling and cloud-native schema design.

- Strong background in metadata management and domain standardization.

- Experience defining and enforcing data standards and practices.

- Proficient with ETL/ELT, API-based sharing, and event-driven architectures.

- Experience supporting governance: lineage, data quality, MDM, and reference data management.

- Track record designing and delivering secure data sharing solutions.

- Experience in regulated industries (e.g., oil & gas, government).

- Effective leader and mentor with strong communication skills.

- Highly organized, adaptable, and capable of managing multiple priorities.

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 PeopleServices@aer.ca. 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 Hybrid work - employees may work remotely up to five days per calendar month, with a limit of two remote days per week.

- 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: September 12, 2025, at midnight