Senior Data Engineer

Senior Data Engineer We are the first publicly-traded biotech or pharmaceutical company to take the form of a public benefit corporation. Our public benefit purpose is to provide a brighter future for patients through the development of novel pharmaceutical therapies; and technologies that expand the availability of transplantable organs. United Therapeutics (Nasdaq: UTHR) seeks to travel down the corridors of indifference to develop treatments for rare, deadly diseases. We were founded in 1996 by a family seeking a cure for their daughter's pulmonary arterial hypertension (PAH). Today, we have six FDA-approved therapies that treat PAH, pulmonary hypertension associated with interstitial lung disease (PH-ILD) and neuroblastoma, a rare pediatric cancer. Our near-term pipeline seeks to develop additional therapies for PAH and pulmonary fibrosis (PF). The cure for end-stage life-threatening diseases like PAH, PH-ILD, PF, and many others is an organ transplant, but only a small percentage of donated organs are available to address the vast need. For this reason, we are working to create manufactured organs to address the shortage of kidneys, hearts, lungs, and livers available for transplant. We believe an unlimited supply of tolerable, transplantable organs will eliminate the transplant waiting list and cure end-stage organ diseases for which transplant is not currently an option.

Our team within IT has an amazing position – we consult with the rest of UT to provide data and analytics solutions to any stakeholders who need it. On any given day we may work with sales and marketing, scientific teams, compliance, medical teams, and more. We work hard to solve organizational initiatives and accelerate outcomes. This role is integral to leading technical solutions. If you're great at solving problems and maintaining relationships, keep reading. The ideal candidate can maintain multiple high-profile workstreams across various subject matters. This role is a leading technical role that also requires business acumen. We'll work with the stakeholders to determine the need; you'll solve that need.

The Senior Data Engineer will play a crucial role in designing, developing, and maintaining our data and analytics architecture, ensuring efficient data flow and management across the organization. This role requires a deep understanding of data engineering principles, advanced programming skills, and the ability to work collaboratively with cross-functional teams to deliver high-quality data solutions.

Design, build and optimize ETL/ELT pipelines using Databricks and Azure Data Factory to support enterprise data warehousing and analytics

Work with stakeholders to provide access and security controls

Support and maintain daily data processing operations, including monitoring, alerting, and issue resolution

Collaborate with analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions

Provide technical guidance and mentorship to junior data engineers and other team members, including reviewing and validating work delivered by external consultants

Monitor and troubleshoot data systems (e.g., SQL Databases, Databricks) to ensure performance and reliability

Implement best practices for data management; lead initiatives to improve practices, tools, and processes

Participate in code reviews, design discussions, and contribute to technical documentation

Provide consultation and leadership around business intelligence and analytics platforms

Minimum Requirements:

5+ years of experience building and maintaining business-critical EDW and pipelines with a Bachelor's Degree

3+ years of experience with data architecting and engineering in a role with a proven track record of delivering complex data solutions

3+ years of Tier 1 SaaS integration work (e.g. Salesforce) or equivalent

3+ years of experience working with AppDev and/or BI/AI team members

Advanced SQL Skills, including complex query writing, performance tuning/optimization, and stored procedure development

Hands-on, production-level experience with Azure Databricks, including Spark based data processing, notebooks, and Delta Lake

Hands-on, production-level experience with Azure Data Factory, building, orchestrating, and monitoring ETL/ELT pipelines

Hands-on experience with cloud platforms – Azure preferred

Proficiency in programming languages such as Python

Understanding of data warehousing concepts

Highly proficient and excels in working with custom applications and complicated data platforms – beyond off-the-shelf systems

Excellent problem solving and analytical skills with strong communication and interpersonal skills

Ability to manage multiple priorities and projects simultaneously and effectively in, or outside, of a team

Demonstrated experience delivering data processing reliability

Location: This position will be located in the RTP, NC office of United Therapeutics. Currently this job is a hybrid role requiring at least three days per week in the office. In office requirements could increase based on business needs.