Retail Analytics Analyst - Ace Hardware Corporation

The Job

This Retail Analytics Analyst will be responsible for becoming an Ace data knowledge source and executing various store, category, and field-level analytics and projects. Role will develop efficiencies within reporting and analysis.  Analyze and report on new Ace initiatives.

What you’ll do:

• Learn/absorb the foundational store and retail data to support.
• Develop time saving reporting improvements leveraging Alteryx and Microsoft Power BI. 
• Build the reports, training and capabilities to enable all end users in the various functional corporate departments to produce accurate reporting. 
• Work with the business area and IT to elicit, define and interpret requirements for projects in a timely fashion.
• Work with IT to perform business process analysis to ensure data integrity.
• Work cross-functionally with Analytics teams in: Category Management, Marketing, Merchandising, and Acehardware.com
• Review reports produced by other groups to identify and address potential discrepancies.
• Contribute to the month end reporting including, executive KPI data gathering, assigning peer groups to stores, updating data for our Sales Forecast vendor and maintaining Higher Ground KPI counts.
• Analyze and report on new Ace initiatives. develop reporting to analyze individual store and chain level performance both in the short and long term by various store and chain level attributes and operational differences.
• Pilot reporting and analysis including pilot store identification and tracking during pilot.
• Research questions and concerns regarding number discrepancies between reports, dashboard data, strategic focus metrics.
• Handle all New Business analysis, including sensitive markets, change of ownership reporting, Proforma analysis. Master mapping software in Alteryx to provide ongoing near analyses, retail proximity and competitive landscape. Yearly overarching analysis to understand how the most recent maturing stores compare to goals, other stores, forecast and proforma. Compile presentation to Officers, New Business Leaders and New Business Team.
• Handle all Labor Force Optimization, retail inventory, and mobile app reporting, including building dashboards for self-service analytics and deep dive analysis when needed. Provide results to leadership, in performance and board reporting.
• Streamline Project tracking – develop and maintain reporting on stores doing retail projects. Look for other growth metrics improving as stores do projects. Provide monthly results to project team, leadership and in performance and board reporting.

What you will need:

Knowledge, Experience, and Competencies:

Experience and Technical Requirements:

• 3-5 years Business / Marketing Analytics Experience
• Bachelor’s Degree in Business, Marketing, or related field
• PC proficiency/Advanced in Microsoft Word and Excel
• Analytical, quantitative, and critical thinking
• Proficient with MS Excel; experience with data mining and query tools, BI reporting tools preferred
• Self-starter, strong drive, highly motivated to make change and bring about fact driven decisions.
• Excellent written / verbal communication skills
• Personal Accountability and Ownership
• Executive presentation experience / Executive presence

#LI-CS1

Compensation Details:

$ 64000- $79000 per year

Why 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.

In addition to providing our employees a great culture, Ace 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 5 years resulted in incentives being paid out at an average of 122% of your target opportunity!)
• Generous 401(k) retirement savings plan with a fully vested matching contribution the first year in addition to quarterly contributions and annual discretionary contribution (once eligibility requirements have been met).  Over the past 5 years, company contributions (matching, quarterly & discretionary) for fully eligible employees have averaged 9.6% of total eligible 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 holidaysdepending on the month of hire
• Company Car, phone and fuel card are provided for field-based positions
• 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.

Want to be notified when new jobs are posted? Follow the link below to create an account and set up custom job alerts:

Create Job Alert

We want to hear from you!
When most people think of career opportunities with Ace Hardware, they often think of the helpful cashiers and sales associates at their local store. However, have you also considered the people behind the scenes who select, promote, ship and process the invoices for more than 75,000 products? Maybe you haven't, but we'd like you to. Because together we help our customers take care of their homes. Come find out why a career with the Ace Hardware Corporation is one of America's best kept secrets.

Equal Opportunity Employer
Ace Hardware Corporation 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 Ace 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. Ace Hardware Corporation reserves the right to change job duties, including essential job functions, according to business necessity.