What are the responsibilities and job description for the Power BI Specialist position at Marcone Supply?
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. Th is 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
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. Th is 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
- Extract s , transform s , and load s (ETL) data from multiple SQL tables into Power BI.
- Design s and build s interactive dashboards and reports tailored to financial performance metrics and trends.
- Optimize s SQL queries for performance in Power BI data models.
- Ensure s data integrity and consistency during integration.
- Collaborate s with stakeholders to understand reporting requirements including but not limited to dynamic KPI dashboards and variance analysis reports.
- Connect s Power BI to Epicor and Microsoft Dynamics 365 for seamless data extraction and visualization.
- Collaborate s with IT to ensure proper data flows between systems and Power BI.
- Troubleshoot s and optimize ERP data connections for efficiency and reliability.
- Build s robust data models in Power BI to analyze financial datasets, including budgeting, forecasting, pricing and profitability analysis.
- Use s advanced DAX formulas and Power Query to derive insights from complex ERP datasets.
- Ensure s data integrity by reconciling Power BI outputs with Epicor and Microsoft Dynamics 365 records.
- Partner s with finance teams understand business requirements and deliver custom reporting solutions.
- Work s with ERP administrators to enhance the usability and functionality of Epicor and Dynamics 365 data for reporting purposes.
