Business Intelligence Analyst I- Finance

Colorado Access is a Colorado-based company focused on improving the health of communities through access to quality, affordable care. They are seeking a Business Intelligence Analyst I- Finance to partner with Finance and cross-functional stakeholders to develop actionable business intelligence solutions and maintain financial reports and analyses. Responsibilities - Partner with Finance and cross-functional stakeholders to transform low to moderate level business requests into accurate and actionable business intelligence solutions - Develop a foundational understanding of managed care, internal financial and operational data, and Colorado Access’s key performance drivers - 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 and maintain moderately complex SQL queries to extract and analyze financial, claims, enrollment, capitation, and utilization data - Identify actionable insights through data analysis, research, and interpretation. Provides a summary of trends, observations, and actionable items on standard and ad hoc requests - Ensure accuracy, integrity, and consistency of data through validation, reconciliation, and quality assurance processes - Identify, document, and assist in resolving data quality issues - Assist in automating reporting processes and improving data workflows - 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 Skills - Bachelor's degree in healthcare-related field, statistics, computer science, information systems, finance, accounting, or related field - Equivalent combination of experience and/or education may be considered in lieu of a bachelor's degree - Experience with SQL, including writing and modifying queries to retrieve and analyze data - Foundational understanding of relational databases, such as SQL Server - Exposure to BI and data visualization tools (e.g., Power BI, SSRS, Excel, Business Objects, or similar platforms) - Experience with healthcare or behavioral health data is a plus - Proficiency with Microsoft Office applications, including Word, Excel, PowerPoint, Outlook, and Teams - Ability to analyze and interpret complex data patterns and trends - Strong analytical, problem-solving, and critical-thinking abilities, with attention to detail and data accuracy - Excellent written and verbal communication skills, capable of translating complex business questions into clear requirements and effective data solutions - Must have strong interpersonal and teamwork skills, supported by good organizational and time management - Ability to manage multiple priorities and projects with tight deadlines - General understanding of health benefits, medical terminology, medical procedures, and the managed care industry is a plus - Familiarity with CPT, ICD and other medical coding systems is a plus - A valid driver's license and proof of current auto insurance will be required for any position requiring driving Benefits - Medical, dental, vision insurance that starts the first day of the month following start date. - Supplemental insurance such as critical illness and accidental injury. - Health care and dependent care flexible spending account options. - Employer-paid basic life insurance and AD&D (employee, spouse and dependent). - Short-term and long-term disability coverage. - Voluntary life insurance (employee, spouse, dependent). - Paid time off - Retirement plan - Tuition reimbursement (based on eligibility). - Annual bonus program (based on eligibility, requirements and performance). Company Overview - Colorado Access are a nonprofit health plan that provides access to behavioral and physical health services for Coloradans. It was founded in 1994, and is headquartered in Denver, Colorado, USA, with a workforce of 201-500 employees. Its website is https://www.coaccess.com.