Business Intelligence Analyst II

$66,560 - $93,236/Yr

Conifer Value Based Care - Los Angeles, CA

Full-time - Mid Level

Los Angeles, CA

Professional, Scientific, and Technical Services

About the position

The Business Intelligence Analyst II is responsible for maintaining the financial health of hospital clients by preparing, analyzing, and acting on risk pool statements, which are akin to profit and loss statements. This role involves producing standardized reports using documented procedures, ensuring the quality and accuracy of data, and delivering scheduled and requested reports on time to both internal and external customers. The analyst will utilize multiple business intelligence and analytical tools to summarize data in a meaningful and presentable format, reporting and presenting this data to internal customers in a user-friendly manner. Additionally, the analyst will provide recommendations based on the data presented to enhance decision-making processes. In this position, the analyst will prepare and present financial information for review and approval by leadership, develop solutions to ad-hoc analytical and reporting requests, and perform thorough analyses on financial and operational issues. The role requires a strong understanding of financial reports to ensure they convey meaningful information. The analyst will demonstrate a baseline working knowledge of applications and tools appropriate for the level of the position, follow standard principles and reporting systems used by Conifer, and communicate effectively with both internal and external customers. The analyst will also be expected to maintain effective and collaborative relationships with Conifer staff, demonstrating intermediate knowledge of data reporting using established procedures and tools. Proficiency in tools such as Crystal Reports, Excel, and Access is essential for data extraction and reporting. The analyst will extract data from processing systems to perform analysis and generate reports, using exported data to create pivot tables that summarize information in a clear and presentable way. The role emphasizes the importance of analyzing exported data to assess its reasonableness and quality, ensuring that the information presented is accurate and actionable.

Responsibilities

• Prepare and present financial information for review and approval by leadership.
• Develop solutions to ad-hoc analytical and reporting requests utilizing available tools and technologies.
• Perform analysis on financial and operational issues.
• Analyze financial reports to ensure that they provide meaningful information.
• Demonstrate baseline working knowledge of level appropriate applications and tools.
• Follow standard principles and reporting systems used by CVBC.
• Use appropriate terminology.
• Participate as a team member in a collaborative environment.
• Contribute to completion of department/company goals and objectives.
• Clearly communicate information both to internal and external customers.
• Maintain effective and collaborative relationships with CVBC staff.
• Demonstrate intermediate knowledge of data reporting using established procedures and tools.
• Use Crystal Reports, Excel, and Access to perform the functions of data extraction and reporting.
• Extract data from processing systems to perform analysis and report generation using various databases and data sources.
• Use exported data to generate pivot tables on the exported data to summarize data in a meaningful and presentable way.
• Analyze exported data to determine reasonableness of data and data quality.
• Report and present data to internal and external customers in a user-friendly readable format. Provide recommendations to customers on the data presented.

Requirements

• Bachelor's degree in Business Administration, Accounting, Finance, Health Informatics, or related field.
• 3-5 years related experience.
• Strong ability to rapidly assimilate complex data and make decisions.
• Strive to deliver quality information in a timely manner while handling multiple priorities and deadlines.
• Use of Excel and Access with a skill level of medium to advanced.
• Use of Crystal Reports with a skill level of basic.
• Ability to make presentations to key stakeholders.
• Ability to audit data driven reports for accuracy, recognize anomalous data, and follow through with troubleshooting identified data issues.
• Attention to detail.

Nice-to-haves

• Experience in healthcare analytics or financial analysis within a healthcare setting.
• Familiarity with additional business intelligence tools and software.
• Knowledge of healthcare financial regulations and compliance standards.

Benefits

• Medical, dental, vision, disability, life, and business travel insurance
• Paid time off (vacation & sick leave) - minimum of 12 days per year, accrued at a rate of approximately 1.84 hours per 40 hours worked.
• 401k with up to 6% employer match
• 10 paid holidays per year
• Health savings accounts, healthcare & dependent flexible spending accounts
• Employee Assistance program
• Employee discount program
• Voluntary benefits including pet insurance, legal insurance, accident and critical illness insurance, long term care, elder & childcare, AD&D, auto & home insurance.
• Paid leave in accordance with Colorado's Healthy Families and Workplaces Act for Colorado employees.