AbbVie
Lead Data Engineer
AbbVie, North Chicago, Illinois, us, 60086
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 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 www.abbvie.com. Follow @abbvie on X, Facebook, Instagram, YouTube, LinkedIn and Tik Tok (https://www.tiktok.com/@abbvie) .
Job Description
This role is in the Data & Analytics team supporting the Procurement Analytics team. As a Lead Data Engineer, you will be required to design and implement the data strategy for Procurement Data initiatives. Procurement data products will be used for various analytical and AI use cases.
Responsibilities
Collaborate with cross functional teams in a fast-paced environment to design and implement data products that enable analytical use cases within the Procurement Analytics domain.
Partner closely with technical, functional and business partners to build out data products and analytics.
Design and maintain data pipelines where data from source systems such as SAP, Sievo and Provalido are ingested, transformed and prepared into business aggregated data products.
Solve challenging data integration problems, utilizing optimal ETL patterns, frameworks, query techniques, sourcing from structured and unstructured data source
Expertise in the SAP Source to Pay module and Procurement analytics
Design scalable data processing pipelines and ETL jobs using distributed technologies to handle growing data volumes efficiently.
Considers tradeoffs between analytical requirements with compute/storage consumption of data and anticipates cost that could be influenced by the cadence of data extraction, transformation, and loading into data products.
Collaborate with a global team of engineers, product managers, and end users to understand data needs, perform data profiling, data cleansing, data transformation tasks and visualize key data insights that support analytic use cases within the Procurement domain.
Ability to gain buy-in from stakeholders on design options that consider technical feasibility and maximizes business value.
The position also requires creative problem-solving skills under pressure and a proven track record in project delivery involving business, functional and technical teams.
compliance, data security, and the software development lifecycle.
Qualifications
A minimum of a Bachelor's Degree required. Master's Degree or PhD preferred.
A minimum of 7 years experience required. 6 years with a Master's degree, or 2 years with a PhD. Experience in the pharmaceutical industry preferred.
Possess thorough theoretical and practical understanding of own discipline.
Proven implementation of creative technology solutions that advanced the business.
Excellent written and oral English communication skills.
Qualifications: Proficient in SQL, Python, ETL tools ( Informatica), data modeling, and Dataiku.
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 PowerBI, PowerQuery, Power Automate, QlikView, Qliksense
Experienced in SDLC processes and Agile delivery, using Jira to manage product delivery in iterative sprints.
Additional Information
Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law:
This role follows a hybrid schedule requiring 3 days onsite.
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.
This job is eligible to participate in our long-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 an equal opportunity employer and 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.
US & Puerto Rico only - to learn more, visit https://www.abbvie.com/join-us/equal-employment-opportunity-employer.html
US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:
https://www.abbvie.com/join-us/reasonable-accommodations.html
Salary: $103,500 - $197,000
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 www.abbvie.com. Follow @abbvie on X, Facebook, Instagram, YouTube, LinkedIn and Tik Tok (https://www.tiktok.com/@abbvie) .
Job Description
This role is in the Data & Analytics team supporting the Procurement Analytics team. As a Lead Data Engineer, you will be required to design and implement the data strategy for Procurement Data initiatives. Procurement data products will be used for various analytical and AI use cases.
Responsibilities
Collaborate with cross functional teams in a fast-paced environment to design and implement data products that enable analytical use cases within the Procurement Analytics domain.
Partner closely with technical, functional and business partners to build out data products and analytics.
Design and maintain data pipelines where data from source systems such as SAP, Sievo and Provalido are ingested, transformed and prepared into business aggregated data products.
Solve challenging data integration problems, utilizing optimal ETL patterns, frameworks, query techniques, sourcing from structured and unstructured data source
Expertise in the SAP Source to Pay module and Procurement analytics
Design scalable data processing pipelines and ETL jobs using distributed technologies to handle growing data volumes efficiently.
Considers tradeoffs between analytical requirements with compute/storage consumption of data and anticipates cost that could be influenced by the cadence of data extraction, transformation, and loading into data products.
Collaborate with a global team of engineers, product managers, and end users to understand data needs, perform data profiling, data cleansing, data transformation tasks and visualize key data insights that support analytic use cases within the Procurement domain.
Ability to gain buy-in from stakeholders on design options that consider technical feasibility and maximizes business value.
The position also requires creative problem-solving skills under pressure and a proven track record in project delivery involving business, functional and technical teams.
compliance, data security, and the software development lifecycle.
Qualifications
A minimum of a Bachelor's Degree required. Master's Degree or PhD preferred.
A minimum of 7 years experience required. 6 years with a Master's degree, or 2 years with a PhD. Experience in the pharmaceutical industry preferred.
Possess thorough theoretical and practical understanding of own discipline.
Proven implementation of creative technology solutions that advanced the business.
Excellent written and oral English communication skills.
Qualifications: Proficient in SQL, Python, ETL tools ( Informatica), data modeling, and Dataiku.
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 PowerBI, PowerQuery, Power Automate, QlikView, Qliksense
Experienced in SDLC processes and Agile delivery, using Jira to manage product delivery in iterative sprints.
Additional Information
Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law:
This role follows a hybrid schedule requiring 3 days onsite.
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.
This job is eligible to participate in our long-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 an equal opportunity employer and 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.
US & Puerto Rico only - to learn more, visit https://www.abbvie.com/join-us/equal-employment-opportunity-employer.html
US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:
https://www.abbvie.com/join-us/reasonable-accommodations.html
Salary: $103,500 - $197,000