Data Reporting and Analytics Consultant II - Physician Incentives and Awards

Description: Job Summary:

This individual contributor is primarily responsible for providing analytical support for physician incentive and award programs by automating reports, producing standard reports, conducting analyses, and communicating results. Helpsdefine metric specifications, validate and review data, and answer data related questions. Participates in year-end award calculations and annual updates to award databases and develops graphs/charts to communicate results.

Essential Responsibilities:

• With oversight from the Consulting Manager, works closely with Consultants to provide data and analyses for physician incentive and award programs, i.e., those related to the patient care experience.


• In collaboration with the Data Reporting and Analytics Consultant V in the department, develops automation processes to streamline data collection, data sharing, data quality checks, and data validation to the extent possible.


• 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.

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.

Additional Requirements:

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

Preferred Qualifications:

• Prior work experience automating reports or implementing process efficiencies to existing reports.
• Previous related quantitative/qualitative analytical experience preferred
• Proficient in Microsoft Excel (intermediate), proficiency in Access (intermediate), Power BI/Tableau preferred
• Demonstrated ability to identify issues, synthesize analyses, highlight implication of findings.
• One (1) year experience working with Access.
• One (1) year data simulation experience.

Primary Location: California,Pasadena,Walnut Center - Regional Offices
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: Remote
Employee Status: Regular
Employee Group/Union Affiliation: NUE-SCAL-01|NUE|Non Union Employee
Job Level: Individual Contributor
Specialty: Data Reporting & Analytics
Department: Regional Offices - Pasadena - RGNL MG-Total Practc Profile - 0806
Pay Range: $71700 - $92730 / year The ranges posted above reflect the location in the job posting. The salary range may vary if you reside in a different location or state than the location posted.
Travel: Yes, 5 % of the Time
Remote: Work location is the remote workplace (from home) within KP authorized states. Worker location must align with Kaiser Permanente's Authorized States policy. At Kaiser Permanente, equity, inclusion and diversity are inextricably linked to our mission, and we aim to make it a part of everything we do. We know that having a diverse and inclusive workforce makes Kaiser Permanente a better place to receive health care, a more supportive partner in our communities we serve, and a more fulfilling place to work. Working at Kaiser Permanente means that you agree to and abide by our commitment to equity and our expectation that we all work together to create an inclusive work environment focused on a sense of belonging and wellbeing.

Kaiser Permanente is an equal opportunity employer committed to a diverse and inclusive workforce. Applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), age, sexual orientation, national origin, marital status, parental status, ancestry, disability, gender identity, veteran status, genetic information, other distinguishing characteristics of diversity and inclusion, or any other protected status. Submit Interest

---