AbbVie - North Chicago, IL
posted about 2 months ago
As a Lead Data and Analytics Engineer at AbbVie, you will play a pivotal role in the digital transformation of a leading biopharma company. This position is part of the Business Technology Solutions (BTS) team, where you will contribute to creating innovative solutions that positively impact patients and their communities. Your primary focus will be on the database administration function, which encompasses a wide range of responsibilities including database architecture, installation, and technical support for data products. You will be responsible for designing, securing, and maintaining the data structures that store critical data for corporate systems such as GDMS, GQMS, and Aegis. Additionally, you will oversee the backup and recovery processes for corporate data, ensuring data integrity and availability. In this role, you will also provide technical support for data extraction, transformation, and load (ETL) tools, which are essential for manipulating data from various database technologies. Your responsibilities will include performing database administration activities such as modifications, enhancements, expansions, and capacity planning. You will work closely with Systems Analysts and Senior Systems Analysts to provide technical support and assistance in the design and tuning of computer applications. Your expertise will be crucial in maintaining and supporting the database software, ensuring optimal performance and reliability. As part of the Data & Analytics team supporting the Procurement department, you will lead data and analytics initiatives aimed at driving digital transformation within Procurement. You will design and maintain data pipelines that ingest, transform, and prepare data from source systems like SAP, Sievo, and Provalido into business-aggregated data products. Your role will involve guiding less experienced DBAs, ensuring compliance with corporate policies, and enhancing logical database designs. You will also conduct performance monitoring, capacity planning, and lead the development of database standards and procedures. Daily interactions with clients and collaboration with other technical support organizations will be key aspects of your role, as you solve complex data integration challenges and design scalable data processing pipelines using distributed technologies.