Sr. Analyst, Business Intelligence

Company: Horizon Therapeutics , Inc. Defunct
Location: Waukegan
Posted on: March 17, 2023

Job Description:

At Horizon Therapeutics, we define success by the number of lives touched, lives changed, and lives saved. Our global biotechnology company is made up of agile, out-of-the-box thinkers with a focus on delivering breakthrough medicines to those living with rare, autoimmune, and severe inflammatory diseases. This is the heart of our global mission. Start a career that enables you to live up to your potential and help others live up to theirs. Join us.

The exceptional support we provide patients and communities equally extends to our employees. We offer industry-leading and award-winning benefits, compensation and rewards programs that positively impact all areas of our employees' personal and professional lives.

Company: Horizon Therapeutics USA, Inc.

Location: 1 Horizon Way, Deerfield, IL 60015

Position Title: Sr. Analyst, Business Intelligence

Hours: Monday - Friday, 8:00 am to 5:00 pm 40 Hours/ Week

Summary of Duties: Analyze business requirements and implement data mart solutions for data mining and reporting. Use T-SQL for querying database using Joins, Stored Procedure, Views. Create Power BI Dashboards, Tiles, Reports and Visualization charts, and KPI's as per the stakeholder's requirement. Manage Content packs, security level in Power BI services. Use DAX for creating calculated columns, and measures for aggregating data from the columns as well as rows. Work closely with QA team and help them come up with test scenarios. Design the data model based on star schema and snowflake schemas, create the tables, and develop the scripts to load the data mart tables. Identify issue and develop a procedure for correcting the problem, which results in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse. Perform Extract, Transform, and loading for processing the data into the Data Warehouse. Present the outcomes to the Senior Team Members and Stakeholders based on the reports. Perform ad-hoc SQL Queries when immediate access to data was required. Develop, maintain & manage all analytical & project-critical reports. Participate in application design and project planning sessions with developers and users. Establish and implement standards and strategies for data management, lifecycle, and quality.

Qualifications: The position requires a Bachelor's degree in Biotechnology, Data Science, or a related quantitative field and two years of experience as a Computer Systems Analyst/Developer, Power BI Developer, or a related occupation.

The position requires experience in the following: Business Intelligence Analytics, Market Research, and Sales Analytics in the Pharmaceutical Industry or in Business Analytics Consulting; Business Intelligence tools, including PowerBI and Tableau; MS Analysis Services and Tabular Models builds, leveraging DAX for calculated measures or columns; Data management and enterprise data platforms, including Microsoft SQL Server; Statistical modeling packages including Python, SAS, and R.

Our Values

• Transparency: We value collaboration. Trusting teach other and tackling tough challenges can make a powerful difference.
• Accountability: We do what's right for our patient communities through quality decisions and owning our successes and failures.
• Growth: We fiercely innovate and evolve to better ourselves, our communities and our patients. These three values come to life through our five Leadership Expectations that apply to all Horizon employees
  • Enterprise Mindset: Look beyond one's team, brand or function to see the broader company and external perspective
  • Exhibit Intellectual Curiosity: Seek to understand what you do not know; ask the right questions of the right people and sources
  • Ensure Accountability and Courage: Step up to address difficult issues and hold self and others accountable to commitments
  • Embrace Diverse Perspectives: Welcome others with a respectful attitude; integrate diverse perspectives into ways of working
  • Develop Talent: Provide feedback, coaching and mentorship to help others be more effective in their role
    
    At Horizon, we know that disease does not discriminate. We embrace the bold ideas of one another, foster a sense of belonging, and value inclusion. We attract and develop diverse talent because we believe that when people from different backgrounds and life experiences come together, we make lives better.
    
    Horizon intends that all qualified applications are given equal opportunity, and that selection decisions be based on job-related factors. We do not discriminate based on race, color, religion, gender, sexual orientation, national origin, age, disability, veteran status, or any other characteristics protected by law. by Jobble

Keywords: Horizon Therapeutics , Inc. Defunct, Waukegan , Sr. Analyst, Business Intelligence, Professions , Waukegan, Illinois