AbbVie - North Chicago, IL
posted about 2 months ago
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.