Sr Analyst, Commercial Business Intelligence

Lake Forest, IL, United States
Nov 15, 2020
Required Education
Bachelors Degree
Position Type
Full time
Working at Horizon is more than a job - it's personal. For us, success is measured by the numbers that matter most - the number of lives we touch, the number we change and those we work tirelessly to help save. We're a team of agile, out-of-the-box thinkers who are inspired to do more because we know we're a part of something bigger. We strive to build meaningful careers at a company whose values we share because when we live up to our potential, we help others live up to theirs.

Position Summary:

The Senior Analyst, Commercial Business Intelligence assists the build, QC, roll-out, and support of brand-specific Business Intelligence reporting and dashboards, collaborating with Business Intelligence team and cross-functional partners.

  • Develops new dashboards/reports, as well as maintain/enhance existing ones, utilizing the Horizon corporate BI tool, MS PowerBI
  • Assist with the design, development, and maintenance of underlying data model, utilizing MS SQL Server Analysis Services
  • Conducts robust QC on new reports developed by the Business Intelligence team
  • Supports the design and requirements gathering of new work
  • Supports the rollout and support of new users on the platform
  • Liaisons with data team for proper data sourcing and transformation for BI data model, with a solid understanding of data sources and their ultimate application and relation to the reports
  • Supports Business Intelligence manager and director on project planning and assisting junior staff

Qualifications and Skills Required:
  • BA/BS required
  • 4+ years in the pharmaceutical industry or in business analytics consulting, including experience in Business Intelligence Analytics, Market Research and/or Sales Analytics; Software Development and Database Architecture preferred
  • Demonstrated high proficiency with Business Intelligence tools (PowerBI, Tableau, etc), with PowerBI experience preferred but not required
  • Demonstrated general proficiency with MS Analysis Services and Tabular Models builds, leveraging DAX for calculated measures/columns
  • Demonstrated general proficiency in data management and enterprise data platforms (such as Microsoft SQL Server), statistical modeling packages (such as Python, SAS, and/or, R) and office productivity software (such as Microsoft Office)
  • Demonstrated success developing and presenting solutions to complex business situations, supported by sound and thorough analytics solutions
  • Strong quality control and testing techniques and attention to detail
  • High degree of independence and exceptional work ethic
  • Excellent written and verbal communication skills
  • Professional, proactive demeanor
  • Strong interpersonal skills

Horizon Core Values & Competencies:

  • Manages Ambiguity
  • Strategic Mindset
  • Demonstrates Self-awareness
  • Cultivates Innovation
  • Develops Talent

  • Drives Results
  • Ensures Accountability
  • Decision Quality

  • Courage
  • Collaboration
  • Instills Trust

Horizon Therapeutics plc does not discriminate on the basis of race, color, religion, gender, sexual orientation, national origin, age, disability, veteran status, or any other characteristic protected by law. It is our intention that all qualified applications are given equal opportunity and that selection decisions be based on job-related factors. Any individual, who, because of a disability, needs accommodation or assistance in completing this application or at any time during the application process, should contact the Human Resources Department.