Senior Business Intelligence Analyst

Overview

To support the financial reporting and analytical processes by analyzing complex healthcarecost drivers. Develops, coordinates, and is directly involved in projects and activities that helpdrive business decisions, affect provider reimbursement programs. Plays a key role in thepreparation, analysis, and review of the Rate Development Templates (RDT) and SupplementalData Requests (SDR). Applies analytics and research to healthcare related topics such ashomelessness, inpatient hospitalization, and chronic disease to determine financial implicationsand areas for potential cost savings/improvement. Works collaboratively with staff inFinance/Accounting in the ongoing analysis and reporting of all aspects of the income statementand other operating metrics.

Responsibilities

- Develops, interprets, and implements financial models and concepts for financialplanning and analysis.- Creates, maintains, and updates complex financial analysis and reporting models toensure the accuracy, validity, and reliability of the model and the data.- Adapts the financial analysis and reporting models to meet the growing and changingneeds of the HealthPlan and to reflect changes in the regulatory environment.- Lead Analyst on the annual RDT and periodic SDR requests from DHCS.- Assists in the training of other Finance Analysts by serving as an experienced mentor.- Designs, implements, and improves executive level financial presentations, includingdashboards for executive leadership, Finance Committee and Board of Directors.- Supports management in making data driven decisions by providing clear and accuratefinancial insights.- Collaborates with management and cross-function teams to understand programmaticchanges along with strategic initiatives.- Designs and generates decision support tools that focus on membership, utilization,trends, State capitation rates and provider contracting. Based on detailed analytics,Page 2 of 4creates actionable information that results in identifying trend drivers and opportunitiesfor improvement.- Prepares and presents data interpretation and recommendations at a level understoodby diverse audiences including staff, all levels of management, physicians, board ofdirectors, and external customers.- Works on complex problems and provides solutions that are innovative andsophisticated to achieve high quality work process improvements.- Connects healthcare metrics with fiscal implications and synthesizes findings to identifymajor drivers and areas for potential savings.- Introduces new tools and resources to the Department and Organization for datamodeling and/or presentations.- Participates in special projects and assignments as needed.- Other duties as assigned.

Qualifications

Education and Experience

Graduate degree in Finance, Accounting, Economics, Statistics orrelated field required; minimum eight (8) years’ progressive experiencein healthcare FP&A experience leading and directing detailed dataanalysis projects; or an equivalent combination of education andexperience.

Special Skills, Licenses and Certifications

Strong working knowledge of managed care financial principles,experience with MediCal managed care desired. Detailed knowledge ofhealthcare industry reporting requirements, terminology and policies.Strong data management, audit control, version management, andreconciliation management skills required. Ability to conduct statisticalanalysis and techniques. Advanced experience working with databases(e.g. SQL Server) and large datasets is required. In-depth experiencein developing and implementing Business Intelligence solutions(reports, metrics, dashboards, and scorecards). Programmingexperience (SAS, Oracle, SQL, R, Python). Proficient in Tableau orother data visualization programs.

Performance Based Competencies

Must demonstrate strong verbal and written communication skills, aswell as strong presentation skills: ability to clearly communicate complexinformation to diverse audiences. Ability to communicate data needs tovarious customers (internal and external) in order to compile andproduce necessary reports. Excellent analytical, problem solving,investigative and research ability. Ability to work in a team environment,take and give direction, follow through with tasks and projects,compromise, negotiate and achieve consensus decisions, supportconsensus decisions, be flexible and adaptable to changes inassignments and the work environment, work independently, managetime efficiently and multi-task effectively. Ability to determineappropriate courses of action in complex situations that may not beaddressed by existing policies or procedures. Ability to make decisionsthat require significant analysis and investigation with solutionsrequiring original thinking.

Work Environment And Physical Demands

Ability to use a computer keyboard and 10-key calculator. More than70% of work time in front of a computer monitor. When required, abilityto move, carry, or lift objects of varying size, weighing up to 10 lbs.

All HealthPlan employees are expected to:

• Provide the highest possible level of service to clients;
• Promote teamwork and cooperative effort among employees;
• Maintain safe practices; and
• Abide by the HealthPlan’s policies and procedures, as they may from time to time be updated.

HIRING RANGE:

$136,296.78 - $177,185.82

IMPORTANT DISCLAIMER NOTICE

The job duties, elements, responsibilities, skills, functions, experience, educational factors and the requirements and conditions listed in this job description are representative only and not exhaustive or definitive of the tasks that an employee may be required to perform. The employer reserves the right to revise this job description at any time and to require employees to perform other tasks as circumstances or conditions of its business, competitive considerations, or work environment change.