The Opportunity:
Works independently under close supervision, assist in the design and development of data storage systems, processes and enhancements for company's complex high traffic, business critical internet site communications and/or network-based (cloud) product systems. Assist with the implementation of new or additional storage technology to improve infrastructure service locally and remotely.
Avantor Sciences is seeking an Associate Snowflake Data Engineer to enhance our Enterprise Data Warehouse and Data Lake initiatives. You will collaborate with Data Architects and Analytics teams to develop data pipelines for various use cases.
Employment based on a temporary contract.
Key Responsibilities:
-
Develop data pipelines to integrate data from multiple sources into Snowflake.
-
Collaborate with the DW team on “Source to Target” data mapping and transformations.
-
Monitor and maintain data pipelines in production.
-
Automate the creation of transformed tables using existing frameworks in Snowflake.
-
Schedule jobs for Change Data Capture (CDC) and Snapshot data capture.
Qualifications:
-
Bachelor’s Degree in Engineering (Computer Science or equivalent); advanced degree preferred.
-
Extensive experience in data engineering, building data pipelines, ETLs, and cloud technologies.
-
Significant SQL experience; shell scripting is a plus.
-
Experience with Power BI or similar tools.
-
Background as a Snowflake Data Engineer; substantial experience in Data Warehouse/ETL/BI projects.
Skills Required:
-
Expertise in Snowflake SQL/PL/SQL, complex stored procedures, and DWH/ETL concepts.
-
Experience with real-time change data capture and end-to-end Snowflake implementations.
-
Knowledge of AWS storage technologies (e.g., S3) and dimensional data modeling.
-
Familiarity with job scheduling, error capture, and data transformations.
If you are passionate about data engineering and want to make an impact, we encourage you to apply!
Disclaimer:
The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees assigned to this position. Avantor is proud to be an equal opportunity employer.
Why Avantor?
Dare to go further in your career. Join our global team of 14,000+ associates whose passion for discovery and determination to overcome challenges relentlessly advances life-changing science.
The work we do changes people's lives for the better. It brings new patient treatments and therapies to market, giving a cancer survivor the chance to walk his daughter down the aisle. It enables medical devices that help a little boy hear his mom's voice for the first time. Outcomes such as these create unlimited opportunities for you to contribute your talents, learn new skills and grow your career at Avantor.
We are committed to helping you on this journey through our diverse, equitable and inclusive culture which includes learning experiences to support your career growth and success. At Avantor, dare to go further and see how the impact of your contributions set science in motion to create a better world. Apply today!
EEO Statement:
We are an Equal Employment/Affirmative Action employer and VEVRAA Federal Contractor. We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religious creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by federal, state/province, or local law.
If you need a reasonable accommodation for any part of the employment process, please contact us by email at [email protected] and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.
Privacy Policy:
We will use the personal information that you have submitted to us in order to consider your application for the relevant role.
Your privacy is important to us. Please click here for our Privacy Policy which explains the purposes for which we will use your personal information and the ways in which we will handle and retain your information. It also explains the rights you have in relation to your information, and how to contact us with any queries or requests.
3rd Party Non-Solicitation Policy:
By submitting candidates without having been formally assigned on and contracted for a specific job requisition by Avantor, or by failing to comply with the Avantor recruitment process, you forfeit any fee on the submitted candidates, regardless of your usual terms and conditions. Avantor works with a preferred supplier list and will take the initiative to engage with recruitment agencies based on its needs and will not be accepting any form of solicitation.
Top Skills
What We Do
Avantor®, a Fortune 500 company, is a leading global provider of mission-critical products and services to customers in the biopharma, healthcare, education & government, and advanced technologies & applied materials industries.
Our portfolio is used in virtually every stage of the most important research, development and production activities in the industries we serve.
Our global footprint enables us to serve more than 225,000 customer locations and gives us extensive access to research laboratories and scientists in more than 180 countries. We set science in motion to create a better world.
More than 13,500 strong, our associates are passionate about our mission to set science in motion to create a better world. We share enthusiasm for innovation, excellence, and achievement. Whether we are collaborating with our customers to advance science or solve multifaceted problems, we help them reach their goals more efficiently and effectively.
Visit our website to learn more about Avantor.
From FORTUNE. © 2021 FORTUNE Media IP Limited All rights reserved. Used under license. FORTUNE is a registered trademark of FORTUNE Media IP Limited and is used under license. FORTUNE and FORTUNE Media IP Limited are not affiliated with and do not endorse products or services of, Avantor.