ERP Data Analyst

Canopy Ad; Irvine (CA); On-site; USD 130,000 - 155,000; Full time

Benefits offered by this job

Medical, Dental, Vision benefits

401K company match

Job summary

Canopy A&D is seeking an ERP Data Analyst to support Epicor ERP migration in an aerospace manufacturing setting. You will maintain data integrity, develop BAQs, dashboards, and reports, and provide actionable insights to operations, IT, Finance, Supply Chain, Quality, and Manufacturing.

The ideal candidate has 3+ years of Epicor data analysis in manufacturing, strong SQL/Power BI skills, and knowledge of AS9100/ITAR. Must be a US person and able to travel to Ontario and Riverside locations.

Qualifications

• Bachelor’s degree or equivalent in Data Analytics, Information Systems, Business, Engineering, or related field.
• 3+ 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).
• Experience developing BAQs, dashboards, and reports within Epicor.
• Proficiency in SQL, Power BI, and SSRS.

Responsibilities

• Serve as SME for Epicor ERP data structures and processes.
• Maintain data integrity across Manufacturing, Inventory, Supply Chain, Finance, Quality, and Engineering modules.
• Develop and automate BAQs, dashboards, reports, and KPIs.
• Provide timely operational, financial, and executive-level reporting.

Skills

Analytical thinking

Problem solving

Attention to detail

Communication

Team collaboration

Education

Bachelor’s degree or equivalent in Data Analytics/IS/Engineering

Tools

Epicor ERP (Kinetic)

SQL

Power BI

SSRS

Job description

About Canopy Aerospace & Defense

Canopy A&D is built to accelerate the future of advanced materials for space, defense, and maritime systems. Canopy delivers specialized materials and components that carry customers from concept through sustainment. Canopy A&D’s advanced signal attenuation technologies and production-scale manufacturing accelerate the fielding of platforms that are faster, cooler, and quieter. Our adaptive approach ensures solutions evolve at the pace of shifting challenges, keeping our customers ahead of the curve.

Summary:

The ERP Data Analyst will support the Epicor ERP system migration and implementation within an aerospace manufacturing environment. This role is responsible for maintaining data integrity, developing reports and dashboards, and providing actionable insights to operational teams. The analyst partners closely with IT, Finance, Supply Chain, Quality, and Manufacturing to improve system utilization and enable data-driven decisions. The ideal candidate has strong manufacturing knowledge and understands aerospace compliance requirements.

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.

Required Qualifications

• Bachelor's degree in Data Analytics, Information Systems, Business, Engineering, or related field (or equivalent experience)
• 3+ 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.
• Aerospace or other regulated manufacturing experience
• Working knowledge of SQL, Power BI, SSRS, or similar tools
• Experience supporting ERP implementations or major system upgrades
• Understanding of standard costing, variance analysis, and manufacturing KPIs
• Familiarity with AS9100, ITAR, or government contract reporting
• 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
• Must have professional working proficiency reading, writing, and speaking English
• Ability to work in office, lab, and manufacturing environments with occasional exposure to noise, chemicals, dust, industrial equipment, and temperature variations
• Abilityto sitor standforextended 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
• Abilityto use a computer to complete assignments
• Ability to work extended hours and weekends as necessary
• Ability to obtain and maintain a US Government Secret security clearance

The above statements are intended to describe the general nature and level of work performed. They are not intended to be an exhaustive list of all responsibilities, duties, or skillsrequired. Management maymodifyor assignadditionalduties as needed.

Salary, Type & Other

Salary range: $130,000 to $155,000

Type: Full Time, Exempt (Salaried)

Reports to:CIO

Travel:willingness to travel to our Ontario, CA and Riverside, CA locations as needed

Your actual level and base salary will be determined on a case-by-case basis and may vary based on the following considerations: job-related knowledge and skills, education, and experience.

Total compensation will also include a comprehensive set of benefits including but not limited to: Company paid employee medical, dental and vision insurance. 401K company match (eligibility required), paid sick leave, paid vacation, paid holidays and discretionary bonuses.

EXPORT CONTROL REQUIREMENTS:

To conform to US Government export regulations, the applicant must be a (i) US Citizen, (ii) lawful permanent resident of the U.S. (aka green card holder), (iii) protected individual as defined by U.S.C. 1324b(a)(3), or (iv) eligible to obtain the required authorizations from the U.S. Department of State.

Canopy A&D is an Equal Opportunity Employer, employment with Canopy A&D is governed on the basis of merit, competence and qualifications and will not be influenced in any manner by race, color, religion, gender, national origin/ethnicity, veteran status, disability status, age, sexual orientation, gender identity, marital status, mental or physical disability or any other legally protected status.