county of Orange-Data Analyst, Sr.

1/20/2022 7:45:55 AM 286


See Position Description


Orange, CA

Closing date and time

3/18/2022 at 11:59 PM Pacific Time (US & Canada); Tijuana

click to apply

Data Analyst, Sr.


Job Description


Department(s): Provider Data Management Services

Reports to: Director, Network Management

FLSA status: Non-Exempt

Salary Grade: L - $37.0192 - $52.4038 ($77,000 - $109,000)


Job Summary


The Data Analyst Sr will provide advanced technical expertise for all data reporting and analysis functions for the Network Management department, including developing, designing, and maintaining databases. The incumbent will serve as the main point of contact to develop and design reports that will assist with the routine operational requirements of the department. The incumbent will develop ad-hoc reports in response to requests by senior management, the Board of Directors and as required by the California Department of Health Care Services (DHCS). The Data Analyst Sr will conduct complex data analyses and develop data reports in support of major CalOptima initiatives.


Position Responsibilities:


• Designs reports from the system of record as needed to ensure data integrity.

• Has in-depth knowledge of CalOptima's DHCS and/or Centers for Medicare & Medicaid Services (CMS) data reporting requirements and produces reports for DHCS accurately and on a timely basis.

• Develops provider accessibility reports utilizing FACETS data and Quest Analytics software.

• Maintains and modifies current databases used by Network Management staff based on internal feedback.

• Analyzes data, identifies data inconsistencies, and provides feedback to resolve issues.

• Produces provider directories as required for all CalOptima's lines of business.

• Uploads and provides reporting on health network member Primary Care Physician (PCP) data.

• Develops ad hoc reporting requests.

• Manages and executes requests from departments to enable the faxing of information to constituents.

• Develops Board of Directors (BOD) conflict of interest reports to be used in conjunction with the monthly BOD meetings.

• Other projects and duties as assigned.


Possesses the Ability to:


• Develop and maintain thorough knowledge of data sources used for reporting.

• Develop and maintain knowledge of the agency's lines of business and health networks.

• Work independently and mentor less experienced team members.

• Establish and maintain effective working relationships with CalOptima leadership and staff.

• Work on complex projects and perform senior-level data quality analysis.

• Present information in a useable format and be able to clearly explain the content.

• Prioritize tasks and use time efficiently.

• Communicate clearly and concisely, both verbally and in writing.

• Utilize computer and appropriate software (e.g., Microsoft Office; Excel, Outlook, PowerPoint, Word) and job-specific applications/systems (e.g., Microsoft Access, FACETS, Cactus, Structured Query Language (SQL), Visual Basic for Applications (VBA), Quest Analytics software, Tableau software) to produce correspondence, charts, spreadsheets, and/or other information applicable to the position assignment.


Experience & Education


• Bachelor's degree in or the equivalent combination of education and experience sufficient to successfully perform the essential duties of the job required.

• 5 years of experience working as a Data Analyst in the health care industry, or in a managed care environment, required.


Knowledge of:


• Microsoft Access to create ad-hoc reports and design databases.

• Microsoft Excel to manipulate data and produce charts/reports applicable to reporting requests.

• Quest Analytics software to develop reports to analyze provider adequacy and accessibility.

• Tableau software for creating dashboard type of reporting for Network Management.

• Managed Care concepts.

• Medicare and Medi-Cal guidelines, regulations, and data reporting requirements.


CalOptima is an equal employment opportunity employer and makes all employment decisions on the basis of merit. CalOptima wants to have qualified employees in every job position. CalOptima prohibits unlawful discrimination against any employee, or applicant for employment, based on race, religion/religious creed, color, national origin, ancestry, mental or physical disability, medical condition, genetic information, marital status, sex, sex stereotype, gender, gender identity, gender expression, transitioning status, age, sexual orientation, immigration status, military status as a disabled veteran, or veteran of the Vietnam era, or any other consideration made unlawful by federal, state, or local laws. CalOptima also prohibits unlawful discrimination based on the perception that anyone has any of those characteristics or is associated with a person who has, or is perceived as having, any of those characteristics.


If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability. You can request reasonable accommodations by contacting Human Resources Disability Management at 657-900-1134.


Job Location: Orange, California


Position Type:


To apply, visit https://apptrkr.com/2782091


Copyright ©2021 Jobelephant.com Inc. All rights reserved.




505 City Parkway West

Orange, California, 92868