About the position
DutiesIn this role, the data engineer will focus on designing, implementing, and supporting CER’s data engineering solutions. The responsibilities of this role include:
• Design, develop, test, deploy and support scalable and reliable data pipelines that integrate, cleanse, and structure data for analytics, reporting, system integration, and decision making;
• Design, develop and maintain data ingestion, transformation, and search services;
• Design, develop, test, deploy, and maintain CER’s customized data visualization solutions using established JavaScript frameworks such as React or Vue;
• Contribute to the design, management, and enhancement of CER’s data lake and data warehouse;
• Lead the collaboration with business and technical users to gather requirements, recommend appropriate technologies, and deliver effective data solutions;
• Play a key role in CER’s data projects focusing on improving the organization’s data governance, data management practices, and data integration.
Work environmentThe Canada Energy Regulator (CER) helps keep energy moving safely across Canada by reviewing projects, sharing energy information, and upholding world-class safety and environmental standards. Headquartered in Calgary, with regional offices in Montréal, Vancouver, and Yellowknife, the CER employs approximately 600 people.
Recognized as one of Canada’s Top 100 Employers, the CER is committed to a diverse, equitable, and inclusive workplace that reflects the communities we serve.
The CER is proud to be an employer of choice for Indigenous Peoples*. We support Reconciliation through meaningful actions, including access to Elders, cultural and community supports, paid and unpaid leave for traditional practices, one-on-one coaching, social and cultural events, and flexible work arrangements, including hybrid and telework options when needed.
*Indigenous Peoples refers to First Nation, Inuit, or Métis.
Intent of the process
Intent to staff one term position. (Approximately 1 year.)
A pool of fully or partially qualified candidates may be created to fill similar positions at the same or lower levels, security clearances, conditions of employment, and appointment types (e.g., term, acting, assignment, or permanent). This process may also result in a permanent appointment, even for candidates appointed on a temporary basis.
Positions to be filled
1
Important messages
This position is subject to CER’s Professional Institute of the Public Service of Canada Collective Agreement.
The benefits offered may be different than those offered in the greater public service.
The CER has the following forms of additional compensation that are separate from base salary, the eligibility for which is determined, in accordance with the provisions in the collective agreement or terms and conditions of employment for the duration period specified:
• Annual performance pay which includes elements of individual performance and corporate performance.
APPLICATION REQUIREMENTS:
The ability to communicate effectively in writing will be assessed throughout your application.
As part of your application, you will be required to answer screening questions related to the essential education and experience and asset qualifications. You must provide CLEAR, CONCRETE EXAMPLES with sufficient detail for each question. Responses such as “please refer to CV/résumé” will not be accepted. Applications that lack specific examples or sufficient detail may be rejected, as the Assessment Board must have enough information to determine whether the requirements are met.
Please ensure you provide a valid email address that remains active throughout the selection process. All updates, including invitations and results, will be sent by email. We encourage applicants to check their inbox and junk mail folders regularly to avoid missing important messages.
The CER requires applicants to submit their application online. Applications received via email will be rejected. Please submit your application by clicking “Apply”.
You need (essential for the job)
Your application must clearly explain how you meet the following
Education: Bachelor's degree in Computer science, Computer Engineering, Software Engineering, Statistics, Data Science, Mathematics, Engineering, or equivalent.
Learn more about degree equivalency.
Experience:
E1. Experience in designing, developing and supporting scalable data pipelines and data engineering solutions.
E2. Experience in designing and developing data models to enrich the analytical data sources for further usability and availability.
E3. Experience in designing, developing and supporting data visualization and other related software solutions.
E4. Experience in analyzing data from multiple sources, including relational databases, NoSQL databases, semi-structured and unstructured data sources.
Applied / assessed at a later date
OC1 Accountability & Results Orientation (Apply)
• Sets and meets deadlines and takes personal accountability for results.
• Pro-actively identifies potential problems and vulnerabilities and considers risks in decision making and action.
OC2 Leadership & Teamwork (Apply)
• Supports, encourages and actively acknowledges others’ contributions and accomplishments.
• Forms working relationships and shares knowledge across the organization.
OC3 Written Communication (Apply)
• Communicates clearly, concisely and effectively in writing.
OC4 Oral Communication (Apply)
• Communicates clearly, concisely and effectively orally.
Technical Competencies:
TC1 Design and develop data solution with SQL, Python, and other related tools (Apply)
TC2 Able to construct and integrate software components for all system layers, usually spanning numerous technologies such as Python, JavaScript, and ASP.NET/C# (Apply)
TC3 Design and maintain data models and data architecture (Apply)
Competency Level Definitions:
Apply is defined as demonstrating sound understanding of the competency and ability to apply and contribute.
You may need (asset qualifications)
May be applied / assessed at a later date
Asset Qualifications:
AQ1. Experience in data visualization and business intelligence, especially Power BI or Tableau.
AQ2. Experience in implementing Data Science, Machine Learning, and AI systems and solutions.
AQ3. Experience in designing and managing data warehouses and data lakes.
AQ4. Experience in analyzing business processes and data flows and defining data requirements.
AQ5. Experience in MS Azure or other cloud technologies.
AQ6. Experience in API development.
AQ7. Experience in data governance.
Organizational Needs:
To support employment equity objectives, diversity and inclusion and to meet business objectives, selection may be limited to a member self-identifying from the following Employment Equity group such as Visible Minority or Indigenous Peoples*.
* Indigenous Peoples refer to First Nations, Inuit or Métis of North America