Data Reporting Analyst III

Kaiser Permanente; Oakland (CA); On-site; USD 101,000 - 131,000; Full time

Job summary

Kaiser Permanente in Oakland is seeking a Data Reporting Analyst III to drive risk adjustment accuracy and financial performance across Medicare Advantage, ACA, and Medicaid programs. You will mine data with SQL, Databricks, and Python, and develop BI reports to support strategic decisions and operational excellence.

As a contributor, you will gather data, automate reporting solutions, and present findings using PowerPoint.

Qualifications

• Bachelor's degree in specified fields and minimum 3 years data analytics experience.
• Equivalent work experience may substitute for degree requirement.
• KSAs include data extraction, visualization, statistical programming, relational databases, project management, and business planning.

Responsibilities

• Supports data-informed decisions by gathering data on targeted variables and preparing data for analysis (systematic approach).
• Develops, implements, and automates reporting solutions and BI outputs with stakeholders.
• Validates data sources, merges data, and provides training and documentation for users.
• Prepares data for analytic efforts by cleaning and creating final datasets for analysis.
• Communicates results and storytelling to stakeholders to enable decision making.

Skills

Data extraction

Data visualization

Statistical programming

Relational databases

Project management

Business planning

Education

Bachelor's degree in related field

Tools

Synapse SQL

Databricks

Python

Power BI

Excel

Job description

• PLEASE NOTE: Salary ranges are geographically based and the posted range reflects the Northen CA region. Lower salary ranges will apply for other labor markets outside of NCAL

• PLEASE NOTE: Salary ranges are geographically based and the posted range reflects the Northen CA region. Lower salary ranges will apply for other labor markets outside of NCAL

Overview

The Market Performance team is seeking a Data Reporting Analyst III to play a strategic role in ensuring risk adjustment completeness and accuracy and driving financial performance across Medicare Advantage, ACA, and Medicaid government programs.

This pivotal role will report to the manager of the Market Performance Team and is expected to manage their workload efficiently (Jira) and collaborate with other departments and markets in Kaiser Permanente. Other duties include data mining (Synapse SQL, Databricks, Python), researching key metrics driving market performance to support understanding of reported metrics (Power BI, Excel, HealthConnect), providing Medicare Advantage (MA)/Affordable Care Act (ACA) and Medicaid risk score forecasting support, consistently applying storytelling fundamentals to analyses, and presenting research findings that directly support strategic decision-making and operational excellence (using PowerPoint).

Job Summary

This individual contributor is primarily responsible for supporting data-informed decisions, gathering data and information on targeted variables in an established systematic fashion, and preparing data for analytic efforts. This position develops, implements, and automates business and reporting solutions and supporting data analysis interpretation.

Essential Responsibilities

• Pursues self-development and effective relationships with others by proactively providing resources, information, advice, and expertise with coworkers and customers; influencing others through technical explanations and examples; providing occasional mentoring to team members; listening and responding to, seeking, and addressing performance feedback; creating plans to capitalize on strengths and develop weaknesses; anticipating and responding to the needs of others; and adapting to and learning from change, difficulties, and feedback.
• Completes work assignments by applying up-to-date expertise in subject area to generate creative solutions; ensuring all procedures and policies are followed; leveraging an understanding of data, and resources to support projects or initiatives; collaborating cross-functionally to solve business problems; identifying and monitoring priorities, deadlines, and expectations; communicating progress and information; identifying, recommending, and implementing ways to address improvement opportunities; and escalating issues or risks as appropriate.
• Gathers data and information on targeted variables in an established systematic fashion by validating data sources; querying, merging, and extracting data across sources; completing routine data refresh and update; developing and/or delivering tools for electronic data collection; and providing user training, support, and documentation.
• Prepares data for analytic efforts by consolidating data; reviewing data for quality and accuracy; profiling data inaccuracies; and cleaning and creating final data set(s) for analysis.
• Develops, implements, and automates business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; summarizing data and results; creating summary statistics; organizing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.
• Supports data analysis interpretation by applying findings to contextual settings under the guidance of more senior employees; and developing reports and presentations telling a compelling story to stakeholders to enable and influence decision making.
• Supports data-informed decisions by consulting with clients to identify and clarify key business needs; developing outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing analysis plans; measuring the impact of business decisions on clients, customers, and/or members; working with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.

Minimum Qualifications

• Bachelors degree in Mathematics, Statistics, Computer Science, Engineering, Social/Physical/Life Science, Business, or related field and Minimum three (3) years experience in data analytics or a directly related field. Additional equivalent work experience in a directly related field may be substituted for the degree requirement.

Additional Requirements

• Knowledge, Skills, and Abilities (KSAs): Data Extraction; Data Visualization Tools; Statistical Programming Language; Relational Database Management; Project Management; Business Planning

Preferred Qualifications

• Accredited Project Management Certification.
• Accredited Process Improvement Certification.

Primary Location: California,Oakland,Ordway

Scheduled Weekly Hours: 40

Shift: Day

Workdays: Mon, Tue, Wed, Thu, Fri

Working Hours Start: 08:00 AM

Working Hours End: 05:00 PM

Job Schedule: Full-time

Job Type: Standard

Worker Location: Flexible

Employee Status: Regular

Employee Group/Union Affiliation: NUE-PO-01|NUE|Non Union Employee

Job Level: Individual Contributor

Department: MSSA Admin Offices - Medicare LOB Admin - 0308

Pay Range: $101200 - $130900 / year

Kaiser Permanente strives to offer a market competitive total rewards package and is committed to pay equity and transparency. The posted pay range is based on possible base salaries for the role and does not reflect the full value of our total rewards package. Actual base pay determined at offer will be based on labor market data, internal alignment, and a candidate's years of relevant work experience, education, certifications, skills, and geographic location.

Travel: Yes, 5 % of the Time

Work Setting: Flexible

Worker location must align with Kaiser Permanente's Authorized States policy.

Kaiser Permanente is an equal opportunity employer committed to fair, respectful, and inclusive workplaces. Applicants will be considered for employment without regard to race, religion, sex, age, national origin, disability, veteran status, or any other protected characteristic or status.