Senior Healthcare Analyst

Healthcare Senior Analyst

This position is remote in the Pacific Time Zone. You will have the flexibility to work remotely as you take on some tough challenges.

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities.

Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

Join us and put your data analytics knowledge and skills to work in support of Operational Finance.

The Healthcare Senior Analyst will develop and maintain Power BI dashboards to provide critical insights into operational and financial performance. They will help support building and maintaining complex data models and their proficiency in working with large data sets will be crucial. By conducting in-depth data analysis and creating ad hoc reports, they will support strategic decision-making and enhance the team's ability to achieve key performance goals.

This position is full-time. Employees are required to have flexibility to work any of our shift schedules during our normal business hours of 8am - 5pm. It may be necessary, given the business need, to work occasional overtime.

We offer weeks of paid training. The hours of training will be based on your schedule or will be discussed on your first day of employment.

Primary Responsibilities:

• Data Engineering & SQL Development
• Design, develop, and maintain complex SQL solutions to support reporting, analytics, and business decision-making.
• Write highly efficient and scalable SQL queries against large datasets containing millions of records.
• Demonstrate advanced proficiency with SQL concepts, including:
• Window functions
• Common Table Expressions (CTEs)
• Temporary tables
• Query optimization techniques
• Complex joins and data transformations
• Layering and structuring business logic across multiple query steps
• Analyze and troubleshoot data quality, performance, and reporting issues.
• Develop repeatable and maintainable data solutions that are easy to understand and support.

• Data Modeling & Analytics
• Design and maintain data models that accurately represent business processes and reporting requirements.
• Possess a strong understanding of dimensional modeling concepts, including fact tables, dimension tables, and their relationships.
• Partner with stakeholders to translate business requirements into scalable data solutions.
• Ensure consistency and accuracy across reporting and analytical datasets.

• Power BI Development
• Develop and maintain enterprise-level Power BI dashboards and reports.
• Create optimized Power BI data models capable of supporting large datasets while maintaining strong report performance.
• Leverage best practices around relationships, DAX, data model design, and dataset optimization.
• Design intuitive and visually compelling dashboards that effectively communicate key business insights.
• Balance technical performance with user experience and dashboard usability.

• Automation & Python Support
• Utilize Python to support data processing, automation, and analytical workflows when appropriate.
• Understand fundamental Python concepts, including:
• Script execution
• Functions and modules
• Reading and writing data files
• Reusing and integrating code across multiple scripts
• Collaborate with other technical team members to support automation initiatives and process improvements.

• Leadership & Technical Ownership
• Serve as a subject matter expert for data architecture, SQL development, and reporting solutions.
• Mentor team members and promote best practices in analytics, reporting, and data management.
• Independently solve complex technical problems with minimal supervision.
• Drive continuous improvement in data processes, reporting capabilities, and overall analytical maturity.

You'll be rewarded and recognized for your performance in an environment that will challenge you…