Person, Clothing, Scientist, Lab, Coat, Sunglasses, Accessories, Lab Coat, Building, Clinic

Solutions Architect (Analytics)

IMPORTANT ALERT FOR JOB APPLICANTS!
Bio-Rad has received reports of individuals posing as Bio-Rad recruiters to obtain information from applicants. Be aware that Bio-Rad strictly adheres to these hiring practices.

Solutions Architect (Analytics)

  • 2022-30438
  • Remote, United States

As one of our Solutions Architecture Staff, you will be responsible for architecting and building ETL Orchestrations, Jobs, Components and database schemas within Snowflake Databases and Matillion ETL components to answer business user stories around reporting and analytics. You will be expected to operate in a dynamic, complex and multi-time zone environment; delivering data on-time, in full and accurately. Your duties may include working with our medical instruments teams for fast moving lifesaving data or with our finance teams to create worldwide reporting into critical areas such as margin, revenue and salesperson performance.

It is expected that you will be a flexible player, able to switch from various subject areas with ease and interact with business users to understand requirements, caveats and unique scenarios around the data. You will be exposed to business intelligence innovation, data lake implementation, data science projects, ERP expansions and a growing cloud analytics environment @ Bio-Rad. We operate in an SAP Environment, and deep understanding of SAP Plant, Master and Transactional data is pivotal to your work. Data Visualization is also a key deliverable for our group and you will be expected to learn the impact of your work on the presentation layer in Power BI. It is expected that you will learn to deconstruct and re-engineer user created intellectual property in PowerBI and other ETL Tools (for ex. NiFi, Alteryx and SAS) and escalate it to an enterprise level of refinement within our chosen Snowflake Data Lake and Matillion ETL environment. 

Training will occur in the latest data warehousing, data mart and ETL techniques with top line tools (Snowflake & Matillion). ERP Exposure and training will include SAP & Attunity Replicate for SAP/Snowflake. Visualization Training will include Power BI and general practices. You will be trained in the usage of Testing Automation tools to FUT your work and QA the work of other developers.

Responsibilities

In this role, you will be a key contributor to the team with the following responsibilities:

  • Demonstrate and apply strong knowledge of SAP ERP systems as a data source. 
  • Take business requirements and design documentation and create architecture and ETL Pipelines in Matillion ETL scheduled jobs and orchestrations as well as Snowflake tables and schemas. 
  • Develop Analytics solutions following Bio-Rad standards to ensure ease of understanding from other development and support staff. 
  • Assist with testing your own and other team members’ solutions alongside our Data Quality team, utilizing test automation tools and frameworks to accelerate testing at scale. 
  • Participate in routine maintenance, performance tuning and support of ETL Environments and the DW Environment. 
  • Participate in monitoring of the ETL Environments for Matillion, Attunity Replicate and Snowflake DW. 

Potentially be available to: 

  • Participate in Machine Learning objectives by providing data lake solutions. 
  • Participate in application integrations utilizing data from the data lake. 
  • Develop or Run Test Automation tools and scripts in coordination with the Testing Team.

Qualifications

  • 5 years + experience with: 
  • SAP R/3 ECC and ERP systems as a source with deep understanding of SAP Data Schemas. 
  • Enterprise level, component based ETL Development. Using tools similar to Informatica, Pentaho Kettle, Microsoft SSIS, Talend, Matillion, AWS Glue etc. 
  • Enterprise class relational data warehouse solutions such as Snowflake, Postgres, Microsoft SQL Server etc. bonus for cloud products. 
  • Solutioning in a complex ETL Environment with hundreds or thousands of scheduled load processes. Understanding of cross pipeline impacts and mitigating risks. Global environment spanning many time zones is preferred. 
  • 2 years + experience with: Enterprise level Data Visualization Tools such as Power BI, Tableau, Microstrategy, Pentaho BI etc. 
  • Test Automation as a participant.

