Senior Business Intelligence Data Analyst - Torrance, CA - 2381326
About The Position
Optum Care, Inc. is seeking a Sr Business Intelligence Data Analyst to develop complex business intelligence solutions and support data strategy. This role involves identifying opportunities and risks, developing dashboards, scorecards, reports, and performing data analysis. The analyst will improve the delivery and management of risk adjustment programs using advanced analytics, including algorithms, visualizations, and maps. Responsibilities include developing and maintaining complex SQL queries and scripts for SQL Server and Snowflake, participating in project discussions to recommend technical solutions, and documenting requirements. The role also involves unit, integration, and system testing, maintaining communication with project stakeholders, gathering business requirements, analyzing program effectiveness, performing peer reviews, providing technical guidance, forecasting resource needs, authorizing deviations from standards, leading teams, motivating team members, supporting project managers with planning and reporting, demonstrating deliverables, and collaborating with DBAs, data modelers, and system administrators to uphold industry standards and best practices. The position reports to the Torrance, CA office, with the possibility of telecommuting.
Requirements
- 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
- Work with Provider Portals or EMRs
Responsibilities
- 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
- Work with DBAs, data modelers, and application/system admins to support maintaining the processes and leading industry level standards or best practices
Benefits
- medical
- dental
- vision
- matching 401k
- employee stock purchase plan
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
