ETL Developer II/III
This job posting is no longer active.
Location: Salt Lake City, UT, United States
Position Type: Unfixed Term
Job Function: Information Technology
A family-owned company, bioMérieux has grown to become a world leader in the field of in vitro diagnostics. For almost 60 years and across the world, we have imagined and developed innovative diagnostics solutions to improve public health. Today, our teams are spread across 44 countries and serve 160 countries with the support of a large distribution network. This includes our SLC site, formerly known as BioFire Diagnostics.
Description
Position Summary:
ETL Developer will analyze, design, develop, test and maintain the data pipeline component of BioFire’s Data Warehouse. This includes refinement of stored procedures to improve daily and real-time data loads in effort to make them more efficient and scalable. Work work closely with BI Analysts and Engineers to build a Data Warehouse that provides quality, accurate, accessible and governed data capable to deliver business insight to various BioFire business domains through reporting, dashboards and visualization. Promote Kimball methodology and utilize current technology stack to find innovative solutions to complex data problems. Ability to work as a team player alongside a talented group of individuals for the same cause is essential to success in the role.
Responsibilities:
- Perform all work in compliance with company policy and within the guidelines of BioFire’s Quality System.
- Understand BioFire’s technical and scientific mission.
- Understand technical and functional components of BioFire Diagnostics
- Perform lead role in development of BI infrastructure including design, build, management, maintenance, and optimization of a data warehouse
- Achieve optimal target architecture by analyzing current ETL landscape and determine if pipelines are best handled through an ETL tool, stored procedures or a combination of both
- Participate in requirements, design, and analysis sessions to ensure sound team decision-making and effective ETL strategy that aligns with BioFire company objectives
- Adapt ETL processes to accommodate changes in source systems and new business user requirements
- Develop, test, monitor and troubleshoot ETL processes
- Automate the ETL process through scheduling and exception-handling routines as well as source to target mapping development, support and maintenance
- Thoroughly document ETL process and overall Data Warehouse landscape within Data Catalog
- Participate in collaboration efforts with global BI development teams (e.g. bioMerieux France, Cognizant development team in India)
- Must be familiar with a variety BI concepts, practices, and procedures.
- Collaborate with internal data analyst/science teams to provide accurate analytics to business and a data warehouse/lake that allows for flexibility and usability
- Where applicable, build out new and useful technologies within our Microsoft Azure environment such as Azure Databricks, Azure Machine Learning, and big data technologies such as Hive, Spark, and Kafka
- Prioritize and complete data requests in a timely manner
- Complete projects on time with minimal supervision.
- Continually update technical knowledge and skills.
- Participate in sprint planning, standup and retrospective meetings as needed
- Domestic and international travel may be required.
Training and Education:
Level II
- BS degree in Computer Science, IS, IT or related field required; advanced degree preferred
- Professional BI certifications preferred
- Minimum 3+ years of relevant experience required
- Experience in BI / data integration and solution implementation projects required (BI architecture and design, solution implementation, and/or data warehouse development); MS Azure, Amazon AWS, and/or SAP Hana (SCP) preferred
Level III
- BS degree in Computer Science, IS, IT or related field required; advanced degree preferred
- Professional BI certifications preferred
- Minimum 5+ years of relevant experience required
- Experience in BI / data integration and solution implementation projects required (BI architecture and design, solution implementation, and/or data warehouse development); MS Azure, Amazon AWS, and/or SAP Hana (SCP) preferred
Skills and Qualifications:
- Previous experience in BI / data integration and implementation projects required (BI architecture and design, solution implementation, and/or data warehouse development)
- Understands ERP and CRM systems data infrastructure and how it relates to transformation requirements (data warehouse) for analysis.
- Expert level in SQL (MS SQL/TSQL, MySQL, and/or Amazon Redshift SQL)
- Expert level experience with one or more ETL Tools (SAP Data Services, MS Data Factory, Oracle Data Integrator, Informatica, SSIS)
- Expert level experience with stored procedures
- Experience with Data Warehouse design methodologies (Kimball)
- Experience in BI Software (Power BI, DOMO, Tableau, etc.) preferred
- Experience in one of the following programming/analytical languages: R, Python, C#, Java
- Experience working with data from SAP and Salesforce a plus
- Experience with Jira preferred
- Proficient in MS Office Suite and flow charts software
- Drive for continuous improvement
- Must demonstrate ability to communicate effectively and work well with team
- Must demonstrate ability to complete objectives without high levels of supervision.
#BmxSLC
Please be aware that recruitment related scams are on the rise. Fraudulent job postings are being placed on other websites, and individuals posing as bioMérieux Talent Acquisition team members are reaching out via email or text message in an attempt to collect your personal and confidential information. In some cases, these scammers are also conducting bogus interviews prior to extending fraudulent offers of employment. Beware of individuals reaching out using general phone numbers and non-bioMerieux email domains (i.e. Hotmail.com, Gmail.com, Yahoo.com, etc.). If you are concerned that an interview experience or offer of employment might be a scam, please make sure you are searching for the posting on our careers site https://careers.biomerieux.com/ or contact us at [email protected].
BioMérieux Inc. and its affiliates are Equal Opportunity/Affirmative Action Employers. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information. Please be advised that the receipt of satisfactory responses to reference requests and the provision of satisfactory proof of an applicant’s identity and legal authorization to work in the United States are required of all new hires. Any misrepresentation, falsification, or material omission may result in the failure to receive an offer, the retraction of an offer, or if already hired, dismissal. If you are a qualified individual with a disability, you may request a reasonable accommodation in BioMérieux’s or its affiliates’ application process by contacting us via telephone at (385) 770-1132, by email at [email protected], or by dialing 711 for access to Telecommunications Relay Services (TRS).
