Senior Data Modeler - Hybrid

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

Job summary

A leading organization in Alberta is seeking a Senior Data Modeler to enhance data modeling and semantic consistency. This strategic role involves collaboration across business and technology domains, ensuring enterprise-wide data integrity and alignment. The successful candidate will lead the development of business information models and mentor others in best practices. The position offers a hybrid work environment with competitive benefits.

Benefits

Flexible Work Program

Defined benefit pension plan

Generous vacation entitlement

Qualifications

• 7–10 years of experience in enterprise data modeling.
• Proven ability to define and evolve business information models.

Responsibilities

• Define and evolve the Enterprise Business Information Model.
• Translate the Business Information Model into conceptual and logical data models.
• Support Lakehouse data architecture implementation.

Skills

Leadership

Communication

Data Modeling

Collaboration

Education

Bachelor’s degree in Computer Science

Tools

ER/Studio

Microsoft Visio

Job description

Location: Calgary Head Office, 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 Modeler - Hybrid

The Opportunity

The Information Management & Technology (IMT) Branch of the Alberta Energy Regulator (AER) is seeking a Senior Data Modeler to shape the future of data modeling and semantic consistency across our organization. This high-level individual contributor role will be central to evolving our business information model and translating it into conceptual and logical data designs, ensuring seamless integration across systems, platforms, and analytical environments—including our cloud-based progressive data architetcure.

In this role you will lead the standardization and semantic alignment of data definitions across business units, guide the transformation of system-level data into enterprise-ready models, and support implementation in the analytics platform. This is a highly strategic and technically rigorous role that collaborates across business and technology domains, helping to ensure enterprise-wide consistency, data trust, and model integrity.

What your day-to-day will look like:

• Define and evolve the Enterprise Business Information Model in close partnership with business stakeholders, ensuring it reflects core business concepts, relationships, and semantics across domains.

• Translate the Business Information Model into conceptual and logical data models, enabling consistent, scalable design for transactional, operational and analytics integration.

• Drive semantic alignment across business and technical teams, maintaining shared data definitions, taxonomies and supporting the adoption of a unified enterprise vocabulary.

• Coordinate with the Data Architecture Practice Lead to embed modeling standards, naming conventions, and metadata practices into the enterprise data architecture framework.

• Collaborate with project Data Architects to ensure their solutions are aligned with enterprise data models; provide oversight and guidance to harmonize delivery with strategic design.

• Support Lakehouse data architecture implementation, ensuring logical models are translated into usable data structures across ingestion (raw), curation (trusted), and consumption (refined) layers, collaborating with data engineers and architects to translate logical models into analytics data architecture implementations (Data Lakehouse using Databricks).

• Serve as a subject matter expert on data modeling practices, mentoring architects and analysts, and contributing to the continuous improvement of modeling methodologies, tools, and processes.

• Contribute to architecture governance, participating in design reviews and modeling forums to ensure solutions remain compliant with enterprise data principles.

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 enterprise data modeling, including leading organization-wide conceptual and logical model development initiatives.

• Proven ability to define and evolve business information models by working directly with domain experts, ensuring alignment between business semantics and enterprise data design.

• Expertise in enterprise modeling tools such as ER/Studio, Microsoft Visio, or equivalent, with a strong track record of producing clear, reusable data models for both strategic planning and delivery enablement.

• Experience applying data modeling practices within complex, regulated environments—preferably in the energy, oil and gas, or government sector—where data consistency, lineage, and governance are critical.

• Demonstrated leadership in establishing and promoting enterprise modeling standards, including naming conventions, metadata structure, and semantic consistency, in collaboration with data architecture and governance teams.

• Strong communicator and facilitator with the ability to influence senior stakeholders, bridge gaps between business and technical teams, and mentor others in modeling best practices.

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 plan(s)

• 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 26, 2025, at midnight

#LI-HYBRID