Technical Business Systems Analyst - Factory Systems

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.

What You'll Be Doing

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.

What We're Looking For

Education:
Bachelor's degree in Mechanical Engineering, Electrical Engineering, Physics, Materials Science, or related field


Experience:
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, WIP, BOM, inventory, quality, and traceability.
• Strong communication skills with both technical and non-technical users.

Preferred Qualifications

• Experience with Siemens Opcenter, MES, MOM, Oracle EBS, or other manufacturing systems .
• Experience in semiconductor, optics, electronis, medical device, or high-tech manufacturing.
• Experience with ERP manufacturing modules such as:
  • BOM
  • WIP
  • Inventory
  • Quality
  • Costing
  • Purchasing
• Experience with APIs, web services, ETL tools, or middleware.
• Experience with Power BI data modeling and dashboard development.
• Familiarity with manufacturing KPIs such as yield, cycle time, OEE, scrap, rework, and throughput.
• Familiarity with SOX, ISO, or regulated manufacturing environments.
• Experience with system testing, UAT, and production support.

Technical Skills

• Languages: C#, .NET, ASP.NET, SQL, T-SQL
• Databases: Microsoft SQL Server, Oracle Database preferred
• Reporting Tools: SSRS, Power BI, Crystal Reports, Tableau, or similar
• Applications: MES, ERP, WIP, BOM, Inventory, Quality, Manufacturing Systems
• Integration: APIs, web services, ETL, file-based interfaces, database interfaces
• Tools: Visual Studio, SQL Server Management Studio, Azure DevOps or similar ticketing/version control tools

Success Measures

• Accurate and reliable manufacturing reports and dashboards.
• Timely delivery of report and application enhancements.
• Improved visibility into production, quality, WIP, inventory, and traceability data.
• Reduced manual reporting and data reconciliation effort.
• Faster resolution of factory system and reporting issues.
• Strong partnership with Manufacturing, Operations, Quality, and Supply Chain teams.

Perks You'll Love

• Flexible time off
• Health and wellness benefits (physical and mental)
• Tuition reimbursement and career growth support
• A workplace built for you: free gym, games room, prayer room
• Subsidized meals, free coffee/tea
• Employee stock options and incentive plans
• A collaborative, innovative, and inclusive culture

Join a Team That's Shaping the Future

At Lumentum, we're more than just a workplace-we're a launchpad for creativity and innovation. We're committed to celebrating your unique talents and helping you grow. Our guiding principles-Innovate, Engage, Deliver, Excel, and Win-aren't just words; they're the heart of what we do.

Let's Build a Brighter Future Together!

We're committed to building an inclusive workplace where everyone feels valued and empowered. We welcome applicants from all backgrounds and provide accommodations for individuals with disabilities throughout the hiring process. Your uniqueness makes us stronger, sparks creativity, and drives our success.

Please contact us at View email address on click.appcast.io to request accommodation.

Join us-your future starts here!

Pay Range:
P80-USA-1 :$145,550.00 - $207,900.00
Disclaimer:

Final base salary for the successful candidate will depend on multiple factors, including but not limited to, job location, where work will be performed, qualifications, work history and relevant experience. With our continual goal of making Lumentum a best place to work for our employees, we strive to offer employees competitive total compensation packages, which may include annual bonus, commission for certain sales roles, equity, and health and welfare benefits.