Senior Analyst, Business Systems
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.
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
