Senior Data Engineer

Unither Pharmaceuticals; North Carolina; Hybrid; USD 110,000 - 170,000; Full time

Job summary

United Therapeutics seeks a Senior Data Engineer to design, develop, and maintain our data and analytics architecture in a hybrid RTP, NC office. You will lead cross-functional data initiatives and collaborate with sales, science, and compliance teams to deliver reliable data solutions.

The ideal candidate will have 5+ years of hands-on data engineering experience, strong SQL and Python skills, and deep knowledge of Azure Databricks, Azure Data Factory, and data warehousing concepts.

Qualifications

• 5+ years building and maintaining business-critical EDW and pipelines.
• 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/BI/AI teams.
• Hands-on experience with Azure Databricks, Spark, notebooks and Delta Lake.

Responsibilities

• 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
• Monitor 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

Skills

Advanced SQL

Azure Databricks

Python

Data modeling

Data warehousing

Problem solving

Communication

Education

Bachelor's Degree

Tools

Azure Data Factory

Salesforce

Delta Lake

Job description

The job details are as follows:

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 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.