Data Jobs in Ontario, CA

1 job found

Include remote jobs

1mo ago

ERP Data Analyst

Canopy A&D Ontario, CA

Ontario, CA

1mo ago Closed

$150k - $175k/yr Full time Analyst Analytics Business Analytics

This position is no longer accepting applications (closed Aug 12, 2026).

Job Description

In Canopy A&D’s Ontario, California operation, the ERP Data Analyst will play a pivotal role as the company migrates from JobBOSS to Epicor ERP within an aerospace manufacturing setting. The position focuses on protecting data integrity, building robust reports and dashboards, and delivering actionable insights to operations. It requires close collaboration with IT, Finance, Supply Chain, Quality, and Manufacturing to maximize system utilization and maintain aerospace compliance.

Responsibilities

Serve as a subject matter expert for Epicor ERP data structures, system architecture, tables, and core business processes, ensuring alignment with operational workflows.
Maintain and proactively monitor data integrity across Manufacturing, Inventory, Supply Chain, Finance, Quality, and Engineering modules, ensuring accuracy, consistency, and traceability.
Support and troubleshoot ERP transactions related to work orders, routings, bills of materials (BOMs), labor reporting, inventory movements, purchasing activities, and product costing.
Identify, investigate, and resolve data discrepancies by performing root cause analysis and implementing corrective actions to prevent recurrence.
Develop, maintain, and automate Epicor BAQs, dashboards, reports, and KPIs to improve visibility into operational and financial performance.
Provide accurate and timely operational, financial, and executive-level reporting to support strategic decision-making.
Analyze production performance metrics including scrap, rework, labor efficiency, inventory accuracy, capacity utilization, and on-time delivery performance.
Fulfill ad hoc data requests and conduct detailed analytical reviews to support business initiatives, audits, and leadership inquiries.
Partner cross-functionally with Manufacturing, Supply Chain, Finance, Engineering, and Quality teams to understand reporting needs and translate business requirements into scalable ERP data solutions.
Support continuous improvement initiatives by leveraging trend analysis, performance metrics, and data-driven insights to enhance efficiency and reduce waste.
Assist with ERP upgrades, system enhancements, configuration changes, testing, and user acceptance activities to ensure seamless system performance and adoption.
Ensure ERP data structure and reporting practices support aerospace compliance requirements (AS9100, ITAR, DFARS, as applicable).
Develop and maintain clear documentation for data standards, reporting logic, ERP workflows, and system procedures to ensure consistency and knowledge transfer.
Support internal and external audits by providing accurate, complete, and traceable ERP data and documentation as required.

Requirements

Bachelor’s degree in Data Analytics, Information Systems, Business, Engineering, or related field (or equivalent experience).
Minimum 5 years of Epicor ERP (Kinetic preferred) data analysis experience in a manufacturing environment.
Strong understanding of manufacturing processes (work orders, BOMs, routings, inventory, labor tracking).
Advanced Excel skills (pivot tables, lookups, data modeling).
Experience developing BAQs, dashboards, and reports within Epicor.
Strong analytical, problem-solving, and attention-to-detail skills.
Must be a US person.

Technologies

Epicor ERP (Kinetic), BAQs (Epicor), Power BI, SSRS, SQL, Excel

Benefits

Company paid employee medical, dental and vision insurance
Retirement plan participation (eligibility required)
Paid sick leave
Paid vacation
Paid holidays
Discretionary bonuses

Physical Requirements

Ability to sit for extended periods while working at a computer workstation
Frequent use of hands and fingers for data entry, keyboarding, and mouse use
Ability to view computer screens for prolonged periods
Ability to communicate effectively in person, by phone, and via email
Occasional standing, walking, bending, or reaching while supporting manufacturing floor activities
Ability to lift up to 25 pounds occasionally
Ability to work in a manufacturing environment with exposure to noise, moving equipment, and varying temperatures
Must be able to wear required Personal Protective Equipment (PPE), including safety glasses, hearing protection, and safety shoes

View full job page →

Get Data Jobs in Ontario, CA alerts

New Data Jobs in Ontario, CA, daily.