IT OT Data & Analytics Engineer

Roche•Hillsboro, OR

1d•Onsite

About The Position

This position, based in Genentech's Hillsboro, Oregon facility, provides the opportunity to have a key role in a highly automated pharmaceutical drug substance facility. The site employs highly integrated computer control systems to manage plant operations and manufacturing data. The candidate will report to the local IT OT organization, an organization that is currently undergoing a transformation towards digitalization, advancing fundamental elements to meet future needs, such as standardizing and leveraging new technologies. The IT OT Team in Hillsboro is supporting Hillsboro Technical Operations (HTO) which is the commercial Make Assess and Release (MAR) and launch site for North America and Hillsboro Individualized and Cell Therapies (HIT) which is transitioning into a multi-product facility for development, clinical and commercial supply capabilities for individualized and cell therapies. The Opportunity The IT OT Data & Analytics Engineer supports the business in providing data and tools to support the digitalization and Industry 4.0 transformation.

Requirements

Bachelors in computer science, data science, engineering or business administration. Alternatively, you have a comparable experience.
At least 3 years of practical professional experience in user-oriented reporting and process data processing and/or in a GMP/CSV regulated environment.
In addition, you have at least 2 years of experience in the management of local and global projects.
Good general GxP knowledge, in particular for Computerized System Validation (CSV) and in applications in the reporting and/or statistical environment.
Knowledge in the areas of gSuite software and methodical business analysis.
Passionate about consulting, implementation and support (ideally in the life sciences industry).
Ability to translate business needs to technical requirements.
Ability to plan, problem solve, and communicate precisely and thoroughly.
Experience with version control (i.e. GitHub, GitLab)
Experience with CI/CD
Familiar with data transformation tools (i.e. dbt) and data storage tools (i.e. AWS, Snowflake)

Responsibilities

Creatively and proactively provide your expertise in the identification, evaluation, design, development, testing, training and go-live of reports and key figures.
Develop secure, scalable, high-performance and reliable data engineering and analytics solutions in a cloud platform such as AWS or Snowflake.
Solve challenging data integration problems for complicated and diverse data sets, utilizing and coding optimal ETL patterns, frameworks, query techniques, and sourcing / merging from structured and unstructured data sources.
Design and develop data pipelines and cloud infrastructure components to support machine learning systems at scale.
Responsible for the validation of GMP-relevant reports, advice on report design to improve the use of the reports and for continuous monitoring of the report portfolio in terms of benefit, use as well as the efficiency and effectiveness of the respective reports.
Provide Application support to deployed data products
System ownership of validated data products
ETL / ELT pipeline creation and maintenance for local source data
Cross-functional collaboration regionally and globally to support site and network digital initiatives
Lead/drive digital initiatives with data engineering best practices (sustainability, documentation, etc.)
Take care of supporting users with questions and problems regarding our data products and analyze and prioritize the incidents in order to enable an effective and fastest possible solution to the existing errors.
Ensure the establishment and active maintenance of expert networks to ensure the support and further development of your own regional key user community including relevant stakeholders.