Senior Scientist, I Genomics Database Developer

AbbVie's mission is to discover and deliver innovative medicines and solutions 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, and eye care – and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on Twitter, Facebook, Instagram, YouTube and LinkedIn.

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.

Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law: ​

• The compensation range described below is the range of possible base pay compensation that the Company believes in good faith it will pay for this role at the time of this posting based on the job grade for this position. Individual compensation paid within this range will depend on many factors including geographic location, and we may ultimately pay more or less than the posted range. This range may be modified in the future.​
• We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick), medical/dental/vision insurance and 401(k) to eligible employees.​
• This job is eligible to participate in our short-term incentive programs. ​

Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, incentive, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company's sole and absolute discretion unless and until paid and may be modified at the Company’s sole and absolute discretion, consistent with applicable law. ​

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.