Vaccination Requirement:  Ability and consent to upload proof of completed Covid-19 vaccination into our secure database within 3 days of start date. 

 

Who We Are:  For 70 years, Bio-Rad has focused on advancing the discovery process and transforming the fields of science and healthcare. As one of the top five life science companies, we are a global leader in developing, manufacturing, and marketing a broad range of high-quality research and clinical diagnostic products. We help people everywhere live longer, healthier lives. Recently voted a Best Place to Work, Bio-Rad offers a unique employee experience with collaborative teams that span the globe. Here, you are supported by leadership to build your career and are empowered to drive change that makes an impact you can see 

 

Benefits:  We’re proud to offer a variety of options, including competitive medical plans for you and your family, free HSA funds, a new fertility offering with stipend, life and disability, paid parental leave, 401k plus profit sharing, employee stock purchase program, a new upgraded and streamlined mental health platform, extensive learning and development opportunities, education benefits, student debt relief program, pet insurance, wellness challenges and support, paid time off, Employee Resource Groups (ERG’s), and more!

 

EEO Statement: Bio-Rad is an Equal Employment Opportunity/Affirmative Action employer, and we welcome candidates of all backgrounds. Veterans, people with disabilities, and people of all races, ethnicities, genders, ages, and orientations are encouraged to apply. 

 

Agency Non-Solicitation:  Bio-Rad does not accept agency resumes, unless the agency has been authorized by a Bio-Rad Recruiting Representative. Please do not submit resumes unless authorized to do so. Bio-Rad will not pay for any fees related to unsolicited resumes. 

 

#LI-AS1

#LI-Hybrid

More About Us

Couldn't find the role you were looking for?

Not You?

Thank you

Apply Now 

Alert me about jobs like this

Not You?

Thank you

Meet a Bio-Radian

Hear what it's like to work at Bio-Rad.

4_stars.png

“Cutting Edge Bio-Tech Company”

Senior SEO & Onsite Search Manager (Former Employee) Hercules, CA

"Bio-Rad is staffed by some of the smartest people in the industry, and offers a very good balance of work life..."

Other People Viewed

Marketing Manager II 2022-30398.2 Hercules California United States Hercules, California, United States Product Marketing You will be the Marketing Manager for our new Molecular Dx products with a focus on infectious disease within the US market. You will also be a key contributor on the infectious disease global marketing team and will support multiple initiatives a...
Market Development Manager (Chromatography) - $10,000 Hiring Bonus 2022-27955.2 Hercules California United States Hercules, California, United States Marketing A Snapshot of Your Day  As a Market Development Manager (Product Dev III) supporting our Protein Purification business, you’ll provide researchers with the chromatography tools they need to discover and purify proteins at every stage – from the la...
Material Handler - Temp 2022-30879 Richmond California United States Richmond, California, United States Warehouse/Distribution Performs a variety of routine, repetitive, physical and administrative tasks in a warehouse involving one or more of the following:  receiving, putting away, storing, staging, kitting, picking, packing and shipping of materials, parts, supplies, e...
Production Operator I 2022-30838 Santa Rosa California United States Santa Rosa, California, United States Manufacturing/Production This position will be in support of Bio-Rad's injection molding facility in Santa Rosa, CA. This position is responsible for the visual inspection and the packaging of injection molded product. Responsibilities You will be responsible for packagin...
Quality Mgr II 2022-30629 Irvine California United States Irvine, California, United States Quality & Regulatory QA Manager II reponsible for document control, change control, validation review board, eQMS implementation/maintenance, SAP master data, and batch record review/relelase. This employee will be responsible for a team of approx. 15 direct and indir...
Senior Financial Analyst 2022-30872 Hercules California United States Hercules, California, United States Finance As a Senior Financial Analyst at Bio-Rad you will be a key part of the Global Commercial Operations (GCO) finance team. You will partner with functional leaders to prepare budgets, forecasts, monthly financial analysis and reporting, and provide a...