Data Reporting and Analytics Consultant IV, Programming

Kaiser Permanente; Oakland (CA); On-site; USD 110,000 - 160,000; Full time

Job summary

Kaiser Permanente in Oakland, CA seeks a Data Reporting & Analytics Consultant IV (Programming) to design, develop, and maintain scalable data and analytics solutions across multiple medical centers. You will build data models, ETL processes, dashboards, and automated reporting while collaborating with leaders and vendors.

The role emphasizes SQL, data visualization, and programming with Python/Databricks; strong communication and problem-solving skills are essential to drive data-informed

Qualifications

• Four to five years in data analytics or similar field.
• Experience with SAS, SQL, R or equivalent programming languages.
• Leadership experience preferred with or without direct reports.

Responsibilities

• Defines, calculates, and validates metrics for analysis.
• Develops and automates data loading and reporting solutions.
• Designs data management, quality control, and reporting processes.
• Tests data conversions and ensures data integrity across sources.
• Develops macros and validation workflows for research and reporting.
• Creates and maintains documentation for processes and deliverables.
• Profiles data quality and recommends improvements.
• Interprets analyses and presents insights to stakeholders.
• Trains end-users and supports data-driven decision making.
• Oversees project phases and may supervise junior team members.

Skills

Leadership

Data analysis

Communication

Problem solving

Cross-functional collaboration

Data modeling

Analytical thinking

Presentation skills

Education

Bachelor’s degree in Mathematics/Statistics/Engineering/Science/Business

Tools

SAS Tools

SQL

R

Python

Tableau

Open Source Tools

UNIX

SQL Server

Web Report Studio

Data Visualization Tools

Databricks

Job description

** PLEASE NOTE: Salary ranges are geographically based and the posted range reflects the Northen CA region. Lower salary ranges will apply for other labor markets outside of NCAL.

Overview:

The Data Reporting & Analytics Consultant IV (Programming) is a member of the Facilities & Support Services Analytics & Metrics Team, supporting data-driven decision-making across 40 medical centers and operational service lines including Engineering, Environmental Services (EVS), Food & Nutrition Services, and Telecommunications. This technical role is responsible for designing, developing, and maintaining scalable data, reporting, and analytics solutions that transform complex operational data into actionable insights. Working closely with business and operational leaders, the consultant develops data models, ETL processes, dashboards, automated reporting, and performance metrics that support strategic and operational objectives. The ideal candidate brings strong expertise in SQL, database development, data modeling, and data visualization, with Python and Databricks experience preferred. Success in this role requires strong analytical, communication, and problem-solving skills, with the ability to present insights to leadership, support end users, collaborate with third-party vendors, and maintain a high level of accuracy and attention to detail.

Job Summary:

In addition to the responsibilities listed below, this position is also responsible for overseeing all phases of data management, quality control, and reporting; programming in analytical programming languages (may include SAS, SQL, SPSS, R, Python, etc.); taking lead role in analyzing and implementing data management, quality control, and reporting needs on multi-programmer projects; and troubleshooting complicated software processes and products. This position is also responsible for designing complicated automated reporting and data loading solutions; testing data conversions and data integrity from a wide variety of sources across platforms; developing complicated macros for various research and reporting purposes; designing comprehensive quality checking and validation process; and developing and evaluate complicated data linkage process. This position may supervise the work of lower level team members serving on the same project.

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)

• Data Integration
• SAS Tools
• SQL/SAS
• Web Report Studio
• Business Planning
• Data Extraction
• Data Mining
• Data Visualization Tools
• Project Management
• Relational Database Management
• Statistical Programming Language
• Written Communication

Minimum Qualifications:

• Minimum four (4) years data management experience with SAS, SQL, R or other similar analytical programming language.
• Minimum five (5) years experience programming with SAS, SQL, R or other similar analytical programming language.
• 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:

• Three (3) years experience working with Open Source Tools (e g , R, Python).
• Three (3) years experience working with data visualization tools.
• Three (3) years text analytics experience.
• Three (3) years experience working with Tableau.
• Three (3) years experience working with Excel.
• Three (3) years experience working with business intelligence tools.
• Three (3) years experience working with SQL.
• Three (3) years experience working with data extraction and manipulation language.
• Three (3) years experience working in the UNIX environment.
• One (1) year experience working with ODS/SQL.
• Three (3) years experience developing in SQL Server.
• Three (3) years experience programming in SQL.
• Three (3) years experience developing in Tableau.
• Three (3) years statistical modeling experience.
• Three (3) years relational database experience.