The Role
Design and deliver complex BI solutions and analytics to support Medicare risk adjustment programs. Build dashboards, reports, and data marts using SQL, Snowflake, and ETL (SSIS); apply advanced analytics and scripting (Python/Batch); gather requirements, perform testing and peer reviews, lead project/functional teams, and collaborate with DBAs, data modelers, and system admins to implement data strategy and solutions.
Summary Generated by Built In
Requisition Number: 2381326
Senior Business Intelligence Data Analyst - Torrance, CA - 2381326
EMPLOYER: Optum Care, Inc.
JOB TITLE: Sr Business Intelligence Data Analyst
LOCATION: 19191 S. Vermont Avenue, Torrance, CA (Reports to the Torrance, CA office. May telecommute.)
DUTIES: Develop complex business intelligence solutions and support data strategy leveraging acquired subject matter expertise to identify/inform opportunities/risks; develop complex dashboards, scorecards, reports, and data analysis; improve the delivery and management of risk adjustment programs by utilizing advanced analytics, including but not limited to advanced algorithms, data visualizations, and maps; develop and maintain complex SQL queries and scripts used to create tables, views, and data marts in SQL Server, Snowflake; participate in project discussions to document and recommend alternative technical solutions or requirements; participate in units, integration, and system testing; maintain effective communication and relationships with all individuals involved with the project; gather business requirements and prepare analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency supporting projects and change requests; perform peer-reviews and provide technical support or guidance to the project team; forecast and plan resource requirements. Authorize deviations from standards; lead functional or segment teams or projects; provide explanations and information to others on the most complex issues; motivate and inspire other team members; support the project manager and leadership in project planning and executing activities, including presentations, risks or issues, and status reporting; demonstrate deliverables to the team or the customers for approval and gain buy-in to implement solutions or adapt to new products/services/programs; and work with DBAs, data modelers, and application/system admins to support maintaining the processes and leading industry level standards or best practices. Reports to the Torrance, CA office. May telecommute.
REQUIREMENTS: Employer will accept a Bachelor's degree in Computer Science, Information Technology or related field and 5 years of progressive post-baccalaureate experience in the job offered or Data Analyst- related occupation.
Experience must include:
* Develop, implement, and maintain complex MS Power BI dashboards, MS Power Pivot dashboards, SSRS dashboards visualizations, and analytics;
* Develop complex SQL scripts, stored procedures, functions and views;
* ETL solutions with SSIS;
* Data warehouse platforms like Snowflake, Redshift, Databricks or Azure;
* Analyze and deliver complex analytics using Medicare and enrollment data for Medicare Risk Adjustment;
* Scripting tools such as Python or Batch Scripting to support data analysis, troubleshooting and ETL automation; and
* Work with Provider Portals or EMRs.
RATE OF PAY: $158,808 per year
Please apply via careers.uhg.com and search for job #2381326
Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)
UnitedHealth Group offers a full range of comprehensive benefits, including medical, dental and vision, as well as matching 401k and an employee stock purchase plan.
Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.
UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
Senior Business Intelligence Data Analyst - Torrance, CA - 2381326
EMPLOYER: Optum Care, Inc.
JOB TITLE: Sr Business Intelligence Data Analyst
LOCATION: 19191 S. Vermont Avenue, Torrance, CA (Reports to the Torrance, CA office. May telecommute.)
DUTIES: Develop complex business intelligence solutions and support data strategy leveraging acquired subject matter expertise to identify/inform opportunities/risks; develop complex dashboards, scorecards, reports, and data analysis; improve the delivery and management of risk adjustment programs by utilizing advanced analytics, including but not limited to advanced algorithms, data visualizations, and maps; develop and maintain complex SQL queries and scripts used to create tables, views, and data marts in SQL Server, Snowflake; participate in project discussions to document and recommend alternative technical solutions or requirements; participate in units, integration, and system testing; maintain effective communication and relationships with all individuals involved with the project; gather business requirements and prepare analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency supporting projects and change requests; perform peer-reviews and provide technical support or guidance to the project team; forecast and plan resource requirements. Authorize deviations from standards; lead functional or segment teams or projects; provide explanations and information to others on the most complex issues; motivate and inspire other team members; support the project manager and leadership in project planning and executing activities, including presentations, risks or issues, and status reporting; demonstrate deliverables to the team or the customers for approval and gain buy-in to implement solutions or adapt to new products/services/programs; and work with DBAs, data modelers, and application/system admins to support maintaining the processes and leading industry level standards or best practices. Reports to the Torrance, CA office. May telecommute.
REQUIREMENTS: Employer will accept a Bachelor's degree in Computer Science, Information Technology or related field and 5 years of progressive post-baccalaureate experience in the job offered or Data Analyst- related occupation.
Experience must include:
* Develop, implement, and maintain complex MS Power BI dashboards, MS Power Pivot dashboards, SSRS dashboards visualizations, and analytics;
* Develop complex SQL scripts, stored procedures, functions and views;
* ETL solutions with SSIS;
* Data warehouse platforms like Snowflake, Redshift, Databricks or Azure;
* Analyze and deliver complex analytics using Medicare and enrollment data for Medicare Risk Adjustment;
* Scripting tools such as Python or Batch Scripting to support data analysis, troubleshooting and ETL automation; and
* Work with Provider Portals or EMRs.
RATE OF PAY: $158,808 per year
Please apply via careers.uhg.com and search for job #2381326
Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)
UnitedHealth Group offers a full range of comprehensive benefits, including medical, dental and vision, as well as matching 401k and an employee stock purchase plan.
Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.
UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
Skills Required
- Bachelor's degree in Computer Science, Information Technology or related field and 5 years of progressive post-baccalaureate experience
- Develop, implement, and maintain complex MS Power BI dashboards and MS Power Pivot dashboards, SSRS visualizations and analytics
- Develop complex SQL scripts, stored procedures, functions and views (including SQL Server)
- ETL solutions using SSIS
- Experience with data warehouse platforms such as Snowflake, Redshift, Databricks or Azure
- Analyze and deliver complex analytics using Medicare and enrollment data for Medicare Risk Adjustment
- Scripting tools such as Python or Batch Scripting to support data analysis, troubleshooting and ETL automation
- Experience working with Provider Portals or EMRs
Optum Compensation & Benefits Highlights
-
Healthcare Strength — Official materials highlight copay and HSA medical plan choices with in‑network preventive care at 100%, prescription coverage, and low/no‑cost virtual visits, plus company HSA contributions. Dental preventive services are 100% in network, and mental health resources include an EAP and premium Calm access.
-
Parental & Family Support — Programs include six weeks paid parental leave, up to two weeks paid caregiver leave, and Bright Horizons back‑up care with enhanced family supports. Adoption assistance up to $10,000 for full‑time employees reinforces family‑oriented benefits.
-
Equity Value & Accessibility — Financial benefits include an Employee Stock Purchase Plan at a 10% discount, expanding access to equity ownership.
Optum Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Optum, part of the UnitedHealth Group family of businesses, 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. At Optum, we support your well-being with an understanding team, extensive benefits and rewarding opportunities. By joining us, you’ll have the resources to drive system transformation while we help you take care of your future. We recognize the power of connection to drive change, improve efficiency and make a difference in health care. Join a team where your skills and ideas can make an impact and where collaboration is key to creating technology that produces healthier outcomes.
Gallery
Optum Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
Optum has three workplace models that balance the needs of the business and the responsibilities of each role. These models, core on‑site (5 days/week), hybrid (4 days/week) and telecommute or fully remote, vary by country, role and location.
Typical time on-site:
Not Specified
