Ace Hardware Corporation
Sr. Business Analyst
Ace Hardware Corporation, Oak Brook, Illinois, United States, 60523
The
Senior Business Analyst
reports to the Pricing & Analytics Manager as part of the Pricing & Analytics team, and is tasked with report creation, development, and refinement (Power BI, Excel), data querying (SQL, SAP, ADW Tables), analytics and other ad hoc requests.These tasks relate to the reporting of all performance metrics with a specific focus on revenue and profitability for the wholesale subsidiary of Ace Hardware, Emery Jensen Distribution (EJD). The channels that comprise EJD are designated as Pro Lumber Yards, E-Commerce, Hardware, Paint, and Grocery. Each Channel will require separate analysis.Reporting and analysis responsibilities include, but are not limited to, top and bottom-line profitability on vendors and items; on customers, channels and retail markets; assortments, programs, and products; vendor programs, promotional offerings; and efficiency measurables.The Senior Business Analyst works hand in hand with the appropriate Pricing & Analytics, Sales, Merchandising, Operational, and Finance team members to ensure visibility to financial and performance metrics.What You’ll Do…
Create, develop and refine Power BI dashboards. These dashboards, which are used by the EJD Sales, Finance, Merchandising and Leadership teams are crucial for the tracking and monitoring of EJD revenue, sales, margin and customer profitability results and performance.Develop and publish timely routine reports (monthly, quarterly, annually) that provide visibility and insight into sales, profitability and financial performance by channel, category, vendor, and customer to enable achievement of short- and long-term sales and profitability goals. (e.g.: Merch Stats, Customer Profitability, Promotional Billbacks)Analyze reports and provide insights and recommendations to improve sales and profitability. In partnership with the Pricing & Analytics Manager, support with and lead ad hoc reporting development and analysis projects. Communicate findings to stakeholders and EJD leadership team.Support the Finance, Sales and Merchandising teams with developing budget targets and create templates and files to report and track progress.Train other EJD team members on the use and best practices of Power BI dashboards.Build and provide ad-hoc reports and analysis as needed: including the data gathering. Provide data from SAP and ADW via ad-hoc query pulls when requested.Work and communicate with EJD Department leads, Finance, Merchandising, Sales, Operations and ACE Analyst peers.Mentor, coach, and cross-train Pricing & Analytics team members (including Business Analyst, Sales Data Analyst, and Pricing Specialist) to help team members grow and develop and ensure there is strong coverage and capabilities across the team. Support with other Pricing & Analytics team responsibilities when team members are out of office.What You Need To Succeed..
Ability to write queries using SQL and Dax.Ability to develop data visualization tools (Power BI).Strong Excel skills.Duties require knowledge of commonly used concepts, practices & procedures for Financial Analysis and Reporting.4-year college degree and at least 5-7 years of related work experience.Proficient in Microsoft Outlook, Word, Access, Power Point.Knowledge of SAP and guided Ad-hoc reporting tools.Proven ability to multi-task projects and meet deadlines.Strong interpersonal and written/verbal communications skills.Proactive, detail oriented, well organized.Compensation Details
$80,000 - $103,000Why should you join our team?
We live our values - W.E.L.I.G.H.T (Winning, Excellence, Love, Integrity, Gratitude, Humility, and Teamwork). Gratitude. Humility. Love. You don’t often see values like these in most corporate statements, but Ace is different. These things are important to us. They represent our commitment to the company, our employees, to Ace retailers and to the Ace brand.Benefits
In addition to providing our employees a great culture, Ace / Emery Jensen Distribution also offers competitive benefits* that address life’s necessities and perks, many of which expand and improve year after year, including:Incentive opportunities, based on role/grade level (rapid company growth over the past 3 years resulted in incentives being paid out above 106.6% of your target opportunity!)Generous 401(k) retirement savings plan with a fully vested matching contribution the first year, in addition to an annual discretionary contribution (once eligibility requirements have been met). Over the past five years, company contributions (matching & discretionary) for fully eligible employees have averaged 7.5% of total compensation.Comprehensive health coverage (medical, dental, vision and disability – up to 26 weeks short-term disability and long-term disability) & life insurance benefits for you and your dependents.21 days of vacation immediately available (prorated in the first year) and up to 6 paid holidays depending on the month of hire.Company Car, phone and fuel card are provided for field-based positions.Flexible working arrangements (Non-Field positions can work from home up to 2 days per week).Your career at Ace is more than just a job. It’s a chance to be part of something meaningful. We help locally-owned businesses thrive and make an impact in their communities – and we support our employees in doing the same by offering an annual Ace Cares Week, 20 hours off work per year to volunteer at an organization of your choice, opportunities to help Children’s Miracle Network Hospitals and the Ace Helpful Fund through the Ace Foundation.Ace invests in every employee we hire, with a key focus on development and coaching. We offer on-site classes, facilitator-led courses, and a generous tuition assistance program, plus a performance management approach that goes beyond the typical annual review.We know the work environment matters. That’s why Ace holds frequent campus events like Employee Appreciation Week, vendor demos, cookouts, and merchandise sales.We bring them to you! Services such as mobile spas, auto maintenance, car wash and detailing, dry cleaning, dentists, eye doctors, flu shots, recycling and more!Employee discounts on Ace merchandise (including top brands like Weber, Traeger, Yeti, Craftsman, DeWalt and more), travel, fitness, computers and thousands more.Birth/Adoption bonding paid time off.Adoption cost reimbursement.Employee Assistance Program (EAP) – access to free visits to therapists and lawyers, guidance on financial matters, elder and childcare, and assistance with tickets to entertainment events.Identity theft protection.Benefits are provided in compliance with applicable policies.Equal Opportunity Employer
Emery Jensen Distribution is committed to a policy of promoting equal employment opportunities. The company recognizes the importance of diversity and leveraging the skills and talents of all people to the mutual advantage of each individual and the organization. The company is committed to the prevention of employment discrimination related to race, religion, color, sex (including sexual harassment), gender identity, national origin, age, marital status, disability and military or veteran status, sexual orientation or any other action covered by federal or applicable state/local laws.Disclaimer
The pay range for this position starts as listed in the job posting, but could be higher based on education and experience. Please note, compensation decisions are dependent on the facts and circumstances of each opening. We take into consideration the minimum requirements outlined in the job description, such as an individual’s education, training and experience, the position’s work location, required travel (if any), and external market conditions when determining the final salary for potential new hires.Be aware that salary estimates published via alternate online job boards may not be a true representation of the actual pay range offered for this position. Please refer to the Emery Jensen Distribution position description for the accurate starting pay range information and feel free to discuss this with a Talent Acquisition professional if you are chosen to move forward with an interview.This written “Position Description” is not intended to cover all aspects of the position listed. It is meant to cover the basic/general essential job functions of a particular position. Emery Jensen Distribution reserves the right to change job duties, including essential job functions, according to business necessity.
#J-18808-Ljbffr
Senior Business Analyst
reports to the Pricing & Analytics Manager as part of the Pricing & Analytics team, and is tasked with report creation, development, and refinement (Power BI, Excel), data querying (SQL, SAP, ADW Tables), analytics and other ad hoc requests.These tasks relate to the reporting of all performance metrics with a specific focus on revenue and profitability for the wholesale subsidiary of Ace Hardware, Emery Jensen Distribution (EJD). The channels that comprise EJD are designated as Pro Lumber Yards, E-Commerce, Hardware, Paint, and Grocery. Each Channel will require separate analysis.Reporting and analysis responsibilities include, but are not limited to, top and bottom-line profitability on vendors and items; on customers, channels and retail markets; assortments, programs, and products; vendor programs, promotional offerings; and efficiency measurables.The Senior Business Analyst works hand in hand with the appropriate Pricing & Analytics, Sales, Merchandising, Operational, and Finance team members to ensure visibility to financial and performance metrics.What You’ll Do…
Create, develop and refine Power BI dashboards. These dashboards, which are used by the EJD Sales, Finance, Merchandising and Leadership teams are crucial for the tracking and monitoring of EJD revenue, sales, margin and customer profitability results and performance.Develop and publish timely routine reports (monthly, quarterly, annually) that provide visibility and insight into sales, profitability and financial performance by channel, category, vendor, and customer to enable achievement of short- and long-term sales and profitability goals. (e.g.: Merch Stats, Customer Profitability, Promotional Billbacks)Analyze reports and provide insights and recommendations to improve sales and profitability. In partnership with the Pricing & Analytics Manager, support with and lead ad hoc reporting development and analysis projects. Communicate findings to stakeholders and EJD leadership team.Support the Finance, Sales and Merchandising teams with developing budget targets and create templates and files to report and track progress.Train other EJD team members on the use and best practices of Power BI dashboards.Build and provide ad-hoc reports and analysis as needed: including the data gathering. Provide data from SAP and ADW via ad-hoc query pulls when requested.Work and communicate with EJD Department leads, Finance, Merchandising, Sales, Operations and ACE Analyst peers.Mentor, coach, and cross-train Pricing & Analytics team members (including Business Analyst, Sales Data Analyst, and Pricing Specialist) to help team members grow and develop and ensure there is strong coverage and capabilities across the team. Support with other Pricing & Analytics team responsibilities when team members are out of office.What You Need To Succeed..
Ability to write queries using SQL and Dax.Ability to develop data visualization tools (Power BI).Strong Excel skills.Duties require knowledge of commonly used concepts, practices & procedures for Financial Analysis and Reporting.4-year college degree and at least 5-7 years of related work experience.Proficient in Microsoft Outlook, Word, Access, Power Point.Knowledge of SAP and guided Ad-hoc reporting tools.Proven ability to multi-task projects and meet deadlines.Strong interpersonal and written/verbal communications skills.Proactive, detail oriented, well organized.Compensation Details
$80,000 - $103,000Why should you join our team?
We live our values - W.E.L.I.G.H.T (Winning, Excellence, Love, Integrity, Gratitude, Humility, and Teamwork). Gratitude. Humility. Love. You don’t often see values like these in most corporate statements, but Ace is different. These things are important to us. They represent our commitment to the company, our employees, to Ace retailers and to the Ace brand.Benefits
In addition to providing our employees a great culture, Ace / Emery Jensen Distribution also offers competitive benefits* that address life’s necessities and perks, many of which expand and improve year after year, including:Incentive opportunities, based on role/grade level (rapid company growth over the past 3 years resulted in incentives being paid out above 106.6% of your target opportunity!)Generous 401(k) retirement savings plan with a fully vested matching contribution the first year, in addition to an annual discretionary contribution (once eligibility requirements have been met). Over the past five years, company contributions (matching & discretionary) for fully eligible employees have averaged 7.5% of total compensation.Comprehensive health coverage (medical, dental, vision and disability – up to 26 weeks short-term disability and long-term disability) & life insurance benefits for you and your dependents.21 days of vacation immediately available (prorated in the first year) and up to 6 paid holidays depending on the month of hire.Company Car, phone and fuel card are provided for field-based positions.Flexible working arrangements (Non-Field positions can work from home up to 2 days per week).Your career at Ace is more than just a job. It’s a chance to be part of something meaningful. We help locally-owned businesses thrive and make an impact in their communities – and we support our employees in doing the same by offering an annual Ace Cares Week, 20 hours off work per year to volunteer at an organization of your choice, opportunities to help Children’s Miracle Network Hospitals and the Ace Helpful Fund through the Ace Foundation.Ace invests in every employee we hire, with a key focus on development and coaching. We offer on-site classes, facilitator-led courses, and a generous tuition assistance program, plus a performance management approach that goes beyond the typical annual review.We know the work environment matters. That’s why Ace holds frequent campus events like Employee Appreciation Week, vendor demos, cookouts, and merchandise sales.We bring them to you! Services such as mobile spas, auto maintenance, car wash and detailing, dry cleaning, dentists, eye doctors, flu shots, recycling and more!Employee discounts on Ace merchandise (including top brands like Weber, Traeger, Yeti, Craftsman, DeWalt and more), travel, fitness, computers and thousands more.Birth/Adoption bonding paid time off.Adoption cost reimbursement.Employee Assistance Program (EAP) – access to free visits to therapists and lawyers, guidance on financial matters, elder and childcare, and assistance with tickets to entertainment events.Identity theft protection.Benefits are provided in compliance with applicable policies.Equal Opportunity Employer
Emery Jensen Distribution is committed to a policy of promoting equal employment opportunities. The company recognizes the importance of diversity and leveraging the skills and talents of all people to the mutual advantage of each individual and the organization. The company is committed to the prevention of employment discrimination related to race, religion, color, sex (including sexual harassment), gender identity, national origin, age, marital status, disability and military or veteran status, sexual orientation or any other action covered by federal or applicable state/local laws.Disclaimer
The pay range for this position starts as listed in the job posting, but could be higher based on education and experience. Please note, compensation decisions are dependent on the facts and circumstances of each opening. We take into consideration the minimum requirements outlined in the job description, such as an individual’s education, training and experience, the position’s work location, required travel (if any), and external market conditions when determining the final salary for potential new hires.Be aware that salary estimates published via alternate online job boards may not be a true representation of the actual pay range offered for this position. Please refer to the Emery Jensen Distribution position description for the accurate starting pay range information and feel free to discuss this with a Talent Acquisition professional if you are chosen to move forward with an interview.This written “Position Description” is not intended to cover all aspects of the position listed. It is meant to cover the basic/general essential job functions of a particular position. Emery Jensen Distribution reserves the right to change job duties, including essential job functions, according to business necessity.
#J-18808-Ljbffr