Business Intelligence Analyst

Crystal Flash, Inc.
Grand Rapids, United States of America
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Grand Rapids, United States of America

Tech stack

Microsoft Excel
Data analysis
Data Integration
Microsoft Dynamics CRM
Microsoft Dynamics GP
Pattern Recognition
Performance Tuning
Pivot Tables
Power BI
SQL Server Reporting Services
Technical Data Management Systems
Microsoft Power Automate
Powerquery

Job description

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., * 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.

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., * 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

Apply for this position