Marcone Appliance Parts
Data Analyst
Marcone Appliance Parts, St Louis, Missouri, United States
Let's unpack this - Who are we?
Marcone
is the leading provider of premium solutions, parts and equipment for professionals serving customers on their appliance parts, HVAC, plumbing and commercial kitchen needs. Headquartered in St. Louis, Missouri,
Marcone
is a multi-billion-dollar enterprise operating out of more than 200 locations throughout North America. Offering unparalleled product breadth, know-how across our national footprint and ease of doing business via leading-edge technology, servicers prefer
Marcone
because we amplify what they do best: take great care of their clients with speed, reliability and accuracy. Learn more about
Marcone
at www.marcone.com.
Ever dream of doing work that makes a difference? Want to join a growing company? Here it is! We seek the talent of a dynamic
Data Analyst
who seeks to bring their A game to a collaborative team of talented professionals. You are not afraid to make impact where your opinion matters in a company that has a masterful, mature history that operates as best-in-class.
We are seeking a skilled
Data Analyst
to design and develop dynamic, actionable dashboards by integrating data from diverse ERP systems. The role involves extracting, transforming, and consolidating data from multiple sources, ensuring accuracy and consistency in reporting. The ideal candidate 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.
The
Data Analyst
will work to support our
St. Louis region.
As a Data Analyst, you will:
Extract, transform, and load (ETL) data from multiple SQL tables into Power BI. Design and build interactive dashboards and reports tailored to financial performance metrics and trends. Optimize SQL queries for performance in Power BI data models. Ensure data integrity and consistency during integration. Collaborate with stakeholders to understand reporting requirements including, but not limited to dynamic KPI dashboards and variance analysis reports. Connect Power BI to Epicor and Microsoft Dynamics 365 for seamless data extraction and visualization. Collaborate with IT to ensure proper data flows between systems and Power BI. Troubleshoot and optimize ERP data connections for efficiency and reliability. Build robust data models in Power BI to analyze financial datasets, including budgeting, forecasting, pricing and profitability analysis. Use advanced DAX formulas and Power Query to derive insights from complex ERP datasets. Ensure data integrity by reconciling Power BI outputs with Epicor and Microsoft Dynamics 365 records. Partner with finance teams to understand business requirements and deliver custom reporting solutions. Work with ERP administrators to enhance the usability and functionality of Epicor and Dynamics 365 data for reporting purposes. Automate routine financial reporting by leveraging Power BI and ERP integration capabilities. Identify and implement process improvements to streamline financial operations and reporting cycles. Train finance and operational teams on utilizing Power BI dashboards and ERP-integrated reports. Act as a subject matter expert for Power BI and ERP reporting capabilities within the organization. About You:
Bachelor's degree in Finance, Information Systems, Data Analytics, or a related field. 3-5 years of experience in financial analysis or business intelligence. Strong expertise in Power BI, including DAX, Power Query, SQL skills (query optimization, joins, stored procedures) and data modeling. Ability to translate business requirements into actionable dashboards. Advanced knowledge of SQL for data extraction and manipulation. Familiarity with financial processes, including P&L analysis, budgeting, and forecasting. Excellent communication skills to explain complex data insights to non-technical stakeholders. Strong problem-solving and critical-thinking abilities. Knowledge of Python/R for data manipulation (optional but beneficial). Experience with Power Query or other ETL tools. Familiarity with Azure or cloud-based data services (if applicable). Familiarity with Epicor and/or Dynamics 365. So, what do we offer you? A great life!
Health care (medical, dental, vision, prescription) available the first day of hire! 401k with company contribution Life insurance plus short-term and long-term disability HSA/FSA options Paid vacations, holidays, and personal time Employee Assistance Program Employee discounts And much more!
All candidates who have received a written offer of employment will be required to undergo background screening and testing for commonly abused controlled substances in accordance with our company's background check and drug testing policy. Motor Vehicle Record checks are also completed for all candidates who have received a written offer of employment to determine insurability for driving a company vehicle as it relates to the position.
We provide equal opportunities for all employees and applicants for employment without regard to sex, age, race, religion, national origin, citizenship status, sexual orientation, gender identification, physical or mental disability, or any service, past, present, or future, in the uniformed services of the United States.
This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.
#LI-KH1
Marcone
is the leading provider of premium solutions, parts and equipment for professionals serving customers on their appliance parts, HVAC, plumbing and commercial kitchen needs. Headquartered in St. Louis, Missouri,
Marcone
is a multi-billion-dollar enterprise operating out of more than 200 locations throughout North America. Offering unparalleled product breadth, know-how across our national footprint and ease of doing business via leading-edge technology, servicers prefer
Marcone
because we amplify what they do best: take great care of their clients with speed, reliability and accuracy. Learn more about
Marcone
at www.marcone.com.
Ever dream of doing work that makes a difference? Want to join a growing company? Here it is! We seek the talent of a dynamic
Data Analyst
who seeks to bring their A game to a collaborative team of talented professionals. You are not afraid to make impact where your opinion matters in a company that has a masterful, mature history that operates as best-in-class.
We are seeking a skilled
Data Analyst
to design and develop dynamic, actionable dashboards by integrating data from diverse ERP systems. The role involves extracting, transforming, and consolidating data from multiple sources, ensuring accuracy and consistency in reporting. The ideal candidate 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.
The
Data Analyst
will work to support our
St. Louis region.
As a Data Analyst, you will:
Extract, transform, and load (ETL) data from multiple SQL tables into Power BI. Design and build interactive dashboards and reports tailored to financial performance metrics and trends. Optimize SQL queries for performance in Power BI data models. Ensure data integrity and consistency during integration. Collaborate with stakeholders to understand reporting requirements including, but not limited to dynamic KPI dashboards and variance analysis reports. Connect Power BI to Epicor and Microsoft Dynamics 365 for seamless data extraction and visualization. Collaborate with IT to ensure proper data flows between systems and Power BI. Troubleshoot and optimize ERP data connections for efficiency and reliability. Build robust data models in Power BI to analyze financial datasets, including budgeting, forecasting, pricing and profitability analysis. Use advanced DAX formulas and Power Query to derive insights from complex ERP datasets. Ensure data integrity by reconciling Power BI outputs with Epicor and Microsoft Dynamics 365 records. Partner with finance teams to understand business requirements and deliver custom reporting solutions. Work with ERP administrators to enhance the usability and functionality of Epicor and Dynamics 365 data for reporting purposes. Automate routine financial reporting by leveraging Power BI and ERP integration capabilities. Identify and implement process improvements to streamline financial operations and reporting cycles. Train finance and operational teams on utilizing Power BI dashboards and ERP-integrated reports. Act as a subject matter expert for Power BI and ERP reporting capabilities within the organization. About You:
Bachelor's degree in Finance, Information Systems, Data Analytics, or a related field. 3-5 years of experience in financial analysis or business intelligence. Strong expertise in Power BI, including DAX, Power Query, SQL skills (query optimization, joins, stored procedures) and data modeling. Ability to translate business requirements into actionable dashboards. Advanced knowledge of SQL for data extraction and manipulation. Familiarity with financial processes, including P&L analysis, budgeting, and forecasting. Excellent communication skills to explain complex data insights to non-technical stakeholders. Strong problem-solving and critical-thinking abilities. Knowledge of Python/R for data manipulation (optional but beneficial). Experience with Power Query or other ETL tools. Familiarity with Azure or cloud-based data services (if applicable). Familiarity with Epicor and/or Dynamics 365. So, what do we offer you? A great life!
Health care (medical, dental, vision, prescription) available the first day of hire! 401k with company contribution Life insurance plus short-term and long-term disability HSA/FSA options Paid vacations, holidays, and personal time Employee Assistance Program Employee discounts And much more!
All candidates who have received a written offer of employment will be required to undergo background screening and testing for commonly abused controlled substances in accordance with our company's background check and drug testing policy. Motor Vehicle Record checks are also completed for all candidates who have received a written offer of employment to determine insurability for driving a company vehicle as it relates to the position.
We provide equal opportunities for all employees and applicants for employment without regard to sex, age, race, religion, national origin, citizenship status, sexual orientation, gender identification, physical or mental disability, or any service, past, present, or future, in the uniformed services of the United States.
This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.
#LI-KH1