Data Analyst III

Job summary

Analyze pipeline operational, financial, and market data using Python, SQL, and Databricks to develop decision-ready insights, forecasts, KPIs, and recommendations. Build AI-enabled analytics and dashboards, support financial and operational planning, and advise stakeholders while collaborating with data and business teams.

Job details

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 Months 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. 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 This posting is for an active opening. Interested? Please apply directly online Agilus by Synergie would like to thank all candidates for their interest in this opportunity. Due to the volume of resumes we receive; we may only be able to respond directly to those candidates being selected for an interview. We encourage you to visit agilus.ca regularly or subscribe to our email alerts at agilus.ca/Account/Register as new exciting employment opportunities become available daily.

What you’ll do

Analyze pipeline operational, financial, and market data using Python, SQL, and Databricks to develop decision-ready insights, forecasts, KPIs, and recommendations. Build AI-enabled analytics and dashboards, support financial and operational planning, and advise stakeholders while collaborating with data and business teams.

Requirements

Requires a bachelor's degree in Engineering, Finance, Economics, Data Analytics, or Computer Science, plus 7 or more years of relevant pipeline, midstream energy, or operational analytics experience. Candidates should have advanced Python and SQL skills, experience with operational data platforms and cloud analytics, and the ability to deliver dashboards, financial analyses, scenario models, and clear executive communications.

Listed skills

• Data visualization · Preferred
• Power BI · Preferred
• SQL · Preferred
• Microsoft Excel · Preferred
• Financial analysis · Preferred
• Python · Preferred
• Forecasting · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Python
• SQL
• Databricks
• VBA
• Power BI
• Operational Analytics
• Pipeline Operations
• Financial Analysis
• Data Visualization
• AI-Assisted Analytics
• Scenario Modeling
• Forecasting
• Dashboard Development
• Stakeholder Communication
• Data Quality
• Microsoft Excel

Job areas

• Data & Analytics
• Energy
• Technology
• Finance & Accounting
• Engineering

More jobs from Agilus Work Solutions