Business Intelligence Specialty Analyst - Denver Health Medical Plan (Must Live in Colorado. Weekly On Site Requirement)

Denver Health•Denver, CO

2d•$79,200 - $118,800•Hybrid

About The Position

We are recruiting for a mission-driven Business Intelligence Specialty Analyst - Denver Health Medical Plan (Must Live in Colorado. Weekly On Site Requirement) to join our team! We're with you for life’s journey. At Denver Health, purpose isn’t just something we believe in—it’s something we live every day, for life’s journey. Our Values Respect | Belonging | Accountability | Transparency. This is a hybrid role located in Denver, Colorado with a requirement of being in the office 2 days per week.

Requirements

Must live in Colorado
Bachelor's Degree required
1-3 years of technical experience in health care systems data structures and the business meaning and use of managed care data required
Excellent technical and data related problem solving skills.
Good communication and consultancy skills used to understand and capture business requirements with the ability to work in both a team and individual environments.
Knowledge of software development lifecycle with the ability to lead efforts to create new or modify existing data extracts, reports, and applications.
Microsoft BI toolset using SSIS, SSAS, SSRS, etc.
Strong SQL query and data interrogation skills required.
Sound knowledge of Microsoft office is also needed.

Nice To Haves

experience with managed care products including Medicaid and Medicare, as well as associated business functions for; Claims Processing, Membership Maintenance, Provider Maintenance, Financial Administration, Pharmacy Administration and Care Management is preferred.

Responsibilities

Gather requirements for internal reports and analysis, as well as external vendor data extracts (10%)
Translates requirements into report/extract designs (10%)
Evaluates data sources and technical approaches to satisfy user requirements (10%)
Gains understanding of the source data’s meaning, accuracy, and completeness and how it may affect the report/extract design and business outcomes. (5%)
Documents the solution to include tech specifications, data mappings, and other design documents to be maintained in a common repository (5%)
Codes the solution to meet the agreed upon specifications and performs unit testing of the product. (5%)
Maintains regular communication with end users on design implications, timeline, and solution outcomes (5%)
Coordinates with end-users on the validation and acceptance of the final work product (5%)
Ensures solution is properly tested and promoted to production following standard change management practices (5%)
Creates, maintains and monitors associated job schedules (5%)
Participates as needed in the planning, scoping, design and delivery of project components that are information management specific deliverables. (5%)
Coordinates with business owners, vendors, and project leadership to ensure timelines and outcomes are met. (5%)
Advises project teams on issues and needs as they arise that may affect the project outcomes, making recommendations to address the stated concerns. (5%)
Supports the process of assigning, managing and re-prioritizing project priorities as needed. (5%)
Provides project updates, status, estimates to complete, etc. to support project outcomes. (5%)
Provides technical and administrative support to maintain and administer the BI reporting portal and BI reporting tools (5%)
Oversees the BI reporting change management process. (5%)

Benefits

Generous paid time off, fully paid parental leave, exceptional retirement contributions, comprehensive health coverage, and nationally recognized well-being programs.
Tuition assistance, career advancement pathways, and professional development
Meaningful financial advantages through loan forgiveness eligibility and employer contributions.
Paid time off starting at 28 days per year, inclusive of vacation, personal/sick, and 7 Holidays
100% paid parental leave up to 6 weeks
Immediate eligibility for retirement plans with employer contribution up to 9.5%
Generous medical, dental, vision plans in addition to employer paid disability and life insurance.
Comprehensive well-being programs including on-site employee fitness center located on Denver Health main campus and nationally recognized RESTORE Center
Free RTD EcoPass (public transportation)
Childcare discount programs & exclusive perks on large brands, travel, and more
Tuition reimbursement & assistance
Education, coaching, and professional development opportunities through the Workforce Development Center (WFDC) that support internal career growth and advancement pathways
Professional clinical advancement program & shared governance
Public Service Loan Forgiveness (PSLF) eligible employer+ free student loan coaching and assistance navigating the PSLF program
National Health Service Corps (NHCS) and Colorado Health Service Corps (CHSC) eligible employer