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
Scope: Multiple Systems/Multiple business units/multiple producing assets and large supply network/Canada
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
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.