Business Intelligence Analyst II - Finance

Business Intelligence Analyst II - Finance

Regency Plaza, 4643 S Ulster Street, Suite 700, Denver, Colorado, United States of America

Job Description

Posted Wednesday, February 4, 2026 at 9:00 AM

The vision of Colorado Access is to have healthy communities transformed by the care that people want at a cost we can all afford. Our mission is to partner with communities and empower people through access to quality, affordable care.

Why should you consider a career with Colorado Access?

We are a Colorado-based company, working to improve the health of our state. We care for individuals, families, and children who receive health care under CHP+ and Health First Colorado (Colorado s Medicaid Program). Our focus is driving improvements in quality, member experience, outcomes, and cost. We are a mission-driven organization whose foundation is built by our vision, supported by our values and pillar ed by diversity, equity and inclusion.

• Find work/life balance:
  We offer PTO, floating holidays, nine company paid holidays, a hybrid work environment, an Employee Assistance Program and a 401K.
• Be a part of something bigger and make an impact:
  We serve the underserved and most vulnerable populations in our community through access to quality and affordable health care. No matter what you do for Colorado Access, you are impacting our community and making a difference.
• Sharpen your skills, learn, and grow:
  We support your continued development through tuition reimbursement, leadership training, promotion opportunities, performance evaluations, employee recognition, and a language pay stipend.

• Partner with Finance and cross-functional stakeholders to understand analytical and reporting needs and deliver accurate, actionable business intelligence solutions.
• Gather, analyze, and document reporting and analytical requirements through research, data analysis, and stakeholder collaboration.
• Translate complex internal and external business intelligence requests into high-quality analytical products using the most credible and efficient data sources.
• Design, develop, and maintain recurring and ad hoc financial and operational reports, dashboards, and analyses using SQL, Power BI, SQL Server Reporting Services (SSRS), and Excel.
• Develop, optimize, and maintain complex SQL queries, stored procedures, and views to extract, transform, and analyze financial, claims, enrollment, capitation, and utilization data.
• Analyze complex datasets to identify trends, variances, risks, and opportunities related to budgeting, forecasting, rate setting, claims billing, cost analysis, and overall financial performance.
• Support rate-setting activities under the guidance of the Manager of Financial Analysis.
• Ensure accuracy, integrity, and consistency of data through validation, reconciliation, and quality assurance processes.
• Identify, document, and assist in resolving data quality issues.
• Identify opportunities to automate reporting processes, improve data workflows, and enhance self-service analytic capabilities.
• Maintain documentation of reports, data sources, business logic, and analytical methodologies.
• In coordination with department management, support designated elements of the Company’s Strategic Plan as identified focus areas for this position.

Education
:
Bachelor’s degree in a healthcare-related area, statistics, computer science, information systems, finance, accounting, or related field. An equivalent combination of experience and/or education may be considered in lieu of a bachelor’s degree.

Experience
:

• A minimum of 2 years’ experience working in a data-focused role, leveraging data to inform business decisions.
• 2 years’ experience with SQL is required with a preference for advanced SQL experience and SQL Server.
• Experience developing reports and dashboards using BI and data visualization tools (e.g., Power BI, SSRS, Excel, Business Objects, or similar platforms) is required.
• A background in healthcare or finance is a plus.

Knowledge, Skills, and Abilities
:

• Ability to analyze and interpret complex data patterns and trends.
• Strong analytical, problem-solving, and critical-thinking abilities, with attention to…