Settlement Analyst

I-T-M; Calgary; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company in IT Services and IT Consulting is seeking a Settlement Analyst to join its Crude Trading Operations Support Team. This role involves managing the settlement of crude product transactions and interfacing with traders and external counterparties. Candidates should have experience in data analytics and strong skills in Excel, Python, or SQL. The position requires availability during weekends and evenings, with a hybrid work schedule.

Qualifications

• At least 3 years of experience in data analytics.
• Knowledge of Python or SQL is advantageous.
• Advanced Excel skills, including macro management.

Responsibilities

• Interface with Traders and Accounting to resolve issues promptly.
• Support month-end reporting for production volumes and inventories.
• Manage entry of large volumes such as working interest splits.

Skills

Data Analytics

Communication

Problem Solving

Education

Bachelor’s Degree

Tools

Python

SQL

Excel

Job description

Join to apply for the Settlement Analyst role at Information & Technology Management

Get AI-powered advice on this job and more exclusive features.

What’s The Role

Shell Trading Canada (STC) offers a unique opportunity to join its crude operations team within its global trading network. We are seeking a Settlement Analyst (also known as Operations Support Analyst) to support traders by analyzing various information sources to maximize efficiencies.

This position is one of 6 within the Crude Trading Operations Support Team, responsible for managing the settlement of all crude product transactions. It acts as a primary link between the Calgary team and Chennai, India-based financial groups, overseeing the settlement process and interfacing with external trade counterparties regarding pricing, volume, and invoicing. The role also supports STC's growing lease business.

You will work closely with top traders and operators, gaining industry insights and practical experience with systems involved in the deal lifecycle, including Operations, Demurrage/Claims, Contracts, Credit, Risk Control, Scheduling, Analysis, and Trading strategies.

Accountabilities

1. Interface with Traders, Commercial Operators, Contract Management, Support Analysts, and Accounting to resolve customer/vendor issues promptly.
2. Propose solutions to maximize profit on existing deals and explore new value opportunities.
3. Communicate effectively with traders, schedulers, and team members regarding trading needs.
4. Support month-end reporting for production volumes and inventories, and reconcile data gaps.
5. Interpret lease agreements, pipeline statements, tariffs, and related documents to analyze and reconcile data variances.
6. Execute monthly lease and stream settlement plans, maintaining pricing components and customer data.
7. Manage entry of large volumes such as working interest splits, shipper balances, and tariffs.
8. Support process improvements through reviews and ad hoc projects.
9. Contribute to maximizing commercial added value.

What You Bring

1. Legal authorization to work in Canada full-time, excluding current employer.
2. Bachelor’s Degree preferred.
3. At least 3 years of experience in data analytics.
4. Knowledge of Python or SQL is advantageous.
5. Understanding of settlements and/or crude scheduling is desirable.
6. Advanced Excel skills, including macro management.
7. Ability to handle multiple issues with high energy.
8. Willingness to work outside regular hours during peak times.
9. Experience in a fast-paced trading environment is a plus.

Note: The role requires availability during weekends, evenings, and holidays, with in-office presence 3 days a week (Tues-Thurs) and optional Monday and Friday during settlement periods.

Additional Details

• Seniority Level: Mid-Senior level
• Employment Type: Contract
• Job Function: Finance and Sales
• Industries: IT Services and IT Consulting