Fuel Operations Financial Analyst

Fuel Operations Financial Analyst – Lakes Gas Co Full Time | Remote | Immediate Start Description The Fuel Operations Financial Analyst supports daily supply operations through detailed Excel-based reporting, inventory tracking, and coordination across rail, pipeline, transportation, and wholesale activities. This role is designed for a highly analytical individual with strong spreadsheet and modeling skills who is eager to learn complex operational workflows. Prior experience in energy supply is not required; success in this role depends on curiosity, attention to detail, and the ability to translate data into operational insight. Key Responsibilities Data Analysis & Reporting: prepare and distribute daily rail volume and shipping reports to rail branches and management; maintain and enhance Excel-based models and tracking tools for rail movements, inventory balances, costs, and forecasting; prepare three-year needs models; maintain average cost of LP purchased and fixed/index gas cost tracking reports; automate processes and explore AI support. Rail Operations & Coordination: monitor railcar activity daily, update tracking sheets, resolve rail-related issues (delayed shipments, cars not moving, release timing), track and organize rail documentation (BOLs, tank car reports, empty waybills), create monthly rail shipping plans and orders, track railcar detention exposure and prepare monthly detention accruals. Inventory & Supply Support: monitor inventory levels and supply positions, track and support inventory requirements across multiple supply points, identify inventory shortages or imbalances, maintain daily MAPL pipeline inventory in Estream system, adjust nominations, coordinate approvals, balance pipeline and cavern inventories, prepare monthly pipeline nominations. Transportation & Wholesale Coordination: develop and distribute monthly transportation schedule, update plans, coordinate wholesale load requests (record activity, place hauling orders, follow up for BOL), communicate changes to transporters. Financial & Administrative Support: process rail invoices, record details in tracking systems, coordinate ACH payment requests with accounting, support audit, accrual, and reconciliation activities. Contracts, Compliance & Meetings: maintain Excel records of supply contracts and swap deals, track contract details, assist with Canadian fuel tax reports for rail shipments, participate in weekly Monday Supply Meeting. Skills Excel, Modeling, Data Analysis Reporting, Inventory Tracking, Forecasting Coordination, Attention To Detail, Communication Problem-Solving, Analytical Thinking, Automation Rail Operations, Pipeline Management, Transportation Scheduling Requirements Strong proficiency in Microsoft Excel (formulas, pivot tables, lookups, modeling aptitude) Analytical mindset with strong attention to detail Ability to manage multiple priorities and deadlines Strong written and verbal communication skills Willingness to learn new systems, terminology, and operational processes Preferred Qualifications Experience in data analysis, operations, supply chain, logistics, or finance Exposure to inventory tracking, forecasting, or transportation coordination Interest in commodities, logistics, or operational analytics Key Competencies Analytical thinking and structured problem-solving Learning agility and curiosity Operational discipline and follow-through Cross-functional collaboration Data accuracy and integrity J-18808-Ljbffr