Demo

Power BI Specialist

Marcone Appliance Parts
St. Louis, MO Full Time
POSTED ON 3/8/2025
AVAILABLE BEFORE 5/8/2025
About mSupply TM
mSupply is North America’s leading distributor of OEM repair parts and equipment, serving professionals in the appliance, HVAC, plumbing, commercial kitchen and pool/spa industries. Headquartered in St. Louis, MO, mSupply is a multi-billion-dollar enterprise offering an extensive product range, industry expertise and seamless service. With more than 2,000 associates across the U.S. and Canada, mSupply’s family of brands delivers with speed, reliability and precision through its branches, distribution centers and extensive fleet of delivery vehicles. Shipped orders reach 93% of U.S. customers via next-day ground delivery and 100% within two days. For more information, visit mSupply.com.
 
The Business Intelligence Manager will design and develop dynamic, actionable dashboards by integrating data from diverse ERP systems. This role involves extracting, transforming, and consolidating data from multiple sources, ensuring accuracy and consistency in reporting. The ideal individual will excel in creating insightful visualizations that drive business decisions while maintaining a strong focus on data integrity and performance optimization. Collaboration with cross-functional teams to understand and translate business requirements into impactful dashboards is essential. 
 
Essential Job Duties 

 

Data Architecture, Visualization and Reporting 

  • Extracts, transforms, and loads (ETL) data from multiple SQL tables into Power BI. 

  • Designs and builds interactive dashboards and reports tailored to financial performance metrics and trends. 

  • Optimizes SQL queries for performance in Power BI data models. 

  • Ensures data integrity and consistency during integration. 

  • Collaborates with stakeholders to understand reporting requirements including but not limited to dynamic KPI dashboards and variance analysis reports.  

 

ERP Data Integration 

  • Connects Power BI to Epicor and Microsoft Dynamics 365 for seamless data extraction and visualization. 

  • Collaborates with IT to ensure proper data flows between systems and Power BI. 

  • Troubleshoots and optimize ERP data connections for efficiency and reliability. 

 

Financial Data Modeling and Analysis 

  • Builds robust data models in Power BI to analyze financial datasets, including budgeting, forecasting, pricing and profitability analysis. 

  • Uses advanced DAX formulas and Power Query to derive insights from complex ERP datasets. 

  • Ensures data integrity by reconciling Power BI outputs with Epicor and Microsoft Dynamics 365 records. 

 

Collaboration and Business Partnership 

  • Partners with finance teams understand business requirements and deliver custom reporting solutions. 

  • Works with ERP administrators to enhance the usability and functionality of Epicor and Dynamics 365 data for reporting purposes. 

 

 

Apply for this Position

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Power BI Specialist?

Sign up to receive alerts about other jobs on the Power BI Specialist career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$81,298 - $105,685
Income Estimation: 
$101,449 - $132,468
Income Estimation: 
$141,014 - $186,880
Income Estimation: 
$180,084 - $244,913
Income Estimation: 
$81,298 - $105,685
Income Estimation: 
$101,449 - $132,468
Income Estimation: 
$64,949 - $84,690
Income Estimation: 
$81,298 - $105,685
Income Estimation: 
$101,449 - $132,468
Income Estimation: 
$124,087 - $161,899
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Marcone Appliance Parts

Marcone Appliance Parts
Hired Organization Address St. Louis, MO Full Time
At Marcone, we believe Great People are the Key to Our Success. Marcone offers a fast-paced, fun environment providing t...
Marcone Appliance Parts
Hired Organization Address St. Louis, MO Full Time
Let’s unpack this – Who are we? Marcone is the leading provider of premium solutions, parts and equipment for profession...
Marcone Appliance Parts
Hired Organization Address St. Louis, MO Full Time
Marcone is the leading provider of premium solutions, parts and equipment for professionals serving customers on their a...
Marcone Appliance Parts
Hired Organization Address Boston, MA Full Time
Marcone is the leading provider of premium solutions, parts and equipment for professionals serving customers on their a...

Not the job you're looking for? Here are some other Power BI Specialist jobs in the St. Louis, MO area that may be a better fit.

Power BI Developer Power ON Specialist

Artmac Soft LLC, Houston, TX

Power BI Specialist

Marcone Supply, St Louis, MO

AI Assistant is available now!

Feel free to start your new journey!