Jobs
>
Chicago

    Senior Scientist, I Genomics Database Developer - North Chicago, United States - AbbVie

    AbbVie
    AbbVie North Chicago, United States

    5 days ago

    Default job background
    Description

    Job Description

    Job DescriptionCompany Description

    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 Follow @abbvie on Twitter, Facebook, Instagram, YouTube and LinkedIn.

    Job Description

    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

    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.

    Additional Information

    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.

  • Chicago Children's Museum

    Development Database and Operations Manager

    1 week ago

    Chicago Children's Museum Chicago, United States

    : · **Title**: Development Database and Operations Manager · **Department**: Development · **Reports to**: Senior Director of Development · **About Chicago Children's Museum**: Chicago Children's Museum (CCM) is committed to improving children's lives by creating a community wher ...

  • Patterned Learning AI

    Database Developer

    1 week ago

    Patterned Learning AI Chicago, United States

    Job Description · Database Developer- Remote Job, 1+ Year Experience · Annual Income: $60K - $65K, Onsite · A valid work permit is necessary in the US/Canada · About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It offers ...

  • Medical Home Network

    Database Developer

    2 weeks ago

    Medical Home Network Chicago, United States

    Are you ready to join a passionate community of people who are changing how health care is delivered? A place where you will find a career you love while truly making a difference building healthier communities. If this sounds like you, we would love to have you apply as Database ...

  • Medical Home Network

    Database Developer

    6 days ago

    Medical Home Network Chicago, United States

    Are you ready to join a passionate community of people who are changing how health care is delivered? A place where you will find a career you love while truly making a difference building healthier communities. If this sounds like you, we would love to have you apply as Database ...

  • Intelligence and National Security Alliance

    Database Developer

    2 weeks ago

    Intelligence and National Security Alliance Chicago, United States

    Are you ready to join a passionate community of people who are changing how health care is delivered? A place where you will find a career you love while truly making a difference building healthier communities. If this sounds like you, we would love to have you apply as · Datab ...

  • Primera Engineers

    Database Developer

    4 days ago

    Primera Engineers Chicago, United States

    The DWMPMO provides program management, engineering, and IT implementation services for the Chicago Department of Water Management (DWM) and other City Departments as needed. As part of the Program Team supporting the City's IT initiatives, DWMPMO leads IT implementations in a su ...

  • Ardmore Roderick

    Database Developer

    4 days ago

    Ardmore Roderick Chicago, United States

    Ardmore Roderick is a full-service civil engineering firm providing infrastructure design, construction services and program management to a variety of agencies.?Headquartered in Chicago, we have offices in Champaign, IL, Orlando, FL, and Philadelphia, PA. Ardmore Roderick was re ...

  • Remotely

    Database Developer

    4 days ago

    Remotely Chicago, United States

    This is a remote position. · Database Developer - US Residents Only, 1 year experience, · Hybrid (3 days in office) · Team Remotely Inc. is a staffing and recruitment agency that offers a comprehensive solution for talent acquisition, including sourcing, vetting, pay rolling, ...

  • Ardmore Roderick

    Database Developer

    5 days ago

    Ardmore Roderick Chicago, United States

    Ardmore Roderick is a full-service civil engineering firm providing infrastructure design, construction services and program management to a variety of agencies. Headquartered in Chicago, we have offices in Champaign, IL, Orlando, FL, and Philadelphia, PA. Ardmore Roderick was re ...

  • Ardmore Roderick

    Database Developer

    3 weeks ago

    Ardmore Roderick Chicago, United States Full time

    Ardmore Roderick is a full-service civil engineering firm providing infrastructure design, construction services and program management to a variety of agencies. Headquartered in Chicago, we have offices in Champaign, IL, Orlando, FL, and Philadelphia, PA. Ardmore Roderick was re ...

  • Clarity Partners

    GIS Database Developer

    6 days ago

    Clarity Partners Chicago, United States

    Voted one of Chicago's Best Places to Work by the Chicago Tribune for the seventh year in a row, Clarity Partners is hiring · Clarity Partners is seeking a GIS Database Developer, local to Chicago, IL. The primary responsibility of the Developer position will include the effectiv ...

  • Collabera

    SQL Database Developer

    14 hours ago

    Collabera Chicago, United States

    Position Details: · Title: MS SQL Database Developer · Location: Jacksonville, FL / Richmond, VA/ Chicago, IL- Hybrid · Duration: 18 Months · Compensation: 70.23/hour · Interview Process: 2 Rounds · Day-to-Day: · Develop and maintain TSQL code, covering stored procedures, views, ...

  • Cogent Data Solutions LLC

    Junior Database Developer

    4 days ago

    Cogent Data Solutions LLC Chicago, United States Full time, contract

    Job Description We are seeking a talented Oracle Database Developer who has experience in performing the following activities. Strong hands-on experience in in Oracle SQL and PL/SQL development in 11g or 12c environment using SQL Developer TOAD and other tools. Analyze user requi ...

  • ReaderLink

    MS SQL Database Administrator/Developer

    1 week ago

    ReaderLink Chicago, United States

    We are North America's largest book distributor with over 70,000 customer store locations. We move over 325,000,000 books per year and work with over 700 retailers and 500 publishers. If you want to help deliver a book into the hands of readers across America, let's talk. We are ...

  • AbbVie

    Senior Scientist, I Genomics Database Developer

    3 weeks ago

    AbbVie North Chicago, United States Full time

    · Company Description · 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 ar ...

  • eTeam

    Sr. Database Developer

    3 days ago

    eTeam Des Plaines, United States

    Must have Hands-on in Bold) · Database Relational DB ( MySQL strong preference, Others considered) · Stored Procedures · Relational Design · Performance · Troubleshooting · High availability / Offloading · ETL tools (tcVision, GoldenGate..) · Applications and languages ...

  • Intelligence and National Security Alliance

    Sr. Database Developer

    4 days ago

    Intelligence and National Security Alliance Des Plaines, United States

    Must have Hands-on in Bold) · Database · Relational DB ( · MySQL strong preference , Others considered) · Stored Procedures · Relational Design · Performance · Troubleshooting · High availability / Offloading · ETL tools (tcVision, GoldenGate..) · Applications and languages · ...

  • unizon technology

    Ms SQL Server Dba

    14 hours ago

    unizon technology Chicago, United States

    **Job Overview**: · **Responsibilities**: · **Duties & Responsibilities**: · - Database Management: Oversee the creation, maintenance, upgrade, patching, tuning, backup, and recovery of various MS SQL Databases. · - Capacity Planning: Plan and manage the capacity of database mana ...

  • Na Oiwi Kane

    Database Administrator

    3 days ago

    Na Oiwi Kane Chicago, United States

    **JOB DESCRIPTION** · **Position Title**:Database Administrator · **Location**:80% Remote, 20% Chicago, IL · **Introduction**: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board ( ...

  • Vanator

    SQL Developer

    4 days ago

    Vanator Chicago, United States

    Advanced SQL programming skills. · - Experience with Teradata or other database systems · - Experience in database design/development, database administration, and business intelligence · - Experience in data analysis and analytical reporting · - Proficiency with advanced Excel f ...