Contract Marketing Operations Data Analyst

Petroplan; Calgary; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading company in the oil and gas sector seeks a Financial Analyst to support Marketing Operations with reporting and analysis. The role involves creating dashboards, preparing forecasts, and working closely with the accounting team. Qualified candidates will have a bachelor's degree in Commerce or Economics and significant analytical experience. Strong MS Excel and Business Intelligence tool skills are essential for success.

Qualifications

• 3-5 years in an analytical role like Business or Financial analysis.
• Advanced skills in MS Excel - Pivot Tables and Dashboard creation.
• Proficient in analyzing financial statements and creating visualizations.

Responsibilities

• Prepare financial and operational reports and forecasts.
• Analyze the financial performance of business channels.
• Support financial analysis on major projects.

Skills

Financial analysis

Data analysis

Reporting

Change management

Organizational skills

Education

Bachelor’s Degree in Commerce

Diploma in Economics

Tools

MS Excel

Spotfire

SAP (BI Reporting Module)

PowerBI

Job description

Job Description:

This individual will be a key member of the Marketing Operations Support Team with the responsibility of analyzing & preparing financial reports, creating dashboards and forecasting on a weekly and monthly basis.

Responsibilities of the role include creating reports and dashboards, troubleshooting, and analyzing the financial performance of the business on a weekly, monthly, quarterly and annual basis. The Analyst will prepare documents, graphs and status reports as well as provide verbal presentations to leadership. In addition, the role requires competencies in change management and continuous improvement to always seek out new, and challenge existing ways, of discovering profit opportunities.

Core Responsibilities:

• Perform financial & operational reporting and analysis and forecasting/ budgeting of various Marketing business channels, including Asphalt & Industrial Products and Canadian Products Marketing.
• Identify key areas of concern, growth and emerging trends including process improvement enhancements.
• Work closely with the accounting team to ensure accurate financial reporting, accruals and other entries are identified and accounted for.
• Support the business through financial and operational analysis on major projects and other initiatives.
• Leverage, develop and coach junior personnel in preparing documents, analyzing the business channels, and better understanding the business to support decisions and strategies.
• Work with other departments and business units to help build out other analytical tools and understand their impacts.
• Ability to manage expectations and provide concise presentations to leadership.
• Other ad-hoc reporting.

Requirements:

• 3-5 years in an analytical role such as Business analysis or Financial analysis
• Bachelor’s Degree or Diploma in Commerce, Economics, or related field
• Familiarity with – and ability to analyze – financial statements
• Ability to analyze data and transform that data into summarized forecasts and intelligence for decision-making
• Advanced skills in MS Excel including Pivot Tables and Dashboard creation
• Experience using Spotfire or a similar Business Intelligence tool such as PowerBI to create data visualizations
• Proficient in SAP (BI Reporting Module)
• Self-starter with strong attention to detail, superior organizational skills and the ability to perform within tight deadlines
• Good business acumen
  

Assets:

• Previous experience in the Sales, Commercial or Retail sector
• Understanding of different streams of oil and gas and their interconnected roles
• Accounting designation