Technical Business Systems Analyst – Factory Systems

Its fun to work in a company where people truly BELIEVE in what theyre doing!
Were committed to bringing passion and customer focus to the business.

Position Title: Technical Business Systems Analyst Factory Systems

Employment Type: Full-time Existing vacancy

Location: San Jose ( Ridder)

About Lumentum

At Lumentum were building the tech behind the worlds 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.

Were 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 youll fit right in.

Why Youll 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 Youll 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 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 Were Looking For

Education:
Bachelors 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 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 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 Youll 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 Thats Shaping the Future

At Lumentum were more than just a workplacewere a launchpad for creativity and innovation. Were committed to celebrating your unique talents and helping you grow. Our guiding principlesInnovate Engage Deliver Excel and Winarent just words; theyre the heart of what we do.

Lets Build a Brighter Future Together!

Were 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 to request accommodation.

Join usyour future starts here!

Pay Range:

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.