Technical Business Systems Analyst - Factory Systems

Responsibilities

• Business Systems Support
• Work with Manufacturing, Operations, Quality, and Supply Chain users to gather and document business and reporting requirements.
• Support factory systems used for production execution, WIP tracking, inventory, quality, and traceability.
• Analyze system issues, data discrepancies, and process gaps.
• Translate business requirements into technical specifications for reports, queries, interfaces, and system enhancements.
• Provide day-to-day support for manufacturing applications and related databases.
• Reporting, Analytics & Data Development
• Develop, modify, and maintain operational reports using SQL, MS SQL Server, SSRS, Power BI, or similar reporting tools .
• Create reports for production status, WIP, yield, cycle time, quality, inventory, material usage, and traceability.
• Develop and support dashboards for factory performance, operational KPIs, and management reporting.
• Validate report accuracy by working with business users and comparing data across systems.
• Support automation of manual reporting and data extraction processes.
• Application Development & Technical Support
• Develop and maintain small to mid-size applications, utilities, scripts, or enhancements using C#, .NET, ASP.NET, APIs, and SQL Server .
• Support integration between factory systems, ERP, and reporting platforms.
• Troubleshoot application, database, and interface issues.
• Work with internal IT teams and vendors to resolve system defects and performance issues.
• Assist with testing, deployment, and documentation of application changes.
• Factory Systems & ERP Integration
• Support integration between factory applications and ERP systems such as Oracle EBS or similar platforms.
• Assist with data flows related to: Production orders
• Work-in-process transactions
• BOM and routing data
• Inventory and material movements
• Quality results
• Traceability data
• Shop-floor reporting
• Monitor and troubleshoot interface errors between MES, ERP, and reporting systems.
• Support data reconciliation between factory systems and ERP.
• Process Improvement & Documentation
• Identify opportunities to improve reporting, data quality, and system efficiency.
• Document business processes, system workflows, technical specifications, and support procedures.
• Participate in system upgrades, enhancements, and testing activities.
• Support change control and release management for factory system changes.
• Train users on reports, dashboards, and system functionality.

Requirements

• Education:
• Bachelor's degree in Mechanical Engineering, Electrical Engineering, Physics, Materials Science, or related field
• The ideal candidate will have:
• 8+ years of experience as a Business Systems Analyst, Technical Analyst, Report Developer, Application Analyst, or similar role.
• Strong hands-on experience with Microsoft SQL Server .
• Strong SQL development skills,
• Experience with C#, .NET, ASP.NET, or related Microsoft development technologies .
• Experience supporting manufacturing, factory, ERP, MES, or shop-floor systems.
• Ability to gather requirements from business users and translate them into technical solutions.
• Strong troubleshooting skills across applications, databases, reports, and interfaces.
• Good understanding of manufacturing data flows such as production orders,

Additional Information

It's fun to work in a company where people truly BELIEVE in what they're doing! We're committed to bringing passion and customer focus to the business. If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us! Position Title: Technical Business Systems Analyst - Factory Systems Employment Type: Full-time, Existing vacancy Location: San Jose ( Ridder) About Lumentum At Lumentum, we're building the tech behind the world's fastest networks and most advanced systems. Our optical and photonic solutions power everything from AI and cloud computing to data centers, telecom, and advanced manufacturing. We're a global team of innovators working where light meets technology, solving big challenges that keep the world connected and moving forward. If shaping the future of connectivity excites you, you'll fit right in. Why You'll Love This Role The Technical Business Systems Analyst - Factory Systems will support Manufacturing, Operations, Quality, and Supply Chain teams by developing, maintaining, and improving factory systems, reporting solutions, and system integrations. This role requires strong hands-on technical skills in Oracle SQL, Microsoft SQL Server, C#, .NET, reporting tools, and manufacturing systems. The analyst will work closely with business users to understand requirements, develop reports and dashboards, troubleshoot system issues, support data integration between factory systems and ERP, and help improve manufacturing data visibility. The ideal candidate has experience supporting manufacturing or factory applications such as MES, MOM, ERP, WIP, BOM, inventory, quality, production reporting, and shop-floor systems.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at lumentum? Share your experience