Data Analyst III

Agilus Consulting Group; Calgary; On-site; CAD 83,000 - 96,000; Full time

Job summary

Agilus by Synergie is seeking a Data Analyst III in Calgary, Alberta to translate operational and financial data into insights that influence pipeline performance, safety, regulatory compliance, and financial outcomes. You will bridge pipeline operations, analytics, and AI-enabled decision support, using Databricks, Python, SQL, and VBA.

The role demands leadership in analytics, senior advisory capabilities, and collaboration across teams, with a 6-month contract and hourly pay of $60.00–$70.00

Qualifications

• Bachelor’s degree in Engineering, Finance, Economics, Data Analytics, or CS.
• 7+ years of experience in pipeline operations or analytics.
• Strong SQL and Python; cloud analytics on Databricks.

Responsibilities

• Lead advanced analytics to transform data into decision-ready insights.
• Design KPIs, scenarios, and forecasts to improve performance.
• Develop AI-enabled analytics solutions and Copilot agents.
• Collaborate with data engineers to evolve dashboards and tools.

Skills

Python

SQL

Databricks

VBA

Power BI

Excel

Education

Bachelor’s degree in Engineering, Finance, Economics, Data Analytics, or Computer Science

Tools

Databricks

Job description

Agilus by Synergie is recruiting for a Data Analyst III in the Oil and Gas Sector in Calgary, Alberta. As a Senior Advisor Analytics, you are a highly skilled professional responsible for translating operational and financial data into insights that directly influence pipeline performance, safety, regulatory compliance, and BU financial outcomes. This role exists to bridge pipeline operations, advanced analytics, and AI-enabled decision support, ensuring leaders have timely, trusted, and actionable intelligence to operate and optimize the system. technical advisor to management, leveraging modern analytics platforms (e.g., Databricks), advanced coding (Python, SQL, VBA). Total rewards:$60.00 - $70.00 hourly 6-month contract position 5 days on/2 days off

A typical day: Lead advanced analytical problem-solving, using Python, SQL, and Databricks to transform operational, financial, and market data into decision‑ready insights. Design and interpret complex analytical outputs (trends, anomalies, scenarios, and forecasts) to develop KPIs, recommend performance improvements, new strategies, and risk controls. Develop and maintain AI-enabled analytics solutions, including building and deploying Copilot agents to automate recurring analysis, explain metrics, and accelerate insight delivery for stakeholders. Conduct financial and economic analysis (revenue impacts and marginal cost analysis) to support strategic planning and capital allocation. Collaborate closely with data engineers and analytics teams across the organization to define data requirements, improve data quality, and evolve dashboards, self‑service analytics, and decision tools. Serve as a trusted liaison between Analytics and business teams including Customer Service & System Performance, Finance, Fundamentals & Strategy, and Investor Relations. Stay current on industry trends, emerging technologies, AI capabilities, and regulatory changes, ensuring analytics practices evolve with the business and external environment. Contribute to team capability development, including mentoring, documentation, training materials, and promotion of analytics and AI best practices.

This position has no direct reports, but provides technical guidance, mentorship, and analytical leadership to junior and intermediate team members. Acts as a key contributor within a multi‑departmental analytics and operations ecosystem, supporting enterprise‑wide optimization objectives. Exercises independent judgment on complex analytical and operational issues with financial and operational impact. Demonstrates broad business, technical, and system‑level understanding, including interdependencies between assets, customers, financial outcomes, and regulatory metrics. Scope covers major pipeline systems across Canada and the U.S., including liquids pipelines and related entities. Regularly influences senior internal stakeholders by explaining complex metrics, trade‑offs, and system behaviors that impact performance and financial results. Required to communicate and exercise influence on internal stakeholders regarding the system operation as well as the performance of the system including the complex relationship of the metrics.

Requirements

• Successful candidates will have: Bachelor’s degree in Engineering, Finance, Economics, Data Analytics, or Computer Science.
• 7+ years of experience in pipeline operations, midstream energy, or operational analytics roles with increasing responsibility.
• Proven experience analyzing operational and near‑real‑time data (e.g., AVEVA PI System, SCADA‑derived data, or similar operational platforms). Advanced proficiency in SQL and Python, with hands‑on experience building analytical workflows on cloud analytics platforms (preferably Databricks). Solid experience with Excel‑based analysis and automation, including VBA, for operational and financial use cases. Demonstrated ability to deliver decision‑ready dashboards and analytics using Power BI or equivalent tools.
• Practical experience using AI‑assisted analytics and Copilot agents to automate analysis, explain metrics, or support scenario modeling. Ability to develop what‑if scenarios and sensitivity analyses to evaluate operational, market, and regulatory changes.
• Strong communication skills with a proven ability to translate complex analytics into clear executive insights, including concise PowerPoint materials.
• Demonstrated success working independently on complex problems while collaborating effectively across other teams. Industry‑recognized certifications in cloud analytics or applied analytics are an asset (e.g., Databricks Data Engineer, Microsoft Azure Data Engineer, Certified Analytics Professional)
• Understanding of pipeline operational performance drivers, including throughput and capacity utilization, system reliability, maintenance effectiveness, and key performance indicators.

About the Role

This role exists to support enterprise‑wide optimization of pipeline systems and requires strong analytical acumen and leadership. It is a 6-month contract, 5 days on/2 days off schedule with hourly rate of $60.00 - $70.00 in Calgary, Alberta.