Data Analyst
Company: Gold Star Foods
Location: Ontario, California, United States
Salary: $100K – $115K a year
Work arrangement: Hybrid
Employment type: Full-time
Experience: 2-5 years
Education: bachelor degree
Posted: 2026-11-20
Responsibilities
The Data Analyst will integrate data from multiple ERP and operational systems into a centralized repository to improve accuracy and automate workflows. They will also partner with finance and operational teams to standardize master data and support financial reporting and business intelligence initiatives.
Requirements
Candidates must have a bachelor's degree in a relevant field and three to five years of experience in data analysis or business intelligence. Proficiency in SQL, Microsoft Excel, and Power Query is required, along with strong analytical and problem-solving skills.
Skills
- Data Analysis
- SQL
- Microsoft Excel
- Power Query
- ETL Processes
- Data Integration
- Process Automation
- Master Data Management
- Financial Reporting
- Business Intelligence
- Python
- Power Automate
- ERP Systems
- Data Validation
- Analytical Thinking
- Problem Solving
About this role
TITLE: Data Analyst
DIVISION/DEPARTMENT: Finance – Financial Planning & Analysis (FP&A)
REPORTS TO: FP&A Manager
FLSA CLASSIFICATION: Full-Time, Exempt
LOCATION: Ontario, CA
COMPANY OVERVIEW
GS Foods Group is a leading specialty food distributor serving K-12 schools and customers across foodservice, institutional, correctional, senior living, and other specialized markets. Our family of companies is committed to delivering exceptional service, operational excellence, and innovative solutions to the communities we serve.
At GS Foods, we recognize that our teammates are the foundation of our success. We foster a collaborative environment that values integrity, accountability, continuous improvement, and professional growth.
POSITION OVERVIEW
GS Foods Group is seeking a detail-oriented and analytical Data Analyst to join our Financial Planning & Analysis (FP&A) team. This position plays a critical role in supporting financial reporting, data integration, and operational decision-making across a portfolio of five regional food distribution businesses.
These businesses operate across Missouri, Louisiana, Connecticut, and California, supporting broadline food distribution, fresh produce distribution and processing, and food brokerage operations.
Reporting to the FP&A Manager, the Data Analyst will be responsible for integrating data from multiple ERP and operational systems into a centralized data repository, improving data accuracy, automating workflows, and supporting consistent reporting across the organization.
With multiple businesses operating on different ERP platforms and several undergoing system migrations, this position will partner closely with finance and operational teams to standardize data, resolve master data discrepancies, and maintain reporting continuity.
The ideal candidate demonstrates strong technical and analytical capabilities, attention to detail, a collaborative mindset, and a willingness to learn the financial and operational aspects of the business. A background in finance or accounting is beneficial but not required.
PRINCIPAL RESPONSIBILITIES
Data Integration & Process Automation
* Develop, maintain, and optimize data integration and ETL processes across multiple ERP and operational systems, including Microsoft Dynamics NAV, Business Central, NCR, and legacy platforms.
* Extract, clean, transform, and standardize data from databases, Excel files, flat files, and system-generated reports to ensure accuracy and consistency.
* Automate manual reporting and data preparation processes utilizing SQL, Power Query, Python, and Power Automate.
* Establish and maintain data validation and reconciliation controls to ensure consistency between source systems, centralized datasets, and the general ledger.
* Identify opportunities to improve data workflows, reporting efficiency, and overall data reliability.
Master Data Management & ERP Support
* Partner with business units to identify, investigate, and resolve master data discrepancies involving customers, products, vendors, and pricing.
* Support ERP implementation and migration initiatives through data mapping, cleansing, validation, and reconciliation.
* Assist with maintaining historical data integrity and reporting continuity during system transitions.
* Collaborate with cross-functional teams to improve data governance, standardization, and accuracy across business units.
Financial Reporting & Business Intelligence
* Partner with the FP&A Manager to identify relevant data sources and develop reliable datasets supporting financial and operational key performance indicators (KPIs).
* Support the FP&A team, including the Senior Director of FP&A, FP&A Manager, and FP&A Analyst, with reporting and analytical requirements.
* Improve and streamline data processes supporting Weekly Sales Flash reports, Monthly Business Review (MBR) presentations, budgets, and financial forecasts.
* Maintain accurate documentation of data sources, reporting definitions, processes, and system workflows.
* Prepare ad hoc reports, data requests, and analytical support to assist business leaders in making informed decisions.
* Identify data inconsistencies, investigate root causes, and communicate findings and recommended solutions to appropriate stakeholders.
Collaboration & Continuous Improvement
* Build effective working relationships with finance, IT, operations, and business leadership.
* Communicate technical data issues and findings clearly to both technical and non-technical stakeholders.
* Proactively identify opportunities to enhance reporting processes, data accuracy, and operational efficiency.
* Demonstrate accountability, sound judgment, and a commitment to continuous learning and process improvement.
* Follow all company policies, procedures, and applicable standards.
QUALIFICATIONS & REQUIREMENTS
Required Qualifications
* Bachelor's degree in Information Systems, Data Analytics, Computer Science, Finance, Accounting, or a related field; equivalent professional experience may be considered.
* Three to five years of experience in data analysis, business intelligence, data engineering, or a related field.
* Advanced proficiency in Microsoft Excel and Power Query.
* Strong working knowledge of SQL, including SQL Server and SQL Server Management Studio (SSMS).
* Demonstrated experience extracting, cleaning, transforming, and consolidating data from multiple systems and file formats.
* Strong analytical, organizational, and problem-solving skills with exceptional attention to detail.
* Ability to communicate technical concepts and data-related issues effectively to non-technical business partners.
* Ability to manage multiple priorities, meet deadlines, and work independently in a fast-paced environment.
* Willingness to learn industry-specific pricing structures, cost concepts, and operational processes.
Preferred Qualifications
* Experience deve...
About Gold Star Foods
Food and Beverage Services · 201-500 employees