Data Reporting and Analytics Consultant IV, Business Intelligence - NCAL

In addition to the responsibilities listed below, this senior individual contributor Business Intelligence (BI) position spans business analytics, data mining, data visualization, and data tools and infrastructure. The role leverages best practices to help the organization make sound data-driven decisions and transforms data into actionable insights that drive strategic and operational business decisions. This includes using BI tools (e.g., Cognos, Tableau, Power BI) to access and analyze data sets and present findings in visually driven reports, summaries, dashboards, graphs, charts, and maps to provide detailed intelligence about the state of the business.

Responsibilities

• Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise; builds relationships with cross-functional stakeholders; influences others through technical explanations and examples; adapts to competing demands and new responsibilities; listens and responds to performance feedback; provides feedback to others; creates and executes plans to capitalize on strengths and develop weaknesses; supports team collaboration; and adapts to 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 the 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; and recognizing and capitalizing on improvement opportunities.
• Executes creative data analytic approaches leading to actionable outcomes by defining and calculating metrics; 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; evaluating and summarizing data and results; creating summary statistics; developing data reports, visualizations, and/or interactive BI reports; reporting key findings to stakeholders; identifying needs for additional reporting solutions; and preparing documentation.
• Interprets data analyses by applying findings to contextual settings; developing insights, reports, and presentations that tell a compelling story to enable and influence decision-making; and providing context related to data interpretations and/or limitations.
• 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 collection methods; developing analysis plans; measuring the impact of business decisions; working with clients and staff to identify opportunities and methods to improve efficiencies; 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 refreshes and updates; 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; and cleaning and creating final data set(s) for analysis.

Requirements

• Minimum five (5) years of experience programming with Cognos or other BI tools.
• Minimum three (3) years of experience applying folder and data security.
• Minimum two (2) years of experience in relational and dimensional data modeling.
• Minimum one (1) year of experience in a leadership role with or without direct reports.
• Bachelor’s degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or a related field and minimum five (5) years of experience in data analytics or a directly related field. Additional equivalent work experience may be substituted for the degree requirement.

Preferred Qualifications

• Three (3) years of statistical modeling experience.
• Three (3) years of experience working with statistical analysis software.

Skills

• 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 Knowledge
• Influencing Others
• Integrity
• Learning Agility
• Organizational Savvy
• Problem Solving
• Short- and Long-term Learning & Recall
• Teamwork
• Topic-Specific Communication
• BI Dashboard Development
• Business Intelligence
• Data Modules
• Database Compliance & Security Technologies
• Job Scheduling
• Storytelling
• Business Planning
• Data Extraction
• Data Mining
• Data Visualization Tools
• Project Management
• Relational Database Management
• Statistical Programming Language
• Written Communication

Schedule

• Full-time
• Standard shift: Monday–Friday, 8:00 AM–5:00 PM
• Scheduled weekly hours: 40
• Up to 10% travel required
• Remote work allowed (worker location must align with Kaiser Permanente's Authorized States policy)

Pay

Pay range: $133,100 – $172,150 per year. Kaiser Permanente strives to offer a market-competitive total rewards package and is committed to pay equity and transparency. The posted pay range is based on possible base salaries for the role and does not reflect the full value of the total rewards package. Actual base pay determined at offer will be based on labor market data, internal alignment, and a candidate's years of relevant work experience, education, certifications, skills, and geographic location.