Sr Database Specialist, Commercial Analytics

Location
Lake Forest, IL, United States
Posted
Sep 23, 2020
Ref
R0001596
Hotbed
BioMidwest
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 Database Specialist manages and develops data processes to cleanse, transform, load, and/or export data to/from the data warehouse, to support commercial teams.

Responsibilities:

  • Utilizes the Microsoft SQL Server database software to manage and house data from multiple sources
  • Assists in the designing of data structures that can support large amounts of data, are easy to use, and processes efficiently; implements creation of data structures
  • Designs, creates, and QCs ETL (Extract Transform Load) processes via SQL Server's SSIS functionality
  • Incorporates robust data validation, cleansing, and management methodologies into SSIS packages as well as day to day data work
  • Builds processes with a strong focus on automation and repeatable processes
  • Documents processes and associated business logic
  • Executes simple and complex queries to pull data to support and/or answer adhoc questions
  • Works with manager(s) to project plan, establish timelines, and map out associated tasks


Qualifications and Skills Required:

  • BA/BS required
  • Experience in the pharmaceutical industry or technology consulting, including experience in Database Architecture and/or Software Development preferred
  • Proficient in all components of SQL Server:
    • Transact-SQL
    • SSIS
    • Tables, keys, and indices
    • Stored Procedures, Functions, and Views
  • Proficient in Microsoft Office suite, particularly Excel
  • Strong documentation and quality assurance skills
  • Exceptional work ethic
  • Excellent written and verbal communication skills
  • Professional, proactive demeanor
  • Strong interpersonal skills

Horizon Core Values & Competencies:

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


Accountability
  • Drives Results
  • Ensures Accountability
  • Decision Quality


Transparency
  • 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.