Data Analyst (IT role)

Leoforce

Buena Park (CA)

On-site

USD 81,000 - 99,000

Full time

10 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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

Data Analyst (IT role)

Buena Park,CA, US

6987461

Job Description
Experience:

Senior Level

Salary:

$90,000 - $90,000 per year

Job Details

Join a manufacturing team where your data expertise will help drive smarter decisions, stronger operations, and continuous improvement. In this permanent IT role, you will transform manufacturing and business data into actionable insights, build reporting solutions, and support the systems that keep production moving.

You will partner with stakeholders across production, supply chain, inventory, finance, and IT to improve data visibility, streamline reporting, and uncover opportunities to enhance performance.

Responsibilities
  • Develop, maintain, and optimize SQL queries, stored procedures, and data extracts to support reporting and analysis.
  • Design and deliver dashboards that make manufacturing KPIs, trends, and operational performance easy to understand.
  • Develop SSRS reports, including parameter-driven and scheduled reports, to meet business requirements.
  • Analyze data from Syteline ERP and related systems to support production planning, inventory management, purchasing, costing, and financial reporting.
  • Develop and maintain VB.NET applications and VBA automation to streamline workflows, reduce manual effort, and improve reporting efficiency.
  • Collaborate with business users to gather requirements and translate operational challenges into practical 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.
Qualifications
  • 5+ years of relevant experience in data analysis, IT reporting, business intelligence, or a similar role, with experience supporting manufacturing operations.
  • Strong hands‑on experience with SQL, including complex queries, stored procedures, and performance optimization.
  • Proven ability to build dashboards using business intelligence tools such as Power BI, Tableau, or equivalent platforms.
  • Experience developing and maintaining SQL Server Reporting Services (SSRS) reports or equivalent enterprise reporting solutions.
  • Working knowledge of Syteline ERP, also known as Infor CloudSuite Industrial, or an equivalent manufacturing ERP system.
  • Practical development experience with VB.NET and VBA, or equivalent programming and automation technologies.
  • Understanding of manufacturing processes and data, including production, inventory, supply chain, and costing.
  • Strong analytical, troubleshooting, and problem‑solving skills, with close attention to data quality.
  • Ability to communicate technical information clearly and collaborate with both technical teams and business stakeholders.
  • Ability to manage competing priorities and deliver reliable solutions in a fast‑paced manufacturing environment.
  • A degree in information technology, computer science, data analytics, or a related field, or equivalent practical experience.
A bit about us:

family‑owned manufacturer of rubber and sealing products headquartered in Buena Park, California.

Why join us?
  • Competitive Salary
  • Great Benefits (Medical, Dental and Vision)
  • 401k Match
  • Generous paid time off
  • Training
  • Career Advancement
  • Fun, energetic working environment

#manufacturing #sql #power-bi #t-sql #vb-net #dashboards #vba #syteline-erp #develop-ssrs-reports #tier4

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)

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: SQL, Dashboards & ERP
Manufacturing Data Analyst: SQL, Dashboards & ERP

Leoforce • Buena Park (CA)

On-site
USD 81,000 - 99,000
Datawarehouse Developer Manufacturing
Datawarehouse Developer Manufacturing

penumbrainc • Alameda (CA)

On-site
USD 100,000 - 150,000
Data Analyst - Manufacturing
Data Analyst - Manufacturing

BAKER GROUP • Ankeny (IA)

On-site
USD 70,000 - 100,000
Manufacturing Business Analyst
Manufacturing Business Analyst

The Panther Group • New Haven (CT)

On-site
USD 85,000 - 110,000
Manufacturing BI Analyst - Real-Time Dashboards
Manufacturing BI Analyst - Real-Time Dashboards

Baker Group • Ankeny (IA)

On-site
USD 70,000 - 100,000
Manufacturing Data Analyst
Manufacturing Data Analyst

Molex • Camarillo (CA)

On-site
USD 34,000 - 41,000
Data Analytics Engineer
Data Analytics Engineer

Joy Baking Group • Lamonts Corners (PA)

On-site
USD 80,000 - 110,000
Data Analyst III
Data Analyst III

Carex Consulting Group • Lenexa (KS)

Hybrid
USD 90,000 - 120,000
Senior Manufacturing Operations & Digitalization Analyst
Senior Manufacturing Operations & Digitalization Analyst

Yanfeng Global Automotive Interiors • Novi (MI)

On-site
USD 90,000 - 120,000