Business Systems & Automation Analyst - Workday

TekWissen ®; Sunnyvale (CA); On-site; USD 55,000 - 76,000; Part time

Job summary

TekWissen® is seeking a highly motivated Business Systems & Automation Analyst to support the integration, automation, and optimization of manufacturing and laboratory data systems. This role will bridge Operations, Quality, and IT by enabling seamless data flow across ERP systems, scheduling tools, and laboratory workflows.

The ideal candidate will drive automated solutions that connect production orders, scheduling, lab execution, and qualification workflows, with real‑time visibility through

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Business Systems, or related field.
• 1–3 years of experience in business systems, data analysis, or automation‑focused roles.
• Exposure to manufacturing, biotech, or lab environments is required.
• Experience with workflow automation tools (Power Automate, scripting, etc.).
• Familiarity with electronic batch records systems (e.g., Dozuki or similar).
• Strong proficiency with Excel (advanced level), SQL, Python; ERP systems experience (Dynamics/Navision).
• Experience with Power BI or other data visualization tools; Chromeleon or similar lab data systems.
• Basic understanding of database setup and data structures; cross‑functional collaboration skills.

Responsibilities

• Design and implement automated data workflows connecting Microsoft Dynamics NAV (ERP) with scheduling tools, lab workflows, and reporting systems.
• Establish end‑to‑end data flow from production order creation, scheduling, execution, and qualification to reporting.
• Integrate systems to enable real‑time updates across Operations.
• Develop a production scheduling framework/system to optimize resources and reduce delays.
• Create scalable databases and data pipelines for KPIs and ad‑hoc analysis.
• Develop Power BI dashboards to provide real‑time insights for varying audiences.

Skills

Bachelor’s degree

Automation tools

Excel advanced

SQL

Python

Power BI

ERP systems (Dynamics/Navision)

Chromeleon software

Dozuki

Cross-functional collaboration

Education

Bachelor’s degree in Information Systems / CS

Tools

Power Automate

Dozuki

Microsoft Dynamics/Navision

Chromeleon

Job description

TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients worldwide. The job opportunity is for one of our clients specializing in biotechnology product development services. Our client is dedicated to supplying laboratory equipment, chemicals, supplies, and services essential in healthcare, scientific research, safety, and education. As the global leader in serving the field of science, our client boasts an annual revenue of around $40 billion with a mission to empower customers to make the world healthier, cleaner, and safer. Our client's global team is committed to delivering an unparalleled blend of cutting‑edge technologies, convenient procurement options, and pharmaceutical services under their industry‑leading brands.

Position: Business Systems & Automation Analyst - Workday

Location: Sunnyvale, CA - 94085

Duration: 12 Months

Job Type: Temporary Assignment

Work Type: Onsite

Shift: Day Shift

Pay Rate: $40 to $55 per hour

Summary

We are seeking a highly motivated Business Systems & Automation Analyst to support the integration, automation, and optimization of manufacturing and laboratory data systems. This role will serve as a critical bridge between Operations, Quality, and IT by enabling seamless data flow across ERP systems, scheduling tools, and laboratory workflows. The ideal candidate will drive the development of automated solutions that connect production orders, scheduling, lab execution, and qualification workflows, while enabling real‑time visibility through dashboards and reporting tools. This is a contract role supporting a high‑impact initiative to modernize and scale data‑driven operations.

Responsibilities

Systems Integration & Automation

• Design and implement automated data workflows connecting Microsoft Dynamics NAV (ERP) with scheduling tools, lab workflows, and reporting systems
• Establish end‑to‑end data flow from production order creation, scheduling, execution, and qualification to reporting
• Integrate systems to enable real‑time updates across Operations

Production Scheduling Enablement

• Develop and support a production scheduling framework/system that optimizes resources for maximum output
• Improve scheduling efficiency, reducing manual coordination and delays

Data Management & Database Development

• Architect scalable databases to support production, lab, and quality workflows
• Create data pipelines to pull data from various systems and transform to enable KPIs and ad‑hoc analysis
• Cleanse, standardize, and validate data to ensure accuracy and consistency across systems
• Develop data governance policies, standards, and best practices to maintain data integrity and compliance
• Ensure data integrity, accessibility, and scalability across platforms
• Develop Power BI dashboards to provide real‑time insights tailored to varying audiences
• Identify issues and create actionable alerts
• Replace manual reporting processes with automated, scalable solutions
• Support backend data integration from laboratory systems (e.g., Chromeleon)
• Enable linkage between lab data and electronic batch records (e.g., Dozuki or equivalent systems)
• Streamline sample tracking and qualification workflows

Required Skills

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Business Systems, or related field
• 1–3 years of experience in business systems, data analysis, or automation‑focused roles
• Exposure to manufacturing, biotech, or lab environments is required
• Experience with workflow automation tools (Power Automate, scripting, etc.)
• Familiarity with electronic batch records systems (e.g., Dozuki or similar)
• Strong proficiency with Microsoft Excel (advanced level required, macros, Power Query, complex formulas), SQL, Python
• Experience working with ERP systems (Microsoft Dynamics/Navision preferred)
• Experience with Power BI or other data visualization tools
• Experience integrating data from laboratory systems (e.g., Chromeleon or similar platforms)
• Basic understanding of database setup and data structures
• Strong analytical and problem‑solving skills with attention to detail
• Ability to work cross‑functionally with operations, lab, and technical teams

TekWissen® Group is an equal opportunity employer supporting workforce diversity.