Data Reporting and Analytics Consultant IV - Power BI, DataBricks

Kaiser Permanente

$133K — $172K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field.
  • 5-7 years of experience in data analytics or a related field.
  • 1 year of leadership experience, with or without direct reports.
  • Hands-on experience developing data visualizations, particularly in Power BI.
  • Strong understanding of ETL processes and dimensional modeling concepts such as star schemas.

Responsibilities

  • Collaborate with team members and stakeholders to define analytical requirements.
  • Develop and automate reporting solutions, ensuring data accuracy and consistency.
  • Conduct a variety of analyses including descriptive and predictive statistics.
  • Translate complex data insights into clear presentations for stakeholders.
  • Drive strategic decisions by consulting with clients on business needs and outcomes.
  • Gather, validate, and prepare data from multiple sources for analysis.
  • Develop and refine analytical and statistical models for decision-making.

Benefits

  • Work remotely from various locations in the U.S.
  • Engage in continuous learning supported by the company.
  • Access to a comprehensive total rewards package.
  • Participate in a collaborative and cross-functional work environment.
Full Job Description
Remote from any KP location in CA, OR, CO, WA, GA, MD, VA, HI or D.C. Only.
** 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 Data, Reporting and Analytics Consultant IV is a senior individual contributor on the Risk Adjustment Reporting and Analytics team, a Government Programs function responsible for delivering timely, high-quality production reporting and self-service insights into risk score performance and its drivers across Kaiser Permanente markets. The team supports risk-adjusted Medicare, Affordable Care Act, and Medicaid programs. This role collaborates with analysts, business partners, and technical stakeholders to design, develop, and maintain trusted data models and business intelligence solutions. A primary focus will be building scalable data foundations for Power BI and translating complex financial and operational data into clear, actionable reporting. The consultant will be expected to independently own assigned solutions, clarify analytical requirements, apply consistent business logic, and contribute technical expertise to broader team decisions. Near-term priorities include expanding the measures, business logic, and analytical capabilities available through the team-s data models and supporting the modernization of the reporting platform as the underlying data environment transitions from SQL Server and Synapse to Databricks. Success requires hands-on experience developing data visualizations and working with relational data, with particular value placed on Power BI, DAX, and SQL. Candidates should also understand ETL processes, dimensional modeling concepts such as star schemas, and modern data pipelines. Experience with Python, Databricks, or risk adjustment is preferred.

Job Summary:
This individual contributor is primarily responsible for driving strategic data-informed decisions, gathering data and information on targeted variables in an established systematic fashion, preparing data for analytic efforts, and interpreting data analyses. This position executes creative data analytic approaches leading to actionable outcomes, develops, implements, and automates business and reporting solutions, and develops analytical and/or statistical models enabling informed business decisions.

Essential Responsibilities:
  • Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback.
  • Completes work assignments and supports business-specific projects by applying expertise in subject area; supporting the development of work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving complex problems; escalating high priority issues or risks as appropriate; and recognizing and capitalizing on improvement opportunities.
  • Executes creative data analytic approaches leading to actionable outcomes by defining and calculating metrics to be analyzed; defining, calculating, and validating algorithms; and conducting analyses, including descriptive, correlational, inferential, and/or predictive statistics.
  • Develops, implements, and automates business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; evaluating and summarizing data and results; creating summary statistics; developing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; reporting to stakeholders on key findings; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.
  • Interprets data analyses by applying findings to contextual settings; and developing insights, reports, and presentations telling a compelling story to stakeholders to enable and influence decision making; and providing context related to data interpretations and/or limitations as appropriate.
  • Drives strategic 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.
  • 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.
  • Develops analytical and/or statistical models enabling informed business decisions by determining data and analytical requirements; creating models leading to actionable insights; and testing, refining, and validating models.
  • Prepares data for analytic efforts by integrating and consolidating data; ensuring data quality and accuracy; profiling data inaccuracies and recommending process improvements or system changes to enhance overall quality of the data; and cleaning and creating final data set(s) for analysis.
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)
  • Business Planning
  • Data Extraction
  • Data Mining
  • Data Visualization Tools
  • Project Management
  • Relational Database Management
  • Statistical Programming Language
  • Written Communication

Minimum Qualifications:
  • Minimum one (1) year experience in a leadership role with or without direct reports.
  • Bachelors degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field and Minimum five (5) 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.
Preferred Qualifications:
  • Two (2) years project management experience.
  • Two (2) years experience in process improvement.


Primary Location: California,Oakland,Ordway
Scheduled Weekly Hours: 40
Shift: Day
Workdays: Mon, Tue, Wed, Thu, Fri
Working Hours Start: 09:00 AM
Working Hours End: 05:00 PM
Job Schedule: Full-time
Job Type: Standard
Employee Status: Regular
Worker Location: Remote
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: $133100 - $172150 / 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: No

Similar Jobs

More Jobs at Kaiser Permanente

More Information Technology Jobs

Find similar Data Reporting and Analytics Consultant IV - Power BI, DataBricks jobs: