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 developing ETL workflows and working with centralized data repositories or data warehouses.
- Working knowledge of Python, Power Automate, SharePoint, and Workday Adaptive Planning.
- Familiarity with accounting principles, including double-entry bookkeeping, accrual accounting, inventory accounting, and cost accounting.
- Experience with Microsoft Dynamics NAV, Business Central, or comparable ERP systems.
- Previous involvement in ERP implementations, system migrations, or master data management initiatives.
- Experience within food distribution, K-12 foodservice, or related industries.
REQUIRED COMPETENCIES
- Analytical Thinking: Demonstrates the ability to interpret complex data, recognize patterns, and identify meaningful insights.
- Problem Solving: Effectively evaluates challenges, identifies root causes, and develops practical solutions.
- Attention to Detail: Maintains accuracy, consistency, and completeness in data analysis and reporting.
- Collaboration: Builds productive working relationships and works effectively across departments.
- Approachability: Maintains open communication and supports a collaborative team environment.
- Humility & Professionalism: Demonstrates respect, accepts feedback, and remains receptive to different perspectives.
- Integrity & Accountability: Maintains confidentiality, takes ownership of responsibilities, and demonstrates sound ethical judgment.
- Continuous Improvement: Proactively identifies opportunities to improve systems, processes, and efficiency.
- Growth Mindset: Demonstrates curiosity, adaptability, and a commitment to ongoing professional development.
Annual Salary: $100,000.00- $115,000.00
WORK SCHEDULE & TRAVEL
Location: Ontario, California Work Arrangement: Fully onsite initially, with the opportunity to transition to a hybrid schedule based on business needs and management approval. Travel Requirements: No regular travel is anticipated. Candidates working outside the Ontario, CA office may be required to travel to Ontario periodically for meetings, training, or business-related activities.
PHYSICAL DEMANDS
The physical demands described below are representative of those required to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential job functions. Ability to sit, stand, and walk throughout the workday as required. Frequent use of computers and standard office equipment. Occasional reaching, bending, and lifting associated with office-related activities. Ability to occasionally lift and move materials weighing up to 25 pounds.
WORK ENVIRONMENT
This position primarily operates in a professional office environment utilizing standard office equipment. Occasional visits to warehouse or distribution areas may be required. These environments may include refrigerated or frozen storage areas, wet or slippery surfaces, and operational equipment. Teammates must comply with all applicable workplace safety procedures and personal protective equipment (PPE) requirements when entering designated operational areas.
OTHER DUTIES & RESPONSIBILITIES
This job description is not intended to provide a comprehensive listing of all activities, duties, or responsibilities associated with this position. Duties and responsibilities may be modified, expanded, or reassigned at any time, with or without notice, based on business needs. All listed qualifications represent the minimum knowledge, skills, and abilities considered necessary to perform the position successfully. In the absence of the Data Analyst, the FP&A Manager will assume or appropriately delegate essential responsibilities to maintain business continuity. EOE M/W/Vet/Disabled
GS Foods Group is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other status protected by applicable federal, state, or local law.
#IND123