Senior Analyst, Business Systems

Posted 2 Days Ago
North Chicago, IL, USA
Hybrid
85K-162K Annually
Senior level
Healthtech • Pharmaceutical
The Role
Designs and maintains Power BI dashboards, semantic models, KPIs, and SQL data pipelines. Gathers requirements, translates business needs into technical specifications, validates data, coordinates UAT, documents architecture, deploys dashboards, troubleshoots connectivity, and trains users. Integrates data from Redshift, ODBC connections, and enterprise systems while identifying AI-enabled process improvements.
Summary Generated by Built In
Company Description

About AbbVie

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 including immunology, oncology and neuroscience - and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on LinkedIn, Facebook, Instagram, X and YouTube.

Job Description

Provides direct support to an assigned area. Applies relevant principles to support projects and ongoing activities. Completes tasks which support a project or functional team.

Responsibilities

  • Design and develop end-to-end Power BI dashboards and semantic models that translate complex operational data into actionable insights for leadership and operations teams; create PBIP projects with advanced features including calculated tables, relationships, DAX measures, and data validation logic.
  • Conduct requirements gathering and translate business needs into functional and technical specifications, working directly with stakeholders to document scope, success criteria, and edge cases; document design decisions and architectural patterns for model maintainability.
  • Develop KPIs and performance metrics that drive operational visibility and decision-making.
  • Build and maintain semantic data models that integrate data from multiple sources (Redshift, ODBC connections, enterprise systems).
  • Write and optimize complex SQL (Redshift-compatible) to extract, transform, and stage data for analytics.
  • Create and document design specifications and requirement documents that serve as source-of-truth for dashboard actionable insights for leadership and operations teams.
  • Conduct requirements gathering and translate business needs into functional and technical specifications, working directly with stakeholders to document scope, success criteria, and edge cases; document design decisions and architectural patterns for model maintainability. 
  • Perform requirement validation and UAT coordination — gather stakeholder feedback on prototypes, incorporate design iterations, and validate that delivered dashboards meet acceptance criteria.
  • Support dashboard deployment and user enablement — publish to production environments, troubleshoot connectivity issues, and provide training and documentation to end users.
  • Leverage AI and emerging technologies to identify and implement continuous improvement opportunities, enhance efficiency and decision-making, and support innovation in alignment with business priorities.

 

Qualifications

  • Bachelors degree plus 5 years technical experience, or Masters degree plus 4 years experience. Will consider 9 years work experience in related technical roles.
  • Experience in DAX (defining measures, calculated columns, filters, context transitions) and Power Query (M language) for data transformation
  • Experience with SQL — ability to write complex queries with joins, CTEs, aggregations, and date-based filtering
  • Demonstrated ability to translate business requirements into technical specifications and design data models that support reporting and analytics
  • Experience documenting technical designs, KPI definitions, and data architecture for both technical and non-technical audiences
  • Strong attention to detail and ability to validate data accuracy and reconcile reporting against source systems
  • Ability to work collaboratively with business stakeholders, IT teams, and end users to gather requirements and communicate trade-offs

 

  Additional Nice-to-have:

  • Knowledge of dimensional modeling (fact and dimension tables, data granularity)
  • Experience building dashboards for operations, supply chain, inventory management, or procurement domains.
  • Experience in enterprise ERP systems (Maximo, SAP, Oracle) and their data structures.

Additional Information

Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law: ​

  • 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.  ​

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 and serving our community.  Equal Opportunity Employer/Veterans/Disabled. 

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

Skills Required

  • Bachelor’s degree plus 5 years of technical experience, or master’s degree plus 4 years of experience; alternatively, 9 years of related technical work experience.
  • Experience with DAX, including measures, calculated columns, filters, and context transitions.
  • Experience with Power Query and M language for data transformation.
  • Ability to write complex SQL queries using joins, CTEs, aggregations, and date-based filtering.
  • Ability to translate business requirements into technical specifications and design reporting and analytics data models.
  • Experience documenting technical designs, KPI definitions, and data architecture for technical and non-technical audiences.
  • Strong attention to detail and ability to validate data accuracy and reconcile reporting against source systems.
  • Ability to collaborate with business stakeholders, IT teams, and end users to gather requirements and communicate trade-offs.
  • Knowledge of dimensional modeling, including fact tables, dimension tables, and data granularity.
  • Experience building dashboards for operations, supply chain, inventory management, or procurement.
  • Experience with enterprise ERP systems such as Maximo, SAP, or Oracle and their data structures.

AbbVie Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about AbbVie and has not been reviewed or approved by AbbVie.

  • Retirement Support — Retirement programs are portrayed as a standout, with a dollar‑for‑dollar 401(k) match up to 6% and an additional annual company contribution based on age and service. Feedback suggests this materially boosts perceived total compensation for many U.S. employees.
  • Parental & Family Support — Paid parental and caregiver leave are emphasized, including up to 12 weeks of fully paid parental leave for all parents and 4 weeks of paid caregiver leave in the U.S. Feedback suggests these policies are a meaningful differentiator for employees balancing family needs.
  • Leave & Time Off Breadth — Time off is described as extensive, with tiered vacation that scales with tenure, 17 company holidays, and two paid volunteer days in the U.S. Feedback suggests the breadth of leave contributes notably to overall benefits satisfaction.

AbbVie Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: North Chicago, IL
56,000 Employees
Year Founded: 2013

What We Do

AbbVie is a global biopharmaceutical company focused on creating medicines and solutions that put impact first — for patients, communities, and our world. We aim to address complex health issues and enhance people's lives through our core therapeutic areas: immunology, oncology, neuroscience, eye care, aesthetics and other areas of unmet need.

Similar Jobs

AbbVie Logo AbbVie

Senior Analyst, Business Systems

Healthtech • Pharmaceutical
Hybrid
North Chicago, IL, USA
56000 Employees
85K-162K Annually

AbbVie Logo AbbVie

Business Systems Analyst

Healthtech • Pharmaceutical
Hybrid
North Chicago, IL, USA
56000 Employees
85K-162K Annually

Klein Tools Logo Klein Tools

Business Systems Analyst

Hardware • Manufacturing
In-Office
Lincolnshire, IL, USA
800 Employees
118K-148K Annually

AbbVie Logo AbbVie

Senior Analyst, Business Systems

Healthtech • Pharmaceutical
Hybrid
North Chicago, IL, USA
56000 Employees
85K-162K Annually

Similar Companies Hiring

Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
OneImaging Thumbnail
Healthtech
Miami, FL
62 Employees
Vitalize Thumbnail
Artificial Intelligence • Healthtech • Software
US
50 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account