Data Reporting and Analytics Consultant IV

Kaiser Permanente; Portland (OR); On-site; USD 90,000 - 120,000; Full time

Job summary

Kaiser Permanente in Portland, Oregon is seeking a Data Reporting and Analytics Consultant IV to drive data-informed decisions across Medicare/Medicaid/ACA data projects. This role focuses on gathering data, building analytic models, and delivering automated reporting solutions for internal clients and stakeholders.

The ideal candidate will bring strong SQL coding, experience with large datasets, and knowledge of healthcare analytics.

Qualifications

• Minimum one year of leadership experience (with or without direct reports).
• Bachelor’s degree in Mathematics, Statistics, Engineering, sciences, Business, or related field plus five years data analytics experience.
• Experience with data extraction, data mining, and relational databases.
• Experience with Tableau BI, Oracle, SharePoint, or Excel pivot tables is a plus.

Responsibilities

• Drives strategic data-informed decisions by gathering data and informing stakeholders.
• Prepares data for analytic efforts by integrating and validating data quality.
• Develops automated reporting solutions and BI visuals for stakeholders.
• Interprets analyses and presents actionable insights to drive business decisions.

Skills

Attention to Detail

Communication

Problem Solving

Decision Making

Learning Agility

Teamwork

Education

Bachelor's degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field

Tools

Data Visualization Tools

Relational Database Management

Statistical Programming Language

Data Extraction

Data Mining

Tableau BI

Project Management

Written Communication

Job description

Overview

The Risk Adjustment Data Provisioning team provides on-spec Medicare Advantage, ACA and Medicaid data to internal clients, vendors and consultants to support critical initiatives and projects. We are looking for strong SQL coding and transformation, and comfort moving large datasets. Robust QA documentation, excellent communication and collaboration, and creative problem-solving skills are key in this role. Knowledge of claims, healthcare analytics and Risk Adjustment experience are highly desired.

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 experience working with database software (e.g., Access).
• Two (2) years experience working with data analysis software (e.g., Minitab, QI Macros, Tableau, etc.).
• Two (2) years of experience working with Tableau BI , Oracle, SharePoint, and/or Excel (e.g., creating pivot tables).
• Two (2) years of experience working with qualitative and quantitative analyses.
• Two (2) years of experience working with Medicaid.
• Two (2) years of experience working with the Project Management Office (PMO).
• Two (2) years of experience working with qualitative and quantitative analyses.
• Two (2) years of experience working with Medicare.
• Two (2) years of experience working in an integrated healthcare delivery system.
• Three (3) years experience in business analysis.
• Two (2) years data analytics experience.
• Two (2) years experience working with advanced Excel functions including, formulas, pivot tables, vlookup, etc.
• One (1) years healthcare experience.
• One (1) years experience developing and delivering presentations to management.

COMPANY: KAISER

TITLE: Data Reporting and Analytics Consultant IV

LOCATION: Portland, Oregon

REQNUMBER: 1450081

External hires must pass a background check/drug screen. Qualified applicants with arrest and/or conviction records will be considered for employment in a manner consistent with Federal, state and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran, or disability status.