Data Engineer

Location: Home-based in the U.S. or Canada

Summary: IQVIA is seeking an experienced Data Engineer to join an Advanced Analytics group within the Clinical Data Science department. Work in our team that is dedicated to the long-term efforts of a prominent Pharmaceutical company. Work fully within the environment of the Pharma. As a Data Engineer, you will play a crucial role in transforming raw data into meaningful insights that drive decision-making and innovation. You will work closely with a team of data scientists and other data engineers in a fast-paced, collaborative environment.

Responsibilities:

• SQL Query Assistance: Assist data scientists in crafting SQL queries to extract data from individual or multiple, large databases. This includes feature engineering, where new, model-useful features are derived from database records through operations like summing or counting.

• Optimizing Database and Query Performance: Develop materialized views and implement indexing strategies to enhance query speed and ensure efficient execution of application-specific queries. Write efficient queries that don’t require materialized view creation when possible.

• Data Quality Monitoring: Help establish a robust data quality monitoring framework for early detection and resolution of data quality issues following bulk data loads.

• Data Mastery Enhancement: Collaborate with fellow data engineers to boost data mastery regarding critical dimensions across input data sources feeding into the integrated data model. This includes tasks such as address cleaning, completion, standardization, fuzzy string matching, and other advanced methods of preparing records and merging them when they are equivalent across sources.

• Database Documentation Maintenance: Maintain and develop comprehensive database documentation for other users and data scientists.

Qualifications:

• Bachelor’s degree or higher in Computer Science, Data Science, or related field.

• Proven experience as a Data Engineer, Software Developer, Data Scientist.

• Strong knowledge of SQL, database structures, schema design, and query tuning principles, and practices. Extensive experience with Postgresql, specifically, is desired.

• Familiarity with Python is also necessary.

• Familiarity with data quality monitoring and data preparation techniques.

• Familiarity with the pharmaceutical industry and clinical data is a strong plus, but it is not required.

• Excellent problem-solving skills and attention to detail.

• Strong communication skills and ability to work collaboratively in a team-oriented environment.

IQVIA is a leading global provider of advanced analytics, technology solutions and clinical research services to the life sciences industry. 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. Learn more at https://jobs.iqvia.com

We are committed to providing equal employment opportunities for all, including veterans and candidates with disabilities. https://jobs.iqvia.com/eoe

IQVIA’s ability to operate and provide certain services to customers and partners necessitates IQVIA and its employees meet specific requirements regarding COVID-19 vaccination status. https://jobs.iqvia.com/covid-19-vaccine-status

The potential base pay range for this role, when annualized, is $111,400.00 – $167,100.00. The actual base pay offered may vary based on a number of factors including job-related qualifications such as knowledge, skills, education, and experience; location; and/or schedule (full or part-time). Dependent on the position offered, incentive plans, bonuses, and/or other forms of compensation may be offered, in addition to a range of health and welfare and/or other benefits.