Senior Marketing Analyst (On-Site)

Ace Hardware•Oak Brook, IL

4d•Onsite

About The Position

The Senior Marketing Analyst provides analytical support and strategic insights to Consumer Marketing and Ace Rewards teams. Working cross-functionally with internal business partners, the analyst uses data and insights to help develop marketing initiatives that drive retailer traffic and profitable sales. The role involves conducting in-depth analyses, interpreting results, applying industry knowledge and historical data, and turning findings into action. The analyst synthesizes data into clear, concise insights and recommendations. The position supports marketing campaigns, brand initiatives, focus categories and promotional efforts; assesses category and brand performance and market-share growth; and uses Ace Rewards member data to understand transactional and customer purchase behavior. It also develops test designs and measurement plans for strategic growth initiatives across channels and verticals, forecasts expected impacts, defines metrics, reports results, and recommends future actions. The analyst identifies automation opportunities, supports retailer education using Ace Rewards scorecards and reporting metrics, and raises reporting needs with upper management. The role also requires understanding data structures and querying tools, improving reporting through tools such as Alteryx, Microsoft Power BI and Databricks, identifying process efficiencies, and ensuring data and reported results are accurate.

Requirements

5–7 years of marketing or business analytics experience.
Bachelor’s degree in marketing analytics, data science, mathematics or statistics.
Analytical, quantitative and critical-thinking expertise.
Fundamental understanding of key financial and retail metrics.
Familiarity with transactional detail-level data, CRM technologies, consumer segmentation and targeting, insights and analytical tools and techniques, and various data sources.
Ability to collaborate and develop effective partner relationships.
Proficiency with Microsoft Excel and PowerPoint.
Experience with data-mining and query tools, BI reporting tools or CRM tools.
Self-starter with strong motivation to drive change and fact-based decisions.
Excellent written and verbal communication skills.
Must be authorized to work without employment visa sponsorship now or in the future.

Nice To Haves

MBA or master’s degree.
Experience with SQL, Alteryx and Databricks.

Responsibilities

Provide analytical support and strategic recommendations for marketing campaigns, brand initiatives, focus categories and promotional efforts.
Partner with Marketing to assess category and brand performance and the impact on market-share growth.
Use the Ace Rewards member database to analyze transactional and customer purchase behavior for marketing, merchandising and store operations.
Develop test designs and measurement plans for strategic growth initiatives across channels and verticals.
Forecast or estimate the impact of marketing efforts, define measurement metrics, report results promptly and recommend actions for future efforts.
Conduct ad hoc deep-dive analyses to identify trends, opportunities and concerns.
Identify repeated requests that can be automated.
Educate retailers on drivers of Ace Rewards success using scorecards, RAD and other ADW reporting metrics.
Bring new reporting needs to upper management to support retailer engagement and acceptance.
Identify ways to streamline data processes and improve efficiency with existing technology.
Develop time-saving report improvements using analytical tools such as Alteryx, Microsoft Power BI and Databricks.
Monitor data accuracy and ensure results are reported accurately.

Benefits

Incentive opportunities based on role and grade level.
401(k) plan with a fully vested matching contribution in the first year, subject to eligibility, as well as quarterly and annual discretionary contributions.
Medical, dental, vision, disability and life insurance coverage for employees and dependents.
21 days of vacation available immediately, prorated in the first year, and up to six paid holidays depending on the month of hire.
Annual Ace Cares Week and 20 hours of paid volunteer time per year.
Development and coaching, on-site classes, facilitator-led courses and tuition assistance.
Campus events and on-site services, including mobile spas, auto maintenance, car wash and detailing, dry cleaning, dentists, eye doctors and flu shots.
Employee discounts on Ace merchandise, travel, fitness, computers and other products and services.
Paid birth and adoption bonding time off.
Adoption cost reimbursement.
Employee Assistance Program, including access to therapists and lawyers and guidance on financial, elder-care and child-care matters.
Identity theft protection.