Note: The job is a remote job and is open to candidates in USA. United Therapeutics Corporation is a publicly-traded biotech company focused on developing novel pharmaceutical therapies. They are seeking a Senior Data Analyst to collaborate with the Distribution Analytics team, ensuring the functionality of data applications, supporting data automation, and enhancing statistical analysis and forecasting processes.
Responsibilities
- 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 lakehouses
- 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
Skills
- 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 Lakehouses, Pipelines, and Dataflows Gen2
- Demonstrated ability to build enterprise-grade Power BI reports and semantic models (DirectQuery, composite models)
- General knowledge of statistical modeling and forecasting
- Deep understanding of data warehouse concepts — star schemas, slowly changing dimensions, incremental refresh
- Experience connecting disparate systems and thinking holistically about data flow and dependencies
- Strong written and verbal skills
- Familiarity with the Power Query M language for advanced transformation logic
- Experience with medallion architecture (Bronze / Silver / Gold) within Fabric or a similar platform
- Exposure to CI/CD practices for data pipelines and version-controlled development
Benefits
- 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
- For additional information on Company benefits, please visit https://www.unither.com/careers/benefits-and-amenities
Company Overview