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.

Position Summary:

The Data Engineer II 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, Databricks, Azure Data Factory and Python
• Incorporates robust data validation, cleansing, and management methodologies
• 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
• 5+ years of experience in a similar role
• 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
• Tables, keys, and indices
• Stored Procedures, Functions, and Views
• Experience with Python
• Experience with cloud platforms (Azure, AWS, GCP)
• Strong documentation and quality assurance skills
• Proficient in Microsoft Office.
• Professional, proactive demeanor.
• Strong interpersonal skills.
• Excellent written and verbal communication skills.

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.

Horizon Therapeutics