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.
QualificationsQualification 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.
Skills Required
- Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or related field
- 2-5 years experience in financial analysis (distribution, logistics, energy preferred)
- 2+ years creating reports and dashboards using Power BI and SSRS
- Advanced proficiency in Power BI, including star-schema design and performance optimization
- Experience developing complex DAX measures and calculations
- Strong Excel skills (pivot tables, modeling, data analysis, Power Query)
- Ability to analyze large datasets, identify patterns/variances, and draw conclusions
- Ability to link financial outcomes to operational drivers across sales, operations, and supply chain
- Experience with ERP and BI systems; MS Dynamics GP (Great Plains) experience is a plus
- Ability to troubleshoot data issues in ERP systems and automated feeds between systems
- Strong communication and cross-functional collaboration skills; present technical data to non-technical audiences
What We Do
Crystal Flash™ is one of the largest independently owned energy suppliers in Michigan. We serve more than 33,000 commercial and residential customers. With more than 250 employees, a fleet of 120 trucks and 15 locations, we are still growing. We are a 100% employee-owned company. Because of our commitment to safety, our tradition of community involvement and our dedication to contributing to Michigan’s economic success, we have had the honor to work with generations of our customers’ families, as well. Crystal Flash works towards environmental sustainability by exploring ways to help customers reduce their carbon footprints, improve efficiency in their operations or homes and be better stewards of our natural resources. As co-owners of the Sustainable Research Group, we help our business partners find ways to make their operations more environmentally friendly. Our knowledge and experience allow us to providing reliability and peace of mind to our customers. We make service a priority – and demonstrate our commitment with 24-hour emergency response. In our programs, we focus on pricing stability with options including price protection, payment plans, fixed-cost pricing and published price break levels.
