Senior Data Engineer

United Therapeutics is hiring a Senior Data Engineer in Research Triangle Park, North Carolina for a hybrid role. In this position, you will design, develop, and maintain data and analytics architecture that supports efficient data flow and management across the organization, with daily ownership of production operations and technical leadership for the team.

What you will do

• Design, build, and optimize ETL/ELT pipelines using Databricks and Azure Data Factory to support enterprise data warehousing and analytics
• Partner 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 such as SQL Databases and Databricks to ensure performance and reliability
• Implement best practices for data management and 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

What you bring

• 5+ years of experience building and maintaining business-critical EDW and pipelines, plus a Bachelor’s Degree
• 3+ years of experience with data architecting and engineering, with a proven record of delivering complex data solutions
• 3+ years of Tier 1 SaaS integration work (for example, Salesforce) or an equivalent background
• 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 for building, orchestrating, and monitoring ETL/ELT pipelines
• Hands-on experience with cloud platforms, with Azure preferred
• Proficiency in Python
• Understanding of data warehousing concepts
• Highly proficient experience working with custom applications and complicated data platforms beyond off-the-shelf systems
• Strong problem-solving and analytical skills with excellent communication and interpersonal skills
• Ability to manage multiple priorities and projects simultaneously, in or outside of a team
• Demonstrated experience delivering data processing reliability
• Proficiency working with business intelligence and analytical platforms

Technologies

• Databricks
• Azure Data Factory
• SQL Databases
• SQL
• Azure Databricks
• Spark
• Notebooks
• Delta Lake
• Azure
• ETL/ELT
• Salesforce
• Python

Benefits

• Medical / dental / vision / prescription coverage
• Employee wellness resources
• Savings plans (401k and ESPP)
• Paid time off
• Paid parental leave benefits
• Disability benefits

Location and work model

This position will be located in the RTP, NC office of United Therapeutics. The role is hybrid, requiring at least three days per week in the office, and in-office requirements could increase based on business needs.