Data Analyst
Role details
Job location
Tech stack
Job description
We are looking for a Data Analyst to join an organization in Pasadena, California on a contract basis with the potential for a permanent role. This role will focus on turning sales, operational, labor efficiency, and scan data into clear reporting tools that support business decisions. The ideal candidate brings strong analytical judgment, enjoys working with complex datasets, and can translate manual reporting into scalable dashboard solutions.
Responsibilities:
-
Build and maintain dashboards and reporting solutions that present sales, operational, labor efficiency, and scan data in a clear and actionable format.
-
Convert spreadsheet-based reporting into automated Power BI deliverables that reduce manual effort and improve reporting consistency.
-
Analyze large datasets to identify patterns, performance trends, and opportunities that support business and operational planning.
-
Partner with stakeholders across the organization to understand reporting needs and deliver insights that align with day-to-day operations.
-
Use advanced Excel techniques, including Power Query, pivot tables, and macros, to organize, validate, and interpret data.
-
Provide ongoing reporting support while balancing longer-term analytical projects and process improvements.
-
Create refreshable reporting workflows that improve visibility into key metrics and streamline recurring analysis.
-
Support data mapping and location-based analysis when needed, including the use of geographic or field-level tools.
-
Work independently to troubleshoot data issues, validate outputs, and ensure the reliability of reports and dashboards.
Requirements
Requirements * 5+ years of experience in data analysis or a related analytical role within a data-intensive environment.
-
Strong hands-on experience with Power BI and the ability to design effective dashboard and reporting solutions.
-
Advanced Excel skills, including macros, Power Query, and pivot tables.
-
Demonstrated critical thinking and problem-solving skills with the ability to work through complex business questions.
-
Experience handling large, detailed datasets with a high level of accuracy and organization.
-
Ability to manage both recurring operational requests and longer-range analytical assignments.
-
Bachelor's degree in Finance, Accounting, Economics, Mathematics, Statistics, or a related field is preferred.
-
Familiarity with business systems and exposure to mapping tools such as ArcGIS is a plus.