Lead Data and Analytics Engineer

AbbVie - North Chicago, IL

Full-time - Mid Level

North Chicago, IL

Chemical Manufacturing

About the position

As a Lead Data and Analytics Engineer at AbbVie, you will be an integral part of the Business Technology Solutions (BTS) team, contributing to the digital transformation of a leading biopharma company. Your role will focus on creating innovative data and analytic solutions that have a meaningful impact on patients and their communities. You will be responsible for overseeing the database administration function, which includes providing technical expertise in database management systems, database architecture, installation, and support of data products. This position requires a strong understanding of data structures and the ability to design, secure, and maintain these structures for corporate computer systems such as GDMS, GQMS, and Aegis. In this role, you will also be tasked with the backup and recovery of corporate data, as well as providing technical support for data extraction, transformation, and load (ETL) tools. You will perform various database administration activities, including modifications, enhancements, expansions, and capacity planning. Additionally, you will provide guidance to less experienced database administrators and ensure compliance with corporate and divisional policies and procedures. Your responsibilities will also include reviewing and enhancing logical database designs, conducting performance monitoring, and diagnosing database-related issues. As part of the Data & Analytics team supporting the Procurement department, you will design and maintain data pipelines that ingest, transform, and prepare data from source systems such as SAP, Sievo, and Provalido into business-aggregated data products. You will lead the development of database standards and procedures, evaluate new database software and tools, and solve complex data integration challenges using optimal ETL patterns and frameworks. Your daily interactions will involve collaborating with clients on divisional and enterprise-wide projects, as well as working closely with other technical support organizations.

Responsibilities

• Oversee Procurement data and analytics initiatives.
• Design and maintain data pipelines for data ingestion and transformation.
• Provide guidance in database administration activities to less experienced DBAs.
• Ensure compliance with applicable Corporate and Divisional Policies and procedures.
• Review, validate, and enhance logical database designs.
• Define and implement physical databases.
• Perform database administration activities such as modifications, enhancements, and expansions.
• Conduct production database performance monitoring and capacity planning.
• Install, test, and upgrade database releases and associated products.
• Diagnose database-related issues, including outages and application performance.
• Lead the development of database standards and procedures.
• Evaluate and recommend new database software, utilities, and tools.
• Interact daily with clients on divisional and enterprise-wide projects.
• Solve challenging data integration problems using optimal ETL patterns and frameworks.
• Design scalable data processing pipelines and ETL jobs using distributed technologies.

Requirements

• Bachelor's Degree with 6 years' experience; Master's Degree with 5 years' experience; PhD with 0 years' experience.
• Experience as a DBA in the design, testing, implementation, and administration of management systems database with proficiency in SQL, Python, PowerBI, QlikView, Qliksense, and Dataiku.
• Technical training including Database Administration, Performance and Tuning, and Backup and Recovery.
• Experience with file structures, design, retrieval, and access methods using ETL tools such as Informatica.
• Excellent analytical, communication, and consultative skills, with sound judgment and the ability to work effectively with clients and IT management.

Nice-to-haves

• Experience in the Life sciences domain.
• Expertise in creating Data Products on modern cloud-based data warehouse solutions like AWS Redshift, including data modeling, schema design, and performance optimization.
• Proficient in Microsoft Power Platform solutions such as PowerQuery, Power Automate, and Dataiku.
• Experienced in SDLC processes and Agile delivery, using Jira to manage product delivery in iterative sprints.
• Expertise in the SAP Source to Pay module and Procurement analytics.