Commercial Analyst – Refined Products

Commercial Analyst, Canadian Refined Products Location: Calgary Contract: Initially 12 months with a view to extend Rate: $51 per hour T4 or $60 per hour IC Description: As a member of the Commercial Finance team this role will provide support to the CRP Commercial back-office. This role will be responsible for processing and revising of the Supply transactions, as it relates to product movement as well as the billing and error handling from source system. This position is also responsible for the SMS day-close processes and data transfer to SAP. This role will work closely with Retail Operations, Supply and Logistics and other internal and external stakeholders to investigate and resolve imbalances and other issues identified.

This role is expected to deliver accuracy and insight into the financial records through best practice process and efficiency; enhanced data transparency/availability and analysis; and focused and effective control framework. Responsibilities Role: Processing, revising, and analyzing product movement for the Downstream business units using SMS Monitor and process daily EDI files from client and third-party terminals Process daily, weekly, and monthly invoicing to customers Reconcile AP invoices at a transactional level and submit for payment Research and investigate issues, answer queries, and follow up on outstanding issues with various departments across Downstream Prepare monthly KPI reports, process documentation and evidence to support internal and external control requirements and audit reviews Assist and work on ad-hoc requests and projects to support the business Scope: Multiple Systems/Multiple business units/multiple producing assets and large supply network/Canada Systems: SMS/SAPBusiness: Retail Assets: Retail Network, HLU Refinery, LEP/MEP, Third Party Terminals Geographic: Canadian Function: Accounting/Transaction Management/System Day Close Impact: Ensuring transactions are loaded and processed accurately, billing and payments are reconciled and processed timely. Partners/Stakeholders: Multiple Functions Team: Retail Commercial Backoffice Department: Retail Front-Office & Mid-Office, Supply & Logistics; Commercial Finance, Corporate Reporting Spectrum Decision Making: Independent/Influence Influence/direct stakeholders on resolving issues quickly and efficiently Confirm accuracy of Commercial transactions as it relates to product movement Level of Problem Solving: Defined process/Complex analysis Key Metric: Delivering accuracy and insight into Retail inventory volumetric and financial records Process efficiency Enhanced data transparency/availability and analysis Focused and effective control framework Deliverables 1. Monitor and process daily EDI files from client and third-party terminals and run Gateway invoicing.

Upload EDI internal and external files and process manual BOL input, as required Process EDI Outbound files Perform EDI verify/match and BU volume confirmations Run Pendlist and investigate errors Investigate and collaborate with stakeholders on imbalance/issue resolution 2. Process daily, weekly and monthly invoicing to customers Run daily Gateway invoicing Consolidate weekly and monthly invoices Invoices SMS input and customer follow up 3. Reconcile invoices at transactional level and submit for payment Reconcile invoices for product purchases from supply partners for volumes and prices and process for payment Process auto freight and extra freight payments to carriers, and other third-party payments as required 4. Research and investigate issues, answer queries, and follow up on outstanding issues with various departments across Downstream 5.

Prepare monthly KPI reports, process documentation and evidence to support internal and external control requirements and audit reviews Prepare monthly Light Oil Revision report, Freight Payment, and Supply Payment report Prepare monthly SOX documentation in relation to the refined products processes 6. Assist and work on ad-hoc requests and projects to support the business New supply contract implementation/Ensure accounting and tax setup in both SMS/SAP Participate in project research and implementation, as required Competencies Technical ETRM (SMS) ERP (SAP) Accounting policy (IFRS): Revenue from Contracts with Customers/Inventories Retail Commercial Transactions, Supply & Logistics Behavioral Analytical & results driven Problem solver Motivate others toward a common goal Adapting and prioritizing competing demands Initiating and championing change initiatives Cross-functional relationship building and collaboration Professional skepticism Influential and persuasive Business writing & communication Team centric Qualification Must Have Minimum of 3-5 years of progressive experience in accounting inventory management Advanced Excel and other computer skills with the ability to work within Advanced understanding of computer file movement between systems Experience in trading or marketing accounting Experience with ERP and ETRM systems Experience with inventory management About Petroplan Petroplan is the trusted, specialist global Talent Solutions partner of choice for employers and professionals in the Energy sector. Since 1976, Petroplan has been here to help people like you make the most of the opportunities available and find the best fit for you as an individual. Over 10,000 placements in more than 55 countries for over 550 clients across 65 disciplines.

In an industry where skilled and experienced professionals are increasingly sought after resource, we appreciate the true value of what you have to offer. What’s more, we understand that different things are important to different people in today’s world of work – it’s about making exactly the right connections for you as an individual. Our reputation for contractor and candidate care, understanding what makes you tick, and finding you the best match is second-to-none. We understand the industry inside-out and seek to understand YOU and your motivations in the same way.

We take the time to evaluate your individual strengths, understand the most important things to you, and establish exactly what you’re looking for from your next role.

Source ⇲