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 Manager 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
10+ 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
Proficient with Python
Proficient in all components of Azure
Azure SQL
Dev Ops
Databricks, including Spark SQL
Data Factory
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.