Senior Analytics Advisor

Ian Martin Group; Calgary; Hybrid; CAD 90,000 - 140,000; Full time

Benefits offered by this job

Health insurance

Hybrid work model

Job summary

The Ian Martin Group seeks a Senior Analytics Advisor to translate operational and financial data into actionable insights, influencing pipeline performance, safety, and regulatory compliance. You will bridge operations, analytics, and AI-enabled decision support to deliver timely intelligence for leadership.

You will lead advanced analytics using Databricks, Python, SQL, VBA, and Copilot agents, shaping scenario models and decision support across the organization while mentoring peers and

Qualifications

• Bachelor's degree in Engineering, Finance, Economics, Data Analytics, CS, or related.
• 7+ years in pipeline operations, midstream energy, or analytics.
• Experience analyzing data from AVEVA PI, SCADA or similar.
• Advanced SQL and Python; Databricks experience.
• Strong Excel with VBA.
• Experience dashboards using Power BI.
• Experience AI-enabled analytics and Copilot agents.
• What-if and sensitivity modeling.
• Excellent communication and executive presentation.
• Independent work with cross-functional teams.

Responsibilities

• Lead analytical problem-solving translating data into decision-ready insights.
• Design and interpret complex outputs including forecasts and scenarios.
• Build AI-enabled analytics solutions with Copilot agents.
• Perform financial and economic analyses to support planning and capital allocation.
• Partner with data engineers to define data requirements and improve dashboards.
• Collaborate with stakeholders across functions to align analytics initiatives.
• Monitor AI trends and regulatory developments.
• Mentor team and promote analytics best practices.
• Provide analytical leadership on complex challenges with financial/operational implications.
• Communicate findings clearly to technical and non-technical audiences.

Skills

Communication skills

Leadership

Independent work

Education

Bachelor's degree in Engineering, Finance, Economics, Data Analytics, Computer Science, or a related discipline

Tools

Databricks

SQL

Python

VBA

Power BI

Excel

Job description

Senior Analytics Advisor

• Contract Length : 6 Months
• Work Type : Hybrid
• Location : Calgary, AB

Job Overview:

• As a Senior Advisor, Analytics, you will translate operational and financial data into actionable insights that directly influence pipeline performance, safety, regulatory compliance, and business unit financial outcomes. This role serves as a bridge between pipeline operations, advanced analytics, and AI-enabled decision support, ensuring leaders have access to timely, accurate, and impactful intelligence to optimize system performance.
• You will act as a senior technical advisor, leveraging modern analytics platforms such as Databricks, advanced programming capabilities in Python, SQL, and VBA, and AI-powered tools including Copilot agents to scale insight generation, scenario modeling, and decision support across the organization.

Key Responsibilities

• Lead advanced analytical problem-solving by transforming operational, financial, and market data into decision-ready insights using Python, SQL, and Databricks.
• Design, develop, and interpret complex analytical outputs, including trends, anomalies, forecasts, and scenario analyses, to identify performance improvement opportunities, strengthen risk controls, and support strategic decision-making.
• Build and maintain AI-enabled analytics solutions, including Copilot agents, to automate recurring analyses, explain metrics, and accelerate insight delivery.
• Perform financial and economic analyses, including revenue impact assessments and marginal cost evaluations, to support strategic planning and capital allocation decisions.
• Partner with data engineers and analytics teams to define data requirements, enhance data quality, and improve dashboards, self-service analytics capabilities, and decision-support tools.
• Collaborate with cross-functional stakeholders across Customer Service & System Performance, Finance, Strategy, and Investor Relations to align analytics initiatives with business objectives.
• Monitor emerging technologies, industry trends, AI advancements, and regulatory developments to continuously evolve analytics practices and capabilities.
• Support team development through mentoring, knowledge sharing, documentation, training materials, and promotion of analytics and AI best practices.
• Provide analytical leadership and expert guidance on complex operational and business challenges with significant financial and operational implications.
• Communicate complex analytical findings and recommendations clearly to both technical and non-technical audiences, including senior leadership.

Scope and Impact

• Provides technical leadership, mentorship, and analytical guidance to junior and intermediate team members without direct supervisory responsibility.
• Serves as a key contributor within a collaborative analytics and operations environment supporting enterprise-wide optimization initiatives.
• Exercises independent judgment in evaluating and resolving complex analytical and operational issues.
• Maintains a broad understanding of business operations, technical systems, financial performance drivers, customer impacts, and regulatory requirements.
• Supports major pipeline systems across Canada and the United States, including liquids pipeline operations and related business entities.
• Influences senior stakeholders by translating complex metrics, operational trade-offs, and system behaviors into meaningful business insights and recommendations.

Qualifications

• Required
  • Bachelor's degree in Engineering, Finance, Economics, Data Analytics, Computer Science, or a related discipline.
  • Minimum of 7 years of experience in pipeline operations, midstream energy, operational analytics, or a related field with increasing levels of responsibility.
  • Experience analyzing operational and near real-time data from systems such as AVEVA PI System, SCADA platforms, or similar operational technologies.
  • Advanced proficiency in SQL and Python, with hands-on experience developing analytical workflows in cloud-based analytics environments, preferably Databricks.
  • Strong Excel expertise, including automation and analysis using VBA.
  • Demonstrated experience developing dashboards and analytics solutions using Power BI or similar business intelligence tools.
  • Practical experience utilizing AI-enabled analytics solutions and Copilot agents to automate analysis, explain metrics, and support scenario modeling.
  • Strong capability in developing what-if analyses and sensitivity models to assess operational, market, and regulatory impacts.
  • Excellent communication and presentation skills with the ability to translate complex analytics into executive-level insights and recommendations.
  • Proven ability to work independently on complex initiatives while collaborating effectively across cross-functional teams.
• Preferred
  • Industry-recognized certifications in cloud analytics, data engineering, or applied analytics, such as:
    • Databricks Data Engineer
    • Microsoft Azure Data Engineer
    • Certified Analytics Professional (CAP)
  • Knowledge of pipeline operational performance drivers, including throughput, capacity utilization, system reliability, maintenance effectiveness, and operational performance metrics.