What are the responsibilities and job description for the Power BI Specialist position at Marcone Appliance Parts?
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.
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.