Data Reporting and Analytics Consultant III - SAS, SQL
Pasadena, California
Description: Job Summary:
This individual contributor is primarily responsible for supporting data-informed decisions, gathering data and information on targeted variables in an established systematic fashion, and preparing data for analytic efforts.
This position supports the execution of creative data analytic approaches leading to actionable outcomes, develops, implements, and automates business and reporting solutions, supports data analysis interpretation, and supports and develops analytical and/or statistical models enabling informed business decisions.
Essential Responsibilities:
Additional Requirements:
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: Flexible
Employee Status: Regular
Employee Group/Union Affiliation: NUE-SCAL-01|NUE|Non Union Employee
Job Level: Individual Contributor
Specialty: Government Relations
Department: Regional Offices - Pasadena - Rgnl Behavioral Health - 0808
Pay Range: $87900 - $113740 / 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: No
Flexible: Work location is on-site at a KP location, with the flexibility to work from home. 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
This individual contributor is primarily responsible for supporting data-informed decisions, gathering data and information on targeted variables in an established systematic fashion, and preparing data for analytic efforts.
This position supports the execution of creative data analytic approaches leading to actionable outcomes, develops, implements, and automates business and reporting solutions, supports data analysis interpretation, and supports and develops analytical and/or statistical models enabling informed business decisions.
Essential Responsibilities:
- Pursues self-development and effective relationships with others by proactively providing resources, information, advice, and expertise with coworkers and customers; influencing others through technical explanations and examples; providing occasional mentoring to team members; listening and responding to, seeking, and addressing performance feedback; creating plans to capitalize on strengths and develop weaknesses; anticipating 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 expertise in subject area to generate creative solutions; ensuring all procedures and policies are followed; leveraging an understanding of data, and resources to support projects or initiatives; collaborating cross-functionally to solve business problems; identifying and monitoring priorities, deadlines, and expectations; communicating progress and information; identifying, recommending, and implementing ways to address improvement opportunities; and escalating issues or risks as appropriate.
- Supports and 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.
- 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.
- Supports data analysis interpretation by applying findings to contextual settings under the guidance of more senior employees; and developing reports and presentations telling a compelling story to stakeholders to enable and influence decision making.
- Develops, implements, and automates business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; summarizing data and results; creating summary statistics; organizing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.
- Prepares data for analytic efforts by consolidating data; reviewing data for quality and accuracy; profiling data inaccuracies; and cleaning and creating final data set(s) for analysis.
- Supports 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.
- Supports the execution of creative data analytic approaches leading to actionable outcomes by identifying metrics to be analyzed; calculating algorithms; and conducting analyses under the guidance of more senior employees, including descriptive, correlational, inferential, and/or predictive statistics.
- Bachelors degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field and Minimum three (3) 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): Written Communication; Data Extraction; Data Mining; Data Visualization Tools; Statistical Programming Language; Relational Database Management; Project Management; Business Planning
- One (1) year regulatory experience.
- One (1) year experience working in a matrixed organization.
- Demonstrated technical skills using tools like SAS and SQL to create queries from multiple KP data systems (e.g., membership, IDR, Clarity).
- Preparing and presenting reports, dashboards, and charts while using BI tools (e.g., Tableau, Power BI, etc.).
- Analyzing data from databases, encounter claims, membership, and other relevant health sources.
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: Flexible
Employee Status: Regular
Employee Group/Union Affiliation: NUE-SCAL-01|NUE|Non Union Employee
Job Level: Individual Contributor
Specialty: Government Relations
Department: Regional Offices - Pasadena - Rgnl Behavioral Health - 0808
Pay Range: $87900 - $113740 / 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: No
Flexible: Work location is on-site at a KP location, with the flexibility to work from home. 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
Created: 2024-09-07
Reference: 1299132
Country: United States
State: California
City: Pasadena
ZIP: 91101
About Kaiser Permanente
Founded in: 1945
Number of Employees: 304220
Career site: https://www.kaiserpermanentejobs.org/
Instagram: https://www.instagram.com/kpthrive/
Facebook: https://www.facebook.com/kpthrive
Similar jobs:
-
Data Reporting and Analytics Consultant IV, Customer Experience
Kaiser Permanente in Pasadena, California💸 $113100 - $146300 per year -
Data & Analytics Tech Consulting Intern - Summer 2025
PwC in Los Angeles, California -
Data Reporting & Analytics Consultant III - Finance, (Flexible) - Irvine
Kaiser Permanente in Irvine, California💸 $87900 - $113740 per year -
Data Reporting and Analytics Consultant IV, Programming
Kaiser Permanente in Pasadena, California💸 $118800 - $153670 per year -
Data Reporting and Analytics Consultant V, Programming
Kaiser Permanente in San Diego, California💸 $141600 - $183150 per year -
SAP Analytics Planning Consultant (16434)
The Baer Group in Sacramento, California -
Data Reporting and Analytics Consultant IV - SQL, Tableau
Kaiser Permanente in Oakland, California💸 $127600 - $165110 per year -
Data Reporting and Analytics Consultant IV, Programming
Kaiser Permanente in Pasadena, California💸 $118800 - $153670 per year -
Data Reporting and Analytics Consultant III
Kaiser Permanente in Irvine, California💸 $87900 - $113740 per year -
Data Reporting and Analytics Consultant IV - Python/SAS, SQL, Power BI
Kaiser Permanente in Pasadena, California💸 $113100 - $146300 per year -
Adobe Analytics/Reporting Consultant
Cognizant Technology Solutions in SanFrancisco,CA-Mission St, California💸 $110000 per year -
Data Reporting and Analytics Consultant II - Excel, PowerPoint, SQL, Tableau
Kaiser Permanente in Oakland, California💸 $80900 - $104610 per year -
Data Reporting and Analytics Consultant V, Biostatistics
Kaiser Permanente in Pleasanton, California💸 $155200 - $200750 per year -
Data Reporting and Analytics Consultant III - SAS, SQL, MS Excel
Kaiser Permanente in Pasadena, California💸 $87900 - $113740 per year -
Data Reporting and Analytics Consultant III - SQL, Tableau
Kaiser Permanente in Oakland, California💸 $99200 - $128370 per year -
Decision Analytics Consultant
ZS in Thousand Oaks, California -
Data Reporting and Analytics Consultant II
Kaiser Permanente in Pasadena, California💸 $71700 - $92730 per year -
Data Reporting and Analytics Consultant IV, Programming
Kaiser Permanente in Oakland, California💸 $133900 - $173250 per year -
Data Reporting and Analytics Consultant V, Programming
Kaiser Permanente in Santa Ana, California💸 $141600 - $183150 per year -
Data Reporting and Analytics Consultant III, (Flexible) - Irvine
Kaiser Permanente in Irvine, California💸 $87900 - $113740 per year