Note: The job is a remote job and is open to candidates in USA. Optum is a global organization that delivers care aided by technology to help millions of people live healthier lives. The Senior Healthcare Analyst will develop and maintain Power BI dashboards, conduct in-depth data analysis, and support strategic decision-making to enhance operational and financial performance. This role requires expertise in SQL development, data modeling, and analytics, along with the ability to mentor team members and drive continuous improvement in data processes.
Responsibilities
- 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
- 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
- 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
- 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
- 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
Skills
- Bachelor's degree in Information Systems, Computer Science, Data Analytics, Finance, Mathematics, Statistics, or a related field, or equivalent practical experience
- 5+ years of experience in data analytics, business intelligence, data engineering, or a related technical role
- Advanced SQL expertise with experience building complex queries and data solutions
- Deep understanding of: Window functions, CTEs, Temporary tables, Query performance tuning, Multi-step data transformations, Relational databases
- Understanding of data warehousing concepts and dimensional modeling, including fact and dimension tables
- Advanced Power BI experience, including: Data modeling, DAX, Report optimization, Dashboard development, Large dataset performance management
- Ability to work independently and translate ambiguous business requirements into actionable technical solutions
- Problem-solving, analytical, and communication skills
- Ability to work 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
- Experience working with datasets containing tens of millions of records
- Experience with Python for automation, data processing, or analytical workflows
- Experience designing scalable reporting and data architecture solutions
- Experience mentoring analysts or serving as a technical lead
- Knowledge of data governance, ETL processes, and enterprise reporting best practices
Benefits
- A comprehensive benefits package
- Incentive and recognition programs
- Equity stock purchase
- 401k contribution (all benefits are subject to eligibility requirements)
Company Overview