Business Intelligence Data & Reporting Analyst

Connect for Health Colorado•Denver, CO

1d•$72,100 - $94,760•Hybrid

About The Position

Connect for Health Colorado is a public, non-profit entity established by the Colorado General Assembly in 2011 to create a health insurance Marketplace. Since 2013, we’ve been helping individuals, families and small employers compare plans, apply for financial help and buy health insurance. As Colorado’s official health insurance marketplace, we are the only place to apply for financial help to lower the monthly cost of premiums. Customers can shop online; get help by phone or online chat from Customer Service Center representatives; and access expert help from a statewide network of certified Brokers and community-based Assisters. Our mission is to increase access, affordability, and choice for individuals and small employers purchasing health insurance in Colorado. This role will work with the BI Data Engineer and BI Developer to implement improvements for BI visualization technologies and Self-Service Information Delivery. They will develop deep understanding of customers, business operations, opportunities, and challenges to develop measures, metrics, reports, and analyses that lead to measurable improvements.

Requirements

Colorado resident.
Undergraduate degree in business information & analytics, business intelligence, statistics & data science, data visualization, or related field and/or equivalent years of work experience.
2-3 years track record of applying analytics to improve business results.
2-3 years proven track record to manage priorities and consistently meet deadlines using Agile practices (Kanban, JIRA), including creating and maintaining relevant documentation.
2-3 years of developing reports based on complex data models and working with structured and unstructured data.
2-3 years of experience with SQL (Snowflake).
3-4 years of experience with Power BI, Power Automate, MS Office Suite.
3-4 years of experience writing M and DAX for Power BI and VBA for Excel; experience with DAX Optimizer a plus.
3-4 years of experience with JSON, Python or R, and excellent data analysis and quantitation skills.
Familiarity with current cloud-based BI architectures (AWS experience is a plus), including the use of Cloudflare, PuTTY or similar.
Skilled in proactively collaborating with team members to create and maintain BI data dictionaries, data models and other critical documentation.
Familiarity with general ETL/ELT capabilities (processes and tools).
Familiarity with health care and/or insurance industries preferred.
This position requires an individual with a strong work ethic, good collaboration and communication skills, a strong analytical background, and the ability to produce quality work in a fast-paced environment with tight deadlines.

Nice To Haves

AWS experience is a plus
experience with DAX Optimizer a plus

Responsibilities

Creation and Management of Enterprise-Level Reporting Models
Ensure compliance with data management policies and procedures, including information security, data governance & distribution and retention/destruction.
Document, maintain, and execute BI reporting model life cycle processes and data/measure definitions.
Consistently and efficiently perform testing on data results for new initiatives as well as current processes, including optimizing reporting models.
Customer Communication: Ensure customer has clear understanding of the report/analysis and communicate results and opportunities clearly and accurately.
Delivery/Certification of Enterprise-Level Reporting
Design and build public-facing, Self-Service data lookup capabilities for use by regulators and external data analysts.
Provide ad hoc Self-Service reporting with analytical reasoning to produce information to solve business problems.
Ensure reports and extracts comply with design and coding standards.
Data Integrity: As needed, update Self-Service recurring and non-recurring reports for accuracy and reasonableness.
Implement operational and strategic reports as assigned, including summaries, drilldowns, filters, groupings, organization, and data presentation through the analysis, design, testing, and delivery of BI Self-Service visualizations, reports, and extracts.
Ensure BI certification processes are followed.
Enable C4 Analysts to access and appropriately use Enterprise-Level Models
Support the business in meeting their information needs.
Collaborate with team members to ensure best practices to approach/delivery.
Provide training and access to models and new functionality.