Senior Analyst, Business Systems

Senior Analyst role supporting business systems at AbbVie in North Chicago. Designs and develops Power BI dashboards and semantic data models, translating operational data into actionable insights. Conducts requirements gathering, optimizes SQL queries, and enables end-user adoption of analytics solutions.

Responsibilities

• Design end-to-end Power BI dashboards and semantic models with advanced features and data validation logic
• Gather business requirements and translate them into functional and technical specifications with stakeholders
• Develop KPIs and performance metrics to drive operational visibility and decision-making
• Write and optimize complex SQL queries to extract, transform, and stage data from multiple sources
• Conduct UAT coordination, gather stakeholder feedback, and validate dashboards meet acceptance criteria

Requirements

• Bachelor's degree plus 5 years technical experience, or Master's degree plus 4 years experience
• Proficiency in DAX measures, calculated columns, and Power Query M language
• Strong SQL skills including complex queries, CTEs, aggregations, and filtering
• Ability to translate business requirements into technical specifications and data models
• Experience documenting technical designs, KPI definitions, and data architecture
• Strong data validation and attention to detail skills
• Collaborative skills working with business stakeholders and IT teams