Senior Data Engineer Software

Front Door Defense; Northern (KY); Hybrid; USD 140,000 - 190,000; Full time

Job summary

United Therapeutics seeks a Senior Data Engineer to lead the design, development, and maintenance of enterprise data pipelines and analytics architecture. You will work across teams to ensure efficient data flow, security, and scalability in a hybrid RTP, NC office setting.

The role demands deep data engineering expertise, strong programming skills, and collaboration with cross-functional teams including BI/AI disciplines.

Qualifications

• 5+ years of experience building and maintaining data pipelines and EDW in enterprise environments.
• 3+ years delivering complex data solutions with data architecture and engineering.
• 3+ years of Tier 1 SaaS integration experience or equivalent.
• Advanced SQL skills including complex queries, tuning, and stored procedures.
• Hands-on Azure Databricks with Spark processing, notebooks, and Delta Lake.
• Hands-on Azure Data Factory for ETL/ELT orchestration and monitoring.
• Proficiency in Python and data warehousing concepts.
• Experience collaborating with BI/AI teams and stakeholders.
• Strong problem solving and communication skills.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines using Databricks and Azure Data Factory.
• Provide access controls and security for data assets.
• Maintain daily data processing operations with monitoring and alerts.
• Collaborate with analysts and data scientists to meet data needs.
• Mentor junior engineers and review work from external consultants.
• Monitor data systems for performance and reliability.
• Lead data management best practices and process improvements.
• Participate in code reviews and contribute to technical docs.
• Provide leadership on BI and analytics platforms.

Skills

SQL

Python

Data Warehousing

ETL/ELT

Databricks

Azure

Education

Bachelor's Degree

Tools

Azure Databricks

Azure Data Factory

Spark

Delta Lake

Job description

Senior Data Engineer

Lead design and delivery of enterprise data pipelines and analytics architecture across teams

Location: North Carolina

About The Role

Senior Data Engineer

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.

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.

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