Manufacturing Data Analyst: SQL, Dashboards & ERP

Leoforce

Buena Park (CA)

On-site

USD 81,000 - 99,000

Full time

10 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Leoforce is seeking a Data Analyst (IT role) in Buena Park, CA to transform manufacturing and business data into actionable insights. You will build reporting solutions, dashboards, and ERP-integrated analyses to support production, inventory, and cost management.

The ideal candidate has 5+ years of data analysis and BI experience, strong SQL skills, and hands-on experience with SSRS, VB.NET, and VBA. Collaboration with IT and business teams is essential to drive data-driven improvements.

Qualifications

  • 5+ years of relevant experience in data analysis, IT reporting, or BI, with manufacturing ops experience.
  • Strong hands-on experience with SQL, including complex queries, stored procedures, and performance optimization.
  • Proven ability to build dashboards using BI tools such as Power BI or Tableau.
  • Experience developing and maintaining SSRS reports or equivalent enterprise reporting solutions.
  • Working knowledge of Syteline ERP (Infor CSI) or equivalent manufacturing ERP.
  • Practical development experience with VB.NET and VBA, or equivalent programming and automation technologies.
  • Understanding of manufacturing processes and data across production, inventory, supply chain, and costing.
  • Strong analytical, troubleshooting, and problem-solving skills with data quality focus.
  • Ability to communicate technical information clearly with technical and business stakeholders.

Responsibilities

  • Develop, maintain, and optimize SQL queries, stored procedures, and data extracts for reporting and analysis.
  • Design and deliver dashboards that highlight KPIs, trends, and operational performance in manufacturing.
  • Develop SSRS reports, including parameter-driven and scheduled reports to meet business needs.
  • Analyze data from Syteline ERP and related systems to support production planning, inventory, purchasing, costing, and financial reporting.
  • Develop and maintain VB.NET applications and VBA automation to streamline workflows and improve reporting efficiency.
  • Collaborate with business users to gather requirements and translate operational challenges into technical solutions.
  • Validate data accuracy, investigate discrepancies, and improve consistency across reports and dashboards.
  • Troubleshoot reporting and application issues, optimize performance, and document solutions.
  • Support testing, deployment, and adoption of reporting enhancements and ERP-related changes.

Skills

SQL queries
Dashboards
SSRS reports
VB.NET
VBA
Syteline ERP
Data analysis
Manufacturing domain
Communication

Education

Degree in IT/CS/Data Analytics

Tools

Power BI
Tableau
SSRS
VB.NET
VBA

Job description

Leoforce is seeking a Data Analyst (IT role) in Buena Park, CA to transform manufacturing and business data into actionable insights. You will build reporting solutions, dashboards, and ERP-integrated analyses to support production, inventory, and cost management.

The ideal candidate has 5+ years of data analysis and BI experience, strong SQL skills, and hands-on experience with SSRS, VB.NET, and VBA. Collaboration with IT and business teams is essential to drive data-driven improvements.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst (IT role)
Data Analyst (IT role)

Leoforce • Buena Park (CA)

On-site
USD 81,000 - 99,000
Data Analyst — Manufacturing Intelligence & Dashboards
Data Analyst — Manufacturing Intelligence & Dashboards

Jobot • Buena Park (CA)

On-site
USD 81,000 - 99,000
Great benefits (Medical, Dental &
401k match
Generous paid time off
+4
Manufacturing Data Analyst & ERP Optimization
Manufacturing Data Analyst & ERP Optimization

Velocity Machine, Inc. • De Pere (WI)

On-site
USD 70,000 - 100,000
Enterprise Data Analyst - Manufacturing & Finance
Enterprise Data Analyst - Manufacturing & Finance

MP Materials • Las Vegas (NV)

On-site
USD 90,000 - 140,000
ERP Data Analyst: Turn Production Data into Insights
ERP Data Analyst: Turn Production Data into Insights

swipejobs LLC • California

On-site
USD 28,000 - 30,000
Medical, Dental & Vision Insurance
401(k)
Paid Holidays & Vacation
+3
Data Insights Analyst: ERP & BI Dashboards
Data Insights Analyst: ERP & BI Dashboards

Pro Mach, Inc. • Kentucky

Hybrid
USD 65,000 - 90,000
Medical/dental programs
Life insurance
Paid time off (PTO)
+2
Senior Data Analyst - SQL & Power BI for Manufacturing
Senior Data Analyst - SQL & Power BI for Manufacturing

Carex Consulting Group • Lenexa (KS)

Hybrid
USD 90,000 - 120,000
Data Analyst - Onsite Power BI & ERP Insights for Ops
Data Analyst - Onsite Power BI & ERP Insights for Ops

Ledgent Technology • Irvine (CA)

On-site
USD 62,000 - 69,000
Annual discretionary bonus
Benefits
3 weeks PTO
Manufacturing Data Analytics Specialist
Manufacturing Data Analytics Specialist

Amphenol Communications Solutions • Yocumtown (PA)

On-site
USD 85,000 - 110,000
Senior Analytics Engineer: ERP + Manufacturing Power BI
Senior Analytics Engineer: ERP + Manufacturing Power BI

FLIR Systems, Inc. • United States

Remote
USD 120,000 - 160,000