Kaiser Permanente logo

Data Reporting and Analytics Consultant II - SQL, DBX, Risk Adjustment

Kaiser Permanente
  • Pasadena, CA
  • $84,300–$109,010 Per Year
2 days ago

Job Description

Primary Location Oakland, California Employee Status: Regular Worker Location: Flexible Schedule Full-time Scheduled Weekly Hours: 40 Shift Day Salary $84300 - $109010 / year

Job Number 1457203 Date Posted 10/30/2026

Submit Interest Save Job

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 Risk Adjustment Strategic Analytics team is seeking a Data Reporting and Analytics Consultant to support scoping and conducting complex analytics, apply storytelling fundamentals to analyses, and help present research findings that generate actionable insights and support strategic decision-making. Ideal candidates bring strong analytical and problem-solving skills, curiosity, and a willingness to learn. Exposure to Risk Adjustment (MA, ACA, or Medicaid), data visualization, and working knowledge of Azure Synapse SQL, Power BI, Excel, and PowerPoint are preferred, along with an interest in translating data into clear business insights within a dynamic healthcare environment. Familiarity with Databricks, Python, GitHub, Jira, or statistical modeling is a bonus but not required.

Job Summary:

This individual contributor is primarily responsible for assisting senior employees in supporting data-informed decisions, assisting with data and information gathering for targeted variables in an established systematic fashion, and supporting data preparation for analytic efforts. This position assists with the execution of creative data analytic approaches leading to actionable outcomes, assists with the development, implementation, and automation of business and reporting solutions, and assists with data analysis interpretation.

Essential Responsibilities:

  • Pursues self-development and effective relationships with others by sharing resources, information, and knowledge with coworkers and customers; listening, responding to, and seeking performance feedback; acknowledging strengths and weaknesses; assessing 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 knowledge in subject area to meet deadlines; following procedures and policies and applying data, and resources to support projects or initiatives; collaborating with others, often cross-functionally, to solve business problems; supporting the completion of priorities, deadlines, and expectations; communicating progress and information; identifying and recommending ways to address improvement opportunities when possible; and escalating issues or risks as appropriate.
  • Assists with data analysis interpretation by organizing and editing reports and presentations telling a compelling story to stakeholders to enable and influence decision making.
  • Supports data-informed decisions under the guidance of more senior employees by working with clients to identify and clarify key business needs; assisting in the development of outcomes and process measures; translating business requirements; informing data/information needs and data collection methods; 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 end-users; and documenting processes and deliverables.
  • Assists with data and information gathering for targeted variables in an established systematic fashion by cleaning and organizing data; querying, merging, and extracting data across sources; completing routine data refresh and update; and providing user support and documentation.
  • Supports data preparation for analytic efforts under the guidance of more senior employees by cleaning data to ensure quality and accuracy based on provided guidelines; and consolidating data.
  • Assists with the execution of creative data analytic approaches leading to actionable outcomes by organizing metrics to be analyzed and calculating algorithms and conducting basic analyses under the guidance of more senior employees, including descriptive statistics.
  • Assists with the development, implementation, and automation of business and reporting solutions by creating summary statistics; organizing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; identifying opportunities to improve exiting reporting solutions; and preparing documentation as appropriate.

Knowledge, Skills and Abilities: (Core)

  • Ambiguity/Uncertainty Management
  • Attention to Detail
  • Business Knowledge
  • Communication
  • Critical Thinking
  • Cross-Group Collaboration
  • Decision Making
  • Dependability
  • Diversity, Equity, and Inclusion Support
  • Drives Results
  • Facilitation Skills
  • Health Care Industry
  • Influencing Others
  • Integrity
  • Learning Agility
  • Organizational Savvy
  • Problem Solving
  • Short- and Long-term Learning & Recall
  • Teamwork
  • Topic-Specific Communication

Knowledge, Skills and Abilities: (Functional)

  • Data Mining
  • Data Visualization Tools
  • Statistical Programming Language
  • Written Communication

Minimum Qualifications:

  • Bachelors degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field OR Minimum two (2) years experience in data analytics or a directly related field.

Preferred Qualifications:

  • One (1) year experience working with Access.
  • One (1) year data simulation experience.

Primary Location: California,Oakland,Ordway

Additional Locations:

  • Pasadena, CA
  • Portland, OR
  • Aurora, CO

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 Employee Status: Regular Worker Location: Flexible Employee Group/Union Affiliation: NUE-PO-01|NUE|Non Union Employee Job Level: Individual Contributor Department: Po/Ho Corp - Risk Adj Reporting Analytics - 0308 Pay Range: $84300 - $109010 / 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 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.

Submit Interest Save Job

Expected Employee Conduct >

Numbers & Facts

LocationPasadena, CA
IndustryHealthcare Services
Salary$84,300–$109,010 Per Year
Company Size10,000 employees or more
Year Founded1945
Websitehttp://www.kp.org/careers

About Company

At Kaiser Permanente, we are relentless in our pursuit of excellence. Driven by our mission to provide the highest quality preventive medicine, we are committed to eliminating health care disparities, and to making lives better through innovation, technology, and research. Our desire to deliver the best possible care inspires us to promote wellness among our members, communities, and each other. It also fuels our belief that everyone — regardless of circumstance — deserves access to affordable care, which further drives our motivation to expand our reach. Founded nearly 80 years ago, our unique business model sets us apart — positioning us to drive improvements across the industry and around the world.

Skills

  • Algorithmsunmatched
  • Analysis Skillsunmatched
  • Atlassian JIRAunmatched
  • Automationunmatched
  • Biologyunmatched
  • Business Intelligenceunmatched
  • Consultingunmatched
  • Cross-Functionalunmatched
  • Customer Support/Serviceunmatched
  • Data Analysisunmatched
  • Data Cleaningunmatched
  • Data Collectionunmatched
  • Data Miningunmatched
  • Data Visualizationunmatched
  • Data Visualization Toolsunmatched
  • Decision Supportunmatched
  • Detail Orientedunmatched
  • Diversityunmatched
  • Documentationunmatched
  • Editingunmatched
  • Fundamental Analysisunmatched
  • GitHubunmatched
  • Healthcareunmatched
  • Help Deskunmatched
  • Mathematicsunmatched
  • Medicaidunmatched
  • Metricsunmatched
  • Microsoft Excelunmatched
  • Microsoft PowerPointunmatched
  • Microsoft Windows Azureunmatched
  • Physical Scienceunmatched
  • Power BIunmatched
  • Problem Solving Skillsunmatched
  • Python Programming/Scripting Languageunmatched
  • Reporting Skillsunmatched
  • Requirements Managementunmatched
  • Riskunmatched
  • Risk Analysisunmatched
  • SQL (Structured Query Language)unmatched
  • Simulationunmatched
  • Statistical Modelingunmatched
  • Statistical Programming Languagesunmatched
  • Statisticsunmatched
  • Storytellingunmatched
  • Strategic Analysisunmatched
  • Support Documentationunmatched
  • Team Playerunmatched
  • Time Managementunmatched
  • eCommerceunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder