Business Intelligence Data & Reporting Analyst

Colorado Health Benefit Exchange•Denver, CO

15h•Remote

About The Position

Connect for Health Colorado (C4) is seeking a Business Intelligence Data & Reporting Analyst to support business decision-making through data generation. This role will contribute to the technical and access expansion of C4 BI Analytics, develop and train Power BI viewers and Super-Users, and deliver Board/Management and regulatory reporting. The analyst will also focus on continuous improvements in information management and delivery, collaborating with the BI Data Engineer and BI Developer on BI visualization technologies and Self-Service Information Delivery. A deep understanding of customers, business operations, opportunities, and challenges is expected to develop measures, metrics, reports, and analyses that drive 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).
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

Familiarity with health care and/or insurance industries preferred.

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.