Data Reporting and Analytics Consultant V

The Data Reporting and Analytics Consultant V is a senior individual contributor who will support Kaiser Permanente-s Colorado and Nevada markets and serves as the market-s expert on membership performance. This role analyzes and forecasts membership trends across all segments, translating complex market dynamics, competitive positioning, and regulatory impacts into clear, actionable insight. The consultant provides objective, trusted analytics that guide executive decision-making.

Partnering closely with market leaders across both health plan and care delivery, the role reconciles differing perspectives and aligns stakeholders around realistic, data-driven membership forecasts. Success in this role requires advanced proficiency in Excel modeling, SQL, and data visualization, with additional value placed on Tableau, Databricks, Python, and modern forecasting methods. Through rigorous analysis and strong executive communication, the Consultant V plays a critical role in strengthening membership performance and shaping the market-s growth strategy.

Job

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 complex data analyses. This position drives the execution of creative data analytic approaches leading to actionable outcomes across functional areas, business and/or clinical lines, designs, implements, and automates business and reporting solutions, and leads the development of advanced analytical and/or statistical models enabling informed business decisions.

Essential

Practices self-leadership and promotes learning in others by building relationships with cross-functional stakeholders; communicating information and providing advice to drive projects forward; influencing team members within assigned unit; listening and responding to, seeking, and addressing performance feedback; adapting to competing demands and new responsibilities; providing feedback to others, including upward feedback to leadership and mentoring junior team members; creating and executing plans to capitalize on strengths and develop weaknesses; and adapting to and learning from change, difficulties, and feedback.

Conducts or oversees business-specific projects by applying deep expertise in subject area; promoting adherence to all procedures and policies; developing work plans to meet business priorities and deadlines; determining and carrying out processes and methodologies; coordinating and delegating resources to accomplish organizational goals; partnering internally and externally to make effective business decisions; solving complex problems; escalating issues or risks as appropriate; monitoring progress and results; recognizing and capitalizing on improvement opportunities; and evaluating recommendations made by others.

Interprets complex 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; participating in peer reviews; and providing context related to data interpretations and/or limitations as appropriate. Leads the development of advanced analytical and/or statistical models enabling informed business decisions by determining data and analytical requirements; translating models and gaining stakeholder buy-in for implementation; creating complex models leading to actionable insights; and testing, refining, and validating models.

Designs, implements, and automates business and reporting solutions by partnering with stakeholders to advise in their design, planning, and implementation while ensuring consistency and coherency; evaluating and summarizing data and results; creating summary statistics; designing 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.

Drives the execution of creative data analytic approaches leading to actionable outcomes across functional areas, business and/or clinical lines by defining and calculating complex metrics to be analyzed; defining, calculating, and validating algorithms; and conducting complex analyses, including descriptive, correlational, inferential, and/or predictive statistics. 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; collaborating with stakeholders and source system owners to resolve data quality issues as appropriate; and cleaning and creating final data set(s) for analysis.

Gathers data and information on targeted variables in an established systematic fashion by validating data sources; querying, merging, and extracting data across internal and external sources; completing routine data refresh and update; developing and/or delivering complex tools for electronic data collection; and providing user training, support, and documentation. Drives strategic data-informed decisions by consulting with clients and leadership to identify and clarify key business needs across functional areas, business and/or clinical lines; developing outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing complex analysis plans; evaluating the impact of business decisions on clients, customers, and/or members; partnering with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.

Qualifications 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 Negotiation Project Management Relational Database Management Statistical Programming Language Vendor Management Written Communication

Minimum three (3) years 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 eight (8) 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.

Three (3) years project management experience. Three (3) years relational database experience. Scheduled Weekly Hours: 40

Day Workdays: Mon, Tue, Wed, Thu, Fri Working Hours Start: 08:30 AM Working Hours End: 05:30 PM Job

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 - Membership & Market Analytics - 7016

$139200 - $180070 / year Travel: Yes, 5 % of the Time