Senior Analyst, Business Systems

BioSpace; North Chicago (IL); On-site; USD 100,000 - 140,000; Full time

Benefits offered by this job

Medical/dental/vision insurance

401(k)

Paid time off (vacation, holidays, orS

Job summary

AbbVie seeks a qualified BI engineer to design end-to-end Power BI dashboards and semantic models translating complex operational data into actionable insights for leaders and teams.

You will gather requirements with stakeholders, define success criteria, and implement KPIs. You will build data models from multiple sources, write optimized SQL, validate results, and support deployment with user training.

Qualifications

• Bachelor's degree plus 5 years technical experience or Master's degree plus 4 years experience
• Experience in DAX and Power Query for data transformation
• Experience with SQL—complex queries with joins, CTEs, aggregations
• Ability to translate business requirements into technical specifications and data models
• Experience documenting technical designs, KPI definitions, and data architecture
• Strong attention to detail and data validation
• Ability to work with stakeholders, IT, and end users to gather requirements

Responsibilities

• Design and develop end-to-end Power BI dashboards and semantic models translating data into insights
• Gather requirements and document scope, success criteria, and edge cases
• Develop KPIs and performance metrics for visibility and decision-making
• Build semantic data models integrating data from Redshift and enterprise systems
• Write and optimize SQL (Redshift-compatible) for ETL
• Create and document design specs and source-of-truth for dashboards
• Coordinate validation and UAT with stakeholders
• Support dashboard deployment and user training
• Explore AI/automation for continuous improvement opportunities

Skills

DAX

Power Query

SQL

Data modeling

Requirements gathering

Stakeholder collaboration

Power BI

Education

Bachelor's degree + 5 years experience

Master's degree + 4 years experience

Tools

Power BI

Redshift

ERP systems (Maximo SAP Oracle)

Job description

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