Title: Data Scientist
Develop an automated ELT process to update our Snowflake data warehouse when processed data is made available in our AWS data lake. Pull data from external sources and APIs to enrich the data in the data warehouse. Perform scheduled data loads from one data warehouse into another (or into a smaller scale database). Help develop a standard data model and ontology. Help establish role-based access controls (RBAC) for an enterprise-wide data warehouse. Support the development of distributed data processing pipelines.
The platforms or services they need experience with are: AWS (3+ years) and Snowflake (1+ years). It’d also be good if they had some experience with other databases, such as PostgreSQL or others. Within AWS, the most common services to understand are S3, Glue, Lambda, SNS, RDS.
ETL/ELT software experience: One of Matillion, Snowpipe (Snowflake native data loading tool), or Glue (2+ years in at least one of them). They should start working with one of these immediately without supervision.
At IQVIA, we believe in pushing the boundaries of human science and data science to make the biggest impact possible – to help our customers create a healthier world. The advanced analytics, technology solutions and contract research services we provide to the life sciences industry are made possible by our 70,000+ employees around the world who apply their insight, curiosity and intellectual courage every step of the way. Learn more at jobs.iqvia.com.