data analyst Calgary
Job description
Calgary (Alberta)
EC-04, NB-08 - Equivalency See “Other Information” #1
$75,770 to $92,185 (Subject to revision)
For further information on the organization, please visit Canada Energy Regulator
Closing date: 15 June 2023 - 23:59, Pacific Time
Who can apply: Persons residing in Canada, and Canadian citizens and Permanent residents abroad.Apply online
Important messages
We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you need to be accommodated during any phase of the evaluation process, please use the Contact information below to request specialized accommodation. All information received in relation to accommodation will be kept confidential.
Assessment accommodation
The Federal Public Service is stronger and most effective when we reflect the diversity of the Canadian population we serve. The Canada Energy Regulator (CER) is dedicated to building and promoting a diverse, equitable and inclusive workforce, representative of all Canadians regardless of race, ethnicity, sex, age, disability, sexual orientation, gender expression, socio-economic background or lived experience.
Achieving a representative and diverse workforce has been identified as an organizational need for CER and may be applied at any time during this appointment process. If this criterion is used, only those who have indicated that they are members of the specified designated group(s) will be considered. As such, first consideration for an appointment may be given to candidates who self-declare as belonging to one of the four designated employment equity groups (Persons with a disability, Indigenous Peoples*, Members of a Visible Minority, or Women).
- Indigenous Peoples are people who are First Nation, Inuit or Métis.
In order to self-declare, please ensure to check off the appropriate box within the online application under the Employment Equity section. To learn more about self-declaring, we encourage you to consult the following two links to learn more about employment equity and self declaration:
https://www.canada.ca/en/services/jobs/opportunities/government/self-declaring-because-we-care.html
https://www.canada.ca/en/public-service-commission/jobs/services/gc-jobs/employment-equity.html
The CER is recognized as one of Canada's Top 100 Employers in a national competition to determine which employers lead their industries in offering exceptional workplaces for their employees.
Duties
As part of a multidisciplinary high-performing team supporting the CER as a world class regulatory, this position reports to the Director of the Facilities Central/North and Performance Team in the Energy Adjudications Business Unit. The Regulatory Data Analyst is expected to:
1) Collect, review, and analyse complex data and information related to oil and gas pipelines and facilities applications, operations, safety and environmental performance.
2) Analyze data for adjudication assessment processes and/or for resource planning purposes or as requested by other teams;
3) Assist BU staff with data research and extraction of data from internal and external databases;
4) Identify improvement opportunities, gather user requirements, and implement data projects;
5) Develop Tableau dashboards and visualize data to improve process efficiencies and support decision-making;
6) Contribute to improvement of internal data collection and management processes and practices;
7) Perform QA/QC on CER’s data and information;
8) Communicate frequently with regulatory adjudications staff and other internal and external stakeholders; give presentations and develop technical reports, briefings and memos;
9) Analyze emerging trends from application types, assessment process data and decision making activities and draw out meaningful conclusions regarding unit performance;
10) Liaise with other regulators, industry, associations, and technical experts to exchange and acquire information and knowledge on data management best practices;
11) Work in a multi-disciplinary team environment, consult with colleagues and senior technical specialists;
12) Project manage the production of quarterly and annual performance reports; and
13) Perform other related duties as required.
Intent of the process
Qualified candidates may be used to staff other similar positions at an equivalent or lower level on a term, indeterminate or acting basis.
Positions to be filled: 2
Information you must provide
Your résumé.
A covering letter
In order to be considered, your application must clearly explain how you meet the following (essential qualifications)
Education: Graduation from a recognized university with a degree related to the requirements of the position (e.g. Statistics, Computer Science, Business Analytics, Data Management, Engineering, Economics, etc.).
Degree equivalency
- Extracting, compiling and analyzing data from multiple sources, including SQL databases, Excel Spreadsheets, pdf files, etc. by using a computer code / program;
- Analyzing data related to regulatory adjudication assessment processes and/or compliance reporting including production data in order to support decision-making;
- Gathering and documenting user requirements for data or data system projects, identifying system and data gaps and implementing improvements.
If you possess any of the following, your application must also clearly explain how you meet it (other qualifications)
AQ1: Experience manipulating data with SQL, Python and/or R.
AQ2: Working knowledge of Tableau and/or Microsoft PowerBI.
AQ3: Functional knowledge of one or more areas of the Oil and Gas industry or regulatory body.
AQ4: Specialized expertise, post-graduate training or an advanced degree in the discipline related to the position.
AQ5: Experience in project management.
The following will be applied / assessed at a later date (essential for the job)
English essential
Information on language requirements
Second Language Writing Skills Self-Assessment
In order to help you decide if you should apply to a bilingual position, an optional self-assessment of your writing skills in your second official language is available for you to take before completing your application.
For more information, please consult:
Unsupervised Internet Test of Second Language Writing Skills
Organization-wide and Business Competencies: (Apply Level)
OC1: Leadership and Teamwork
OC2: Accountability and Results Orientation
OC3: Initiative and Adaptability to Change
OC4: Oral Communication
OC5: Written Communication
Technical Competencies: (Apply Level)
TC1: Data Analysis
TC2: Business & Process Requirements Analysis and Change Management
Competency Level Definitions:
Apply is defined as demonstrating sound understanding of the competency and ability to apply and contribute.
The following may be applied / assessed at a later date (may be needed for the job)
The CER is committed to building a diverse workforce reflective of Canadian society. Preference may be given to qualified candidates who self-identify from the following Employment Equity Groups: Indigenous Peoples, Visible Minorities, Persons with Disabilities and/or Women. We encourage you to indicate if you belong to one or more of the designated groups by completing the EE section in your application.
Conditions of employment
1) Willingness to undergo, successfully pass and maintain a reliability status security clearance. (Some positions may require a secret security clearance, which future incumbents will be required to undergo, successfully pass, and maintain).
2) Compliance with the CER’s Code of Conduct is required.
Note: It is strongly recommended that potential applicants read and consider the CER’s Code of Conduct prior to applying. This document is available on the CER Website http://www.cer-rec.gc.ca/code-of-conduct.
3) Must be willing and able to travel and to work overtime when required.
4) Must be willing to move within and between business units and teams, based on operational requirements and/or as individual development needs are identified.
Other information
The Public Service of Canada is committed to building a skilled and diverse workforce that reflects the Canadians we serve. We promote employment equity and encourage you to indicate if you belong to one of the designated groups when you apply.
Information on employment equity
2. Salary: Effective 1 November 2021 NEB08, $75,770 to $92,185 (subject to revision)
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:
- a Calgary Allowance in the amount of 4.95% of base salary may be paid on a bi-weekly payroll basis for employees who reside within the daily commuting distance of Calgary (150 km)
- annual performance pay which includes elements of individual performance (60% of payout) and corporate performance (40% of payout)
3. Application Requirements: Applicants must submit, by the closing date, a resume and cover letter clearly demonstrating how they meet the essential qualifications of education and experience. Applicants are strongly encouraged to demonstrate how they also meet the asset qualifications. Asset qualification(s) may be used at any point in the selection process (screening and/or assessment). Failure to provide sufficient information will result in applicants being screened out.
Applicants must provide a valid e-mail address which is functional at all times and accepts messages from unknown users. Our intention is to communicate with applicants by e mail for assessment purposes including sending invitations for written tests, interviews and issuing selection process results.
Candidates will need to provide proof of their education prior to appointment. Candidates with foreign credentials must provide proof of Canadian equivalency. Consult the Canadian Information Centre for International Credentials for further information at https://www.cicic.ca.
NOTE: Equivalencies granted by the Canadian provincial authorities with respect to Applied (Bachelor's) Degrees by colleges and technical institutes (i.e. in Ontario, British-Columbia, Alberta & Manitoba) must always be accepted as equivalent to Bachelor Degrees granted by universities in the provinces concerned.
4. Head Office Location – Calgary, AB: 210, 517 10th Avenue SW
Preference
Preference will be given to veterans first and then to Canadian citizens and permanent residents, with the exception of a job located in Nunavut, where Nunavut Inuit will be appointed first.
Information on the preference to veterans
We thank all those who apply. Only those selected for further consideration will be contacted.
About Canada Energy Regulator
Revenue: Unknown / Non-Applicable
Size: Unknown
Type: Company - Private
Website: www.cer-rec.gc.ca
