Business Systems Consultant

BioSpace; North Chicago (IL); Hybrid; USD 158,000 - 184,000; Full time

Job summary

AbbVie in North Chicago, IL is seeking a Business Systems Consultant to lead data-driven transformation and manage complex data architectures. Hybrid work arrangement: 3 days in office, 2 remote.

The role requires a Bachelor's degree in CS/MIS/analytics or related field and 5 years in data/BI roles, with strong SQL, Python, and ETL/ELT experience. Collaboration across teams and external partners is essential for success.

Qualifications

• Bachelor's degree in CS/MIS/analytics or related; 5 years in data/BI roles.
• Experience architecting data infrastructure and scalable solutions.
• SQL and Python proficiency for data manipulation and modeling.
• ETL/ELT pipelines experience (Informatica) and data visualization.

Responsibilities

• Manage project scopes, budgets, and schedules for successful delivery.
• Oversee milestones, evaluate technology solutions, and coordinate with partners.
• Lead data-driven transformations and design tailored commercial solutions.
• Elicit requirements, implement process improvements, and document specs.
• Optimize data processes and ensure compliance with corporate standards.

Skills

Data analysis

Data engineering

SQL

Python

ETL pipelines

Informatica

Snowflake

Agile

Requirements gathering

Data modeling

Education

Bachelor's degree in computer science, MIS, analytics or related field

Tools

Informatica

Snowflake

Job description

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.

Job Description

Business Systems Consultant, AbbVie Inc., North Chicago, IL: Hybrid 3 fixed days a week/ 2 days.

Key Responsibilities

• Manage project scopes, budgets, & schedules, ensuring successful delivery within organizational constraints.
• Oversee milestone achievement, evaluate & recommend technology solutions, resolve conflicts, & foster collaborative relationships across teams & with external partners for optimal project outcomes.
• Lead data-driven transformation initiatives, analyze current & future business architectures, & design tailored solutions to meet evolving commercial business needs.
• Elicit & translate complex requirements, implement process improvements, maintain technical documentation, & present actionable insights to stakeholders.
• Optimize commercial data processes & ensure compliance with corporate standards supports continuous innovation & system performance across the business.

Qualifications

Education & Experience

Must have a Bachelor’s degree in computer science, applied & computational mathematics, data science, management information systems, electronics &/or communication engineering, analytics or related field or foreign education equivalent & 5 years of work experience in a combination of data analyst, data engineering & business systems analyst roles.

Of Experience Required, Must Have 5 Years

• (i) analyzing the complex data infrastructure, data granularities, data visualization, & iterative prototyping to define architecture & develop secure high performing & scalable solutions;
• (ii) analyzing or engineering data with Database using Structured Query Language (SQL); &
• (iii) designing & developing ETL/ELT pipeline using tools including Informatica.

Of Experience Required, Must Have 3 Years

• gathering business requirements & preparing & presenting orally & in writing to supervisor, non-technology stakeholders, & peers in a matrixed organization;
• working in Agile methodology;
• building data solutions using Snowflake;
• storing, processing, or analyzing data on cloud-based solutions;
• of experience leading Project Initiatives & ownership of project delivery; &
• performing Data Modeling & reviewing the model including designing enterprise level robust data structures, validating data integrity, & ensuring models aligns with best practices.

Of the experience required, must have 2 years analyzing or transforming data with Python.

Experience may be gained concurrently. Will accept any suitable combination or education, training or experience.

Additional Information

Salary Range: $157,974.23 - $183,500.00 per year.

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 and long-term incentive programs.

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.

AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives and serving our community. Equal Opportunity Employer/Veterans/Disabled.