Business Intelligence Analyst

Summary:

As a Business Intelligence Analyst, you’ll dive deep into our fuels distribution business—covering propane, diesel, lubricants, and transport—mastering our systems and transforming data into strategic and financial insights. You will collaborate with operations, sales, supply chain, and leadership to analyze performance, guide pricing, optimize logistics, and support business decisions. This role is ideal for a results‑driven analyst eager to learn the fuels industry and help shape a 100‑year‑old success story.

Essential Duties and Responsibilities:

• Design, develop, and maintain Power BI dashboards, reports, and visualizations
• Design and optimize efficient data models, following Power BI best practices/Document report logic, calculations, and data definitions
• Collaborate with business users to gather requirements, translate business needs into technical, sustainable solutions
• Develop complex DAX measures and calculations that align with business unit KPIs and business reporting requirements
• Create meaningful visualizations to clearly communicate trends, performance metrics, and actionable insights
• Identify opportunities to improve reporting and data accuracy, particularly in view of validation to financial results
• Assist in automation of reporting processes, using SSRS and Power Automate where necessary
• Analyze sales and margin performance by product, region, customer, and delivery type
• Improve data quality by collaborating with IT and business stakeholders on data integration and validation and ensuring that all reporting ties back to actual financial results whenever possible 
• Support pricing models, margin scenarios, and budgeting processes, highlighting trends and anomalies
• Provide ad-hoc financial analysis to support executive decision-making

Reports to:

This position reports to the Director of Financial Planning & Analysis.

Supervisory Requirements:

None

Travel/Relocation Requirements:

Occasional day trips to other CF facilities or educational opportunities as agreed upon.

Qualification Requirements:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.  The requirements listed below are representative of the knowledge, skill, and/or ability required.  Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

Education and/or experience:

• Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, or related field
• 2–5 years of experience in financial analysis, preferably in distribution, logistics, energy, or related industries
• 2 years of experience creating reports and dashboards utilizing Power BI and SQL Server Reporting Services (SSRS)

Technical Skills

• Advanced proficiency in Power BI principles, including Star-Schema design, relationships, and performance optimization
• Strong analytical and problem-solving skills
• Comfortable analyzing large datasets, identifying patterns and variances, and drawing meaningful conclusions
• Ability to link financial outcomes to underlying operational drivers and business processes across sales, operations, and supply chain functions
• Able to present financial and operational insights clearly and effectively to a variety of audiences.
• Strong Excel skills (pivot tables, modeling, data analysis, power query)
• Experience with ERP and BI systems; experience with MS Dynamics GP (Great Plains), or fuel or transportation industry tools is a plus
• Be able to troubleshoot data issues in ERP systems and with automated feeds between multiple systems

Soft Skills

• Analytical, detail-oriented, and proactive mindset
• Continuous learner who stays current with emerging technologies and Power BI tools
• Excellent communicator; able to present technical data to non-technical audiences
• Strong cross-functional collaboration and project management skills
• Ability to learn new systems and fuel distribution intricacies quickly

Certificates, Licenses, and Registrations:

None

Work Environment:

While performing the duties of this job, the employee is frequently required to sit, talk, and listen. The employee is occasionally required to reach with hands and arms, stand, and walk.  The employee is required to operate a keyboard, calculators, computer mouse and other office equipment requiring manual dexterity and hand-eye coordination. 

The employee must regularly lift and/or move up to 10 pounds and occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision.

This job is operated in a professional office environment with several other team members. The noise level in the work environment is usually quiet.