Senior BI Systems Analyst – Power BI & Data Modeling

Quest Oracle Community; Chicago (IL); Hybrid; USD 95,000 - 130,000; Full time

Benefits offered by this job

Medical/dental/vision insurance

401(k)

Job summary

AbbVie in Chicago seeks a Senior BI Analyst to design and deliver advanced Power BI dashboards and semantic data models. You will translate business needs into technical specifications, build KPIs, and integrate data from Redshift, ODBC, and ERP systems.

Collaboration with stakeholders and IT is essential for reliable analytics and user enablement. The role emphasizes data accuracy, scalability, and opportunities to apply AI for continuous improvement in operations.

Qualifications

• Bachelor's degree plus 5 years of technical experience or Master's plus 4 years; up to 9 years in related roles.
• Strong experience with DAX for measures and calculations and Power Query for transformations.
• Proficient in SQL with complex queries, joins, CTEs, and date filtering.
• Ability to translate business needs into technical specs and scalable data models.

Responsibilities

• Design and develop end-to-end Power BI dashboards and semantic models for leadership and operations.
• Gather requirements with stakeholders and document scope, success criteria, and edge cases.
• Develop KPIs and performance metrics to improve operational visibility and decision-making.
• Build semantic data models integrating Redshift, ODBC, and ERP data sources.
• Write and optimize Redshift-compatible SQL for ETL and analytics workflows.
• Create design specifications and ensure dashboards are source-of-truth across teams.
• Coordinate requirements validation and UAT with stakeholders and iterate on prototypes.
• Support dashboard deployment, connectivity troubleshooting, and end-user training.
• Leverage AI and emerging tech to identify continuous improvement opportunities.

Skills

Power BI

DAX

SQL

Data Modeling

Stakeholder Collaboration

ETL / Data Integration

Power Query

Education

Bachelor's degree in a relevant field

Master's degree preferred

Tools

Redshift

ODBC connections

Enterprise systems (ERP) data structures

Job description

AbbVie in Chicago seeks a Senior BI Analyst to design and deliver advanced Power BI dashboards and semantic data models. You will translate business needs into technical specifications, build KPIs, and integrate data from Redshift, ODBC, and ERP systems.

Collaboration with stakeholders and IT is essential for reliable analytics and user enablement. The role emphasizes data accuracy, scalability, and opportunities to apply AI for continuous improvement in operations.