Data Reporting and Analytics Consultant II - Benefits Reporting Analyst

Job Summary

This individual contributor is primarily responsible for assisting senior employees in supporting data-informed decisions, assisting with data and information gathering for targeted variables in an established systematic fashion, and supporting data preparation for

analytic efforts. This position assists with the execution of creative data analytic approaches leading to actionable outcomes, assists with the development, implementation, and automation of business and reporting solutions, and assists with data analysis interpretation.

Essential Responsibilities

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

Job Qualifications

Minimum Qualifications

• Bachelor's 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

• Experience with SQL querying and data extraction using Oracle SQL Developer or similar database tools.
• Experience with data validation, quality assurance, and ensuring accuracy of reporting outputs.
• Strong analytical skills with ability to interpret data, identify trends, and present findings to stakeholders.
• Proven ability to document processes, data sources, and business rules for knowledge transfer.
• Experience working with cross-functional teams including business users, IT, and regulatory consultants.
• Demonstrated ability to manage multiple priorities and meet reporting deadlines.

Core Competencies

• Strong critical thinking and problem-solving skills with ability to troubleshoot data and reporting issues.
• Excellent written and verbal communication skills with ability to present complex data to non-technical audiences.
• Proven ability to collaborate across functions and organizational levels.
• Strong attention to detail and commitment to data accuracy and quality.
• Results orientation with ability to deliver timely reporting outputs

Technical & Analytical Skills

• Advanced SQL querying skills using Oracle SQL Developer and related database tools.
• Familiarity with Microsoft Access for database management and reporting (legacy system support).
• Strong Excel skills for data analysis and ad hoc reporting

Preferred Qualifications

• Experience with Databricks or similar cloud-based data platforms for analytics and reporting.
• Experience with SAS programming for statistical analysis and data manipulation.
• Experience with Bizagi or similar business process management tools.
• Knowledge of California-specific benefits regulations and reporting requirements.
• Experience supporting platform migrations from legacy tools to modern analytics solutions.
• Healthcare industry experience, particularly with benefits administration or member data.
• Experience with automated reporting workflows and ETL processes.
• Proficiency with Power BI for dashboard development, data visualization, and report automation.
• Experience with SAS for statistical analysis and reporting (for supporting legacy systems during transition).
• Minimum two (2) years’ experience working with healthcare or benefits data, including understanding of PHI/PII compliance requirements