Data Analyst

The Retail Data & BI Analyst supports the development, architecture, and delivery of data analytics and reporting tools that support operations across a national retail program operating in more than 1,300 locations.

This role will play a key part in the organization’s migration to Power BI, helping design scalable data models, build automated reporting pipelines, and develop dashboards that support leadership decision-making.

The position requires a strong analytical mindset, attention to detail, and the ability to transform complex operational data into clear and actionable insights for leadership teams.

This role sits at the intersection of data architecture, analytics, and business strategy, supporting initiatives related to compliance, performance analytics, fraud detection, and operational reporting., Data Architecture & Reporting Infrastructure

• Assist in the development and maintenance of the organization’s Power BI reporting environment
• Build and maintain Power BI datasets, semantic models, and dashboards
• Design scalable reporting structures that support leadership visibility across stores, territories, and regions
• Help migrate existing reporting from legacy systems into Power BI
• Ensure consistent data definitions and KPI calculations across dashboards

Data Integration & Data Quality

• Extract, clean, and transform data from multiple systems (POS systems, operational platforms, reporting feeds)
• Develop repeatable data validation and QA processes
• Assist in building structured datasets to support business reporting
• Identify and resolve inconsistencies across reporting sources

Analytics & Business Insights

• Analyze operational performance across retail locations, including sales performance, compliance metrics, staffing coverage, and execution metrics
• Identify trends, anomalies, and performance opportunities within large datasets
• Support leadership requests for both recurring and ad-hoc analysis
• Assist in the development of models used to estimate sales potential, operational opportunity, and program performance

Process Automation

• Automate recurring reporting processes using Power BI, Excel, and SQL
• Improve efficiency by reducing manual data manipulation and reporting
• Develop repeatable templates and analytical frameworks used by leadership

Cross-Functional Collaboration

• Work closely with leadership, operations teams, and analysts to understand reporting needs
• Translate business questions into structured data analysis
• Communicate findings clearly through dashboards, reports, and written summaries, Within the first 6-12 months this role will:
• Help complete the organization’s migration to Power BI
• Build standardized dashboards used by leadership across the program
• Improve data quality and reporting reliability
• Automate several recurring reporting processes currently performed manually
• Provide actionable insights that support operational performance and compliance initiatives

Education Bachelor’s degree in:

• Data Analytics
• Business Analytics
• Information Systems
• Statistics
• Or related analytical field

Equivalent experience may be considered.

Experience 1-3 years of experience in:

• Data analysis
• Business intelligence
• Reporting or analytics roles

-

Technical Skills

Required:

• Advanced Microsoft Excel
• Experience working with large datasets
• Data cleaning and transformation
• Strong analytical and problem-solving skills
• SQL

Strongly Preferred:

• Power BI (dashboard development, data modeling)
• Experience working with relational datasets
• Experience supporting operational or retail analytics

Nice to Have:

• Exposure to Power BI data modeling
• Understanding of data architecture concepts
• Experience with automation or reporting pipelines

-

Key Competencies

Analytical Thinking

Ability to analyze large datasets, identify trends, and translate findings into business insights.

Data Integrity

Strong attention to detail and commitment to maintaining accurate, reliable data.

Problem Solving

Ability to identify root causes of data discrepancies and develop scalable solutions.

Communication

Ability to clearly communicate complex data insights to non-technical stakeholders.

Ownership

Self-starter mindset capable of managing projects independently while collaborating with leadership.

Premium Retail Services is a part of Acosta Group - a collective of the industry’s most trusted retail, marketing and foodservice agencies reimagining the way people connect with brands at every point in their shopping journey. Since 1985, Premium has been a top provider of sales and merchandising services, reshaping retail through innovation and excellence for hundreds of renowned brands across retail categories. With 12,000+ employees across the U.S. and Canada, we are a people-first company, and we strive to ensure our team members enjoy their jobs, feel valued, and emulate our core beliefs - that’s why we frequently promote from within. We encourage our employees to innovate and expand new horizons, making internal development our cornerstone. Find your place at Premium - whether it’s merchandising, sales or brand advocacy, there’s a spot for you on our team. Acosta Group is an equal opportunity employer and will ensure that applicants with disabilities are provided with reasonable accommodations. If reasonable accommodation is needed, please contact AskHR@acosta.com. Be sure to include “Applicant Accommodation” in the subject of your email to expedite the request. Acosta Group believes in good faith that the minimum and maximum annual salary or hourly compensation range for this opportunity is accurate and reasonable at the time of posting.