Note: The job is a remote job and is open to candidates in USA. Connect for Health Colorado is a public, non-profit entity established to create a health insurance Marketplace. The Business Intelligence Data & Reporting Analyst will generate information to support business decision-making, enhance BI analytics, deliver reporting, and implement improvements for BI visualization technologies.
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
Skills
- 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
- Familiarity with health care and/or insurance industries preferred
Benefits
- Connect for Health Colorado offers a competitive benefits package.
- Employees are offered a robust benefits package and may elect from various offerings to tailor a package best suited to their individual needs.
- Connect for Health Colorado employees are eligible to participate in the organizations 403(b) plan
- Paid time off
- Short- and long-term disability
- Life insurance
Company Overview