Description
Competitive Benefits. Meaningful Extras. Unmatched Value.
- A place where you can take your career in the direction you want to grow and go
- Flexible work options and summer hours for eligible employees
- Save on gas at stations across Canada, including Chevron, Fas Gas, Ultramar, and Pioneer
The Opportunity
The Data Analyst will be responsible for analyzing complex datasets and data flows, as well as designing and developing Power BI reports and dashboards to provide actionable insights and recommendations to our business partners.
The Data Analyst will collaborate with cross-functional teams to assist in data-driven projects and ensure the accuracy of reports. They will also be responsible for assisting the deal entry analyst in entering trades into Allegro, as well as the ongoing development and maintenance of business intelligence (BI) reporting and analytical solutions.
Responsibilities
Reporting
- Design, develop and maintenance of interactive dashboards and reports using Power BI that effectively communicate data insights to stakeholders.
- Write complex SQL queries to extract, manipulate and analyze the data from various databases or sources.
- Implement Power Automate workflows to streamline processes and improve efficiency. Utilize Power Apps to create user friendly apps for data entry and management.
Analysis
- Evaluate business processes, anticipate, and uncover requirements, determine areas of improvement for existing solutions and processes.
- Gather information from meetings with various stakeholders and produce useful reports that generate meaningful insights.
Trade Deal Entry & Allegro
- Support the deal entry analyst in entering trades to Allegro.
- Support and fulfill ad-hoc report building and analysis as required.
Education
- Post-secondary degree in Computer Science, Data Science, Data Analytics would be an asset, however relevant experience or education would also be considered.
Requirements
- Minimum 3 years of experience as a Data Analyst or in a similar analytical role.
- Experience in creating dashboards and reports using Power BI and validating results with business stakeholders.
- Ability to query data and draft reports using Power Query (M), DAX, and SQL are mandatory.
- Proficiency in developing solutions using Power Platform (Power Automate & Power Apps) for process improvement and efficiency.
- Experience in working with JIRA or similar project management tools.
- The ideal candidate will possess strong business, analytical and critical thinking skills. They will have the ability to work with a collaborative team in a fast-paced, multi-faceted environment, while maintaining professional communication and accurate analysis of the business.
- Strong written and verbal communication skills along with the ability to work well in cross-functional teams.
- Ability to adjust to changing and conflicting demands, responsibilities, and issues.
- Understanding of Agile methodology, project management principles and emerging AI technologies.
Preferred Qualifications
- Experience with Python, R, and Databricks
- Experience in the oil and gas industry.
- Experience working with ETRM applications (Allegro)
Humble. Hungry. Smart. Does this sound like you?
Do others describe you as being a down-to-earth achiever? Someone who thinks outside the box and always strives to do more than what is required. Someone who sees the bigger picture? You sound brilliant to work with!
We Want You To Shine
We are committed to providing equal opportunities to all applicants. If you require accommodation due to a disability, you will have an opportunity to notify us when scheduling your interview.
Belonging Matters. Because You Do
We are an equal opportunity employer and encourage applications from all qualified individuals.
Our ability to work as one team across Canada, the United States and the Caribbean is foundational to our success. We show up as our authentic selves each day and create space for one another’s unique contributions.
Our Employee Resource Groups (ERGs) and Affinity Networks help us activate enterprise-wide strategies that power a proactive culture of diversity, equity, inclusions, and ultimately – belonging.
We respect the diverse cultures, traditions and perspectives of Indigenous Peoples and seek to achieve equitable partnerships and opportunities with Indigenous communities.
The Fine Print
Candidates must be legally eligible to work in the country in which they applied. Regrettably, we are unable to sponsor employment visas at this time.
Please note that final candidates for this position will be required to undergo a confidential pre-employment background check, including but not limited to educational, criminal, credit, drug and alcohol, and/or fitness for duty testing.