Senior Data Engineer

United Therapeutics Corporation; Northern (KY); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical, dental, vision, prescription

401(k) and ESPP

Paid time off & parental leave

Disability benefits

Job summary

United Therapeutics Corporation seeks a Senior Data Engineer in RTP, NC to design, develop, and maintain data architectures that enable scalable analytics across the organization. You will work with cross-functional teams to deliver high-quality data solutions, ensure data quality, and drive reliability in data pipelines.

The role requires strong SQL, Python, Azure Databricks, and Azure Data Factory skills, plus experience with data warehousing concepts and cloud platforms.

Qualifications

• Bachelor’s degree in a related field required.
• 5+ years of experience building and maintaining EDW and pipelines.
• 3+ years of Tier 1 SaaS integration (e.g., Salesforce) or equivalent.
• Hands-on with Azure Databricks (Spark) and Delta Lake.
• Hands-on with Azure Data Factory for ETL/ELT pipelines.

Responsibilities

• Design, build and optimize ETL/ELT pipelines using Databricks and Azure Data Factory to support enterprise data warehousing and analytics.
• Provide access and security controls for stakeholders.
• Support and maintain daily data processing operations with monitoring and incident resolution.
• Collaborate with analysts, data scientists, and stakeholders to understand data requirements and deliver solutions.
• Provide technical guidance and mentorship to junior data engineers and review work by external consultants.
• Monitor and troubleshoot data systems for performance and reliability.
• Lead best-practice initiatives in data management and tooling.

Skills

Python

Advanced SQL

Cloud platforms (Azure)

ETL/ELT design

Data modeling

BI/Analytics collaboration

Communication skills

Education

Bachelor’s degree in a related field

Tools

Azure Databricks

Azure Data Factory

Delta Lake

Job description

Who We Are

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.

Who You Are

Cool company? Check. Cool job? Check. Cool team? Two Checks. Rewarding work that impacts the lives of others? CHECK. 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.

Senior Data Engineer

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
• Proficiency working with business intelligence and analytical platforms

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.

At United Therapeutics, our mission and vision are one. We use our enthusiasm, creativity, and persistence to innovate for the unmet medical needs of our patients and to benefit our other stakeholders. We are bold and unconventional. We have fun, we do good.

• Eligible employees may participate in the Company’s comprehensive benefits suite of programs, including medical / dental / vision / prescription coverage, employee wellness resources, savings plans (401k and ESPP), paid time off & paid parental leave benefits, disability benefits, and more. For additional information on Company benefits, please visit https://www.unither.com/careers/benefits-and-amenities

United Therapeutics Corporation is an Equal Opportunity Employer, including veterans and individuals with disabilities. We strive to be an organization that engages the minds, hearts, and most spirited efforts of each of our employees. Our sense of purpose transforms what we do from work into mission, occupation into vocation and achievement into success. We challenge our employees with innovative and revolutionary projects, offer an environment which fosters high-level job performance and provide a highly competitive total rewards package. This is what makes United Therapeutics a stimulating place to work.