Senior Data Engineer

United Therapeutics; North Carolina; Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical / dental / vision / Rx

Employee wellness resources

Savings plans (401k and ESPP)

Paid time off & parental leave

Disability benefits

Job summary

United Therapeutics in RTP, NC, is seeking a Senior Data Engineer to design, build, and optimize ETL/ELT pipelines using Databricks and Azure Data Factory to support enterprise data warehousing and analytics.

You will work with stakeholders to provide access controls, monitor daily data processing, and collaborate with analysts, data scientists, and other teams to deliver data solutions. Mentors will guide junior engineers and review external consultant work.

Qualifications

• 5+ years of experience building and maintaining EDW and pipelines with a Bachelor’s Degree
• 3+ years of data architecting and engineering 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 teams
• Advanced SQL skills with complex queries, tuning, and stored procedures
• Hands-on production experience with Azure Databricks (Spark, notebooks, Delta Lake)
• Hands-on production experience with Azure Data Factory (ETL/ELT pipelines)
• Proficiency in cloud platforms – Azure preferred
• Proficiency in Python
• Understanding of data warehousing concepts
• Experience with BI/analytic platforms
• Excellent problem solving and communication skills
• Ability to manage multiple priorities and projects

Responsibilities

• Provide access and security controls for data platforms
• Maintain daily data processing operations with monitoring and issue resolution
• Collaborate with analysts, data scientists, and other stakeholders to deliver solutions
• Mentor junior data engineers and review work from external consultants
• Monitor and troubleshoot SQL Databases and Databricks to ensure performance
• Lead data management best practices and drive tool/process improvements
• Participate in code reviews, design discussions, and documentation
• Consult and lead around business intelligence and analytics platforms

Skills

Advanced SQL

Python

Data warehousing

Problem solving

Communication skills

Education

Bachelor's Degree

Tools

Azure Databricks

Azure Data Factory

Salesforce

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.

The Senior Data Engineer

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.

Benefits

• medical / dental / vision / prescription coverage
• employee wellness resources
• savings plans (401k and ESPP)
• paid time off & paid parental leave benefits
• disability benefits

United Therapeutics Corporation is an Equal Opportunity Employer, including veterans and individuals with disabilities.