Senior Data Systems Analyst

California, US residents  () .

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

The Senior Data Systems Analyst will collaborate with the Distribution Analytics team to ensure proper functionality of current data applications and programs. This position will play a critical role in supporting data automation, data mining, and cleansing. The role entails the enhancement and maintenance of automated programs and systems that aid in statistical analysis and forecasting. Distribution Analytics supports a range of teams, including Executive, Trade, Managed Markets, Global Supply Chain, Manufacturing, Finance, and Government Price Reporting.

This role will also provide expertise in reporting systems, including the Microsoft suite and Fabric tools such as Power BI.

+ Analyze past results, perform variance analysis, identify trends, and make recommendations for areas of improvement in data automation and data systems

+ Serve as the backbone of the data ecosystem, designing and maintaining the connections between SQL databases, Microsoft Fabric, Power BI, and Dataflow pipelines

+ Own end-to-end data integration across systems, ensuring consistent, reliable, and performant data flow across the organization

+ Develop new Excel insights and Power BI analytics leveraging existing and new dataflows, notebooks, and lake houses

+ Identify and support process improvements, including creation of standard and ad-hoc reports and tools using Excel and other dashboards

+ Support data mining, cleansing, and data quality for Executive, Trade, Finance, IT, Managed Markets, and Government Price Reporting projects

+ Perform reconciliation and management of commercial inventory transactions in compliance with related contracted terms, including DOH monitoring and inventory management

+ Build and manage Power BI semantic models, ensuring datasets are clean, governed, and ready for self-service analytics

+ Support inventory, specialty pharmacy, and sales-related data within Fabric and/or Databricks

+ Support development and use of automation tools for monitoring data quality

+ Serve as point of contact to IT for the team

Minimum Qualifications

+ Bachelor's Degree in a related discipline

+ 5+ years of relevant data analysis and/or data engineering experience

+ 3+ years of experience with managing and interpreting large amounts of data and the ability to explain the outcomes of the information including data systems development, data mining, and data cleansing

+ 3+ years of proficient experience with Excel, Power BI, and other analytical/reporting platforms

+ 1+ year of project management experience

+ Strong proficiency in SQL, including complex joins, window functions, stored procedures, and query optimization

+ Hands-on experience with Microsoft Fabric, including Lake houses,…