Data Reporting and Analytics Consultant V - Clarity, SQL, Python, R

Description:
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 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.

This position will drive creative data analytic approaches that lead to actionable strategies for improving patient care experience and quality of care by extracting and linking data from various data sources/tables/systems (e.g., Clarity, HealthConnect, others) for analyses; preparing data for analyses, whether by the incumbent or other team members, using programming languages (e.g., SQL, R, Python, other); conducting analyses and interpretation of quantitative and qualitative data via natural language processing or other software; developing reporting/dashboards via Power BI or other software/methods, using automation, building quality checks and validation; support/train/guide other members of the team on various data analytic projects.

Essential Responsibilities:

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

Minimum Qualifications:

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

Additional Requirements:

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

Preferred Qualifications:

• Three (3) years relational database experience.
• Three (3) years experience working with data visualization tools.
• Three (3) years experience working with data extraction and manipulation language.
• Three (3) years programming experience.
• Two (2) years experience delivering presentations to senior management.
• Two (2) years health care experience.
• Three (3) years text analytics experience.
• Three (3) years statistical modeling experience.
• Three (3) years machine learning experience.
• Three (3) years experience working with artificial intelligence tools.
• Three (3) years experience working with SQL.

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: $141600 - $183150 / 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.