Senior Scientist, I Genomics Database Developer

$78,500 - $141,000/Yr

AbbVie - North Chicago, IL

Full-time - Senior

North Chicago, IL

Chemical Manufacturing

About the position

The Senior Scientist I Genomics Database Developer at AbbVie plays a crucial role in supporting the Genomics Research Center (GRC) by designing and implementing efficient database architectures that facilitate data storage and analysis. This position involves collaboration with various stakeholders to understand data requirements, develop scalable database schemas, and ensure the operational stability of critical database environments. The role is integral to advancing genetics and genomics research, ultimately contributing to the understanding of human disease biology and drug response.

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.

Requirements

• Bachelors Degree or equivalent education and typically 10 years of experience, Masters 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 GRCs 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.

Benefits

• Paid time off (vacation, holidays, sick)
• Medical/dental/vision insurance
• 401(k) to eligible employees
• Participation in short-term incentive programs