Job Description

Location: Calgary, Alberta

Employment Type: Full Time – Permanent

Salary Range: SP4, Level 6. The final compensation for this position will be determined based on individual factors, including education, qualifications, experience, and internal equity.

Enterprise Data Modeler - Hybrid

The Opportunity­­

The Alberta Energy Regulator (AER) is seeking an Enterprise Data Modeler who will play a key role in advancing our organization's data modeling practices and ensuring semantic consistency in business information and systems. This senior individual contributor role will be instrumental in developing our business information model and transforming it into both conceptual and logical data designs, guaranteeing smooth integration across various systems, platforms, and analytical environments - including our Data Hub built on medallion architecture.

You will oversee the standardization and semantic alignment of data definitions among various business units, direct the conversion of system-level data into models suitable for enterprise use, and assist with integration into the analytics platform. This strategic and technically demanding position involves close collaboration between business and technology teams to promote consistency, build trust in data, and maintain model integrity throughout the organization.

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 and Solution Practice Leads to embed modeling standards, naming conventions, and metadata practices into the enterprise data architecture framework.

• Collaborate with project Data Modellers and Architects to ensure solutions are aligned with enterprise data models; provide oversight 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.

• 8+ 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.

• This position will be subject to pre-employment background screening, including a criminal record check.

• 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 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: June 14, 2026, at midnight

#LI-HYBRID