Log In
Sign Up
On behalf of our client, Procom is seeking a
Commercial Finance Analyst for a 12-month position working in onsite in Calgary- Alberta. Typically, 4 days a week in the office.
Commercial Finance Analyst Job Responsibilities
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 the 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/SAP
- Business: Retail
- Assets: Retail Network, HLU Refinery, LEP/MEP, Third Party Terminals
- Geographic: Canadian
- Function: Accounting/Transaction Management/System Day Close
- Team: Retail Commercial Backoffice
- Department: Retail Front-Office & Mid-Office, Supply & Logistics; Commercial Finance, Corporate Reporting
- Influence/direct stakeholders on resolving issues quickly and efficiently
- Confirm accuracy of Commercial transactions as it relates to product movement
- Process efficiency
- Enhanced data transparency/availability and analysis
- Focused and effective control framework
Deliverables
- Monitor and process daily EDI files from the 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
- Process daily, weekly and monthly invoicing to customers
- Run daily Gateway invoicing
- Consolidate weekly and monthly invoices
- Invoices SMS input and customer follow up
- 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
- 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
- Prepare monthly Light Oil Revision report, Freight Payment, and Supply Payment report
- Prepare monthly SOX documentation in relation to the refined products processes
- 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
Commercial Finance Analyst Mandatory Skills
- Minimum of 3-5 years of progressive experience in accounting inventory management
- Experience in trading or marketing accounting
- Advanced Excel and other computer skills with the ability to work within
- Experience with ERP and ETRM systems
- Experience with inventory management
- Attention to detail and accuracy, with a demonstrated ability to work independently,
- Excellent analytical and problem-solving skills
- Advanced understanding of computer file movement between systems
- Proficient use of Microsoft Office applications
- Strong financial accounting & reporting
- Strong financial acumen
- Strong knowledge of SAP and/or other reporting systems
- Strong oral and written communication; ability to interpret and communicate financial info
- Strong organizational, interpersonal and team skills with ability to interact with all disciplines
Commercial Finance Analyst Location
Calgary – Alberta
Commercial Finance Analyst Start Date
October 2023
