Location: Calgary Head Office, Alberta Employment Type: Full Time – Permanent Salary Range: SP4, Level 6, $116,960 - $146,200 per year. The final compensation for this position will be determined based on individual factors, including education, qualifications, experience, and internal equity. Senior Specialist, Data Engineering – Hybrid The Opportunity Do you have a strong passion for developing cloud-based data solutions that drive significant impact? The Alberta Energy Regulator (AER) is currently looking for a Senior Specialist, Data Engineering. This role will focus on modernizing and optimizing data flow across our IT solutions, thereby enhancing data collection, creation and management, advanced analytics, regulatory insights, and data-driven decision-making processes. As a Data Engineer, you will design, develop, and maintain scalable data pipelines and integration solutions using Microsoft Azure and Databricks technologies. Working closely with data architects, data modelers, solution teams, and business stakeholders, you’ll transform raw data into trusted assets — while contributing to AER’s strategic shift toward modern cloud-based platforms. What your day-to-day will look like: Build and optimize data pipelines using Azure-based tools (e.g., Data Factory, Databricks, Functions) to support enterprise data integration and analytics. Translate business requirements into robust technical solutions that align with AER’s data strategy and architecture standards. Ensure the performance, reliability, and scalability of data systems through best practices in engineering and DevOps. Collaborate with developers, analysts, and architects to maintain data consistency, quality, and governance across platforms. Participate in agile development processes, code reviews, automation, and CI/CD pipelines. Work on migrating/transforming legacy data workflows in Informatica to the new platform Support innovation through participation in proof-of-concepts and exploration of emerging data technologies. What we’re looking for in you: Bachelor’s degree in computer science, Software Engineering, or a related field. 5–7 years of experience in data engineering or integration, with cloud platform expertise. 3-4 years of experience and proficiency in Microsoft Azure data services (Data Factory, Databricks, Functions, Synapse, Storage). Proficiency in SQL, data modeling, and performance tuning for large-scale data pipelines and workflows. Hands-on experience with DevOps tools and practices, including version control (e.g., Git), CI/CD pipelines, and automated testing frameworks. Solid understanding of data quality, metadata management, data security, and governance principles. Experience supporting analytics and business intelligence platforms such as Tableau and Power BI, with a focus on preparing and integrating data to meet evolving reporting needs. Exposure to Informatica and participation in modernization or migration initiatives—particularly transitioning from Informatica-based solutions to Azure Databricks—is highly valued. Familiarity with enabling data science, AI, and machine learning initiatives through the development of optimized data pipelines is considered an asset. Knowledge of GIS systems and experience integrating spatial data into enterprise data platforms is beneficial. 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 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 26, 2025, at midnight #LI-HYBRID Make a difference. Be in great company. At the AER, a career goes beyond the paycheck. It’s an opportunity to follow your passion, apply your skills and make a meaningful difference in service of Albertans. We offer a competitive total rewards package, along with hybrid work and flexible work hours for eligible positions so you can thrive both personally and professionally. As the province’s sole regulator of oil, oil sands, natural gas, geothermal, minerals, and coal resource development, the AER’s responsibilities are notably diverse. It makes sense that our workforce is too. From scientists and field inspectors to regulatory analysts and engagement specialists, we seek talented people with strong technical and interpersonal skills, who share our commitment for doing what’s right. Does this sound like you? Apply today and join us in shaping Alberta’s resource future. Our Commitment to Diversity and Inclusion At the AER, our values of Accountability, Collaboration, Transparency, and Trust & Respect are foundational to our culture – a culture where every individual, regardless of background or identity of race, colour, religion, gender, national origin, age, disability, or any other legally protected factors, thrives and contributes their unique perspectives. We strive to create a community where people are treated fairly, feel connected to each other, and can bring their authentic selves to the office every day. Need Assistance? If you require accommodation during the interview process, contact us at PeopleServices@aer.ca. We will handle your request as confidentially as possible. For additional information, refer to the FAQs available here. If you're having trouble logging into the application tool, use the ‘Forgot Password’ button on the Sign-In page to reset your password. For other technical issues with submitting your application, contact us at PeopleServices@aer.ca.
