Sr Database Specialist, Commercial Analytics

Compensation

: $91,580.00 - $131,820.00 /year *

Employment Type

: Full-Time

Industry

: Information Technology



Loading some great jobs for you...





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.
Associated topics: data analyst, data analytic, data architect, data integration, data integrity, data management, data warehousing, hbase, mongo database administrator, sql * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...