Skip to main content

This job has expired

You will need to login before you can apply for a job.

Senior Scientist, I Genomics Database Developer

Employer
AbbVie
Location
Lake County, Illinois
Start date
Feb 25, 2024

Job Details

The Genomics Research Center (GRC) is a center of excellence for genetics and genomics that supports both Discovery and Development. The GRC plays an integral role towards our goal of developing extraordinary genetics and genomics research, focusing on finding the right targets and helping us better understand not only human disease biology but also the behavior of and response to our drugs in clinical trials! Within the GRC, the Department of Bioinformatics is responsible for data analysis and provides analytical insight for both internal and external data. This involves the identification and characterization of underlying genetic, epigenetic, or genomic factors that are associated with disease diagnosis, prognosis and response (efficacy and safety) to drug treatment, identification of new targets, and interpretation of the impact of genetic and genomic evidence from population-based studies. To support our data ecosystem and data storage strategies, we have an outstanding opportunity for a Sr. Scientist I in Lake County, Illinois.

 

Responsibilities

 

·       Work closely with GRC stakeholders to understand data requirements and design efficient and scalable database schemas to support data storage and analysis.

·       Develop and implement RDMS, data lake, and lakehouse architectures to store and manage structured and unstructured data, ensuring seamless integration with downstream analytics applications.

·       Partner with research-serving IT partners to ensure proper configuration and operational stability of critical database environments, including performance monitoring, capacity planning, and troubleshooting.

·       Provide guidance and recommendations on appropriate database technologies and architectures to support GRC's data strategy, ensuring alignment with business objectives, and future growth and development.

·       Collaborate with data analysts and scientists to develop and maintain efficient and optimized queries, and provide guidance on query performance tuning and optimization techniques to ensure efficient data retrieval and analysis.

·       Generate and maintain comprehensive documentation, including database schemas, data models, and architectural designs, to ensure clear understanding and easy accessibility of the GRC's data ecosystem for future reference and knowledge sharing.

 

 


Qualifications:

Bachelor’s Degree or equivalent education and typically 10 years of experience, Master’s Degree or equivalent education and typically 8 years of experience, PhD and no experience necessary.

Proficiency in traditional RDMS (Relational Database Management System) technologies such as MySQL, Oracle, or SQL Server, including schema design, normalization, and optimization. 

Strong understanding of data warehousing architecture, with experience in implementing and maintaining data lakes using tools like Snowflake, AWS Redshift, or Google BigQuery.

 Expertise in schema development and data modeling, including designing and implementing efficient and scalable database schemas to support the GRC’s data strategy. 

 In-depth knowledge of query optimization techniques, including index optimization, query tuning, and performance monitoring to ensure efficient data loading, retrieval, and analysis. 

Ability to work closely with IT support partners to ensure proper configuration and operational stability of critical database environments, including performance monitoring, capacity planning, and troubleshooting.

Familiarity with ETL (Extract, Transform, Load) processes and tools, enabling seamless data integration between different systems and databases.

Proficient in writing complex SQL queries and stored procedures for data retrieval, manipulation, and analysis, ensuring data accuracy and integrity.

Strong problem-solving skills and ability to analyze and resolve database-related issues, including data inconsistencies, performance bottlenecks, and system failures.

 

AbbVie is committed to operating with integrity, driving innovation, transforming lives, serving our community, and embracing diversity and inclusion. It is AbbVie’s policy to employ qualified persons of the greatest ability without discrimination against any employee or applicant for employment because of race, color, religion, national origin, age, sex (including pregnancy), physical or mental disability, medical condition, genetic information, gender identity or expression, sexual orientation, marital status, status as a protected veteran, or any other legally protected group status.


Company

AbbVie’s mission is to discover and deliver innovative medicines that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people’s lives across several key therapeutic areas: immunology, oncology, neuroscience, eye care, virology, women’s health and gastroenterology, in addition to products and services across its Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on Twitter, Facebook, Instagram, and YouTube.

Stock Symbol: ABBV

Stock Exchange: NYSE

Company info
Website
Phone
1-800-255-5162
Location
1 North Waukegan Road
North Chicago
Illinois
60064
US

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert