Data Analytics Analyst II at Denver Health in Denver, CO

DATA ANALYTICS ANALYST II Location: Administrative Offices - 601 Broadway, Denver, CO 80203 We are recruiting for a mission-driven Data Analytics Analyst II 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 Department Information Technology Job Summary This position specifically supports the IT Data and Analytics team with a focus in Epic Cogito Reporting Suite and third-party data integration. Additionally, the ideal candidate will have knowledge of core Business Intelligence/Data Warehousing technologies including Microsoft SQL Server and/or Epic reporting tools include RW/Radar/SlicerDicer. Reporting/Analytics experience is preferred. Strong analytical and problem-solving skills and ability to interpret results of query analysis. Under general direction, the Data Analytics Analyst II is an Epic certified or proficient individual, who is responsible for the support, analysis, design, build, configuration, implementation, workflow documentation, and educational support of the assigned Epic application or third-party software, in alignment with organization's policies, procedures, and business operations. Is knowledgeable about Epic or healthcare IT system functions. Readily displays the ability to diagnose issues, identify appropriate resources and escalations, and propose creative solutions to complex problems. Understands the functions and processes of key customer departments and can coordinate and communicate effectively with a variety of stakeholder groups. Can function independently at the level that will allow them to participate in the 24x7 on-call rotation and coordinate and deliver team level project requests. Works with the objective of delivering elegant solutions that are intuitive, empowering, efficient, scalable, sustainable, systems focused, and foundation based. Maximizes use of Epic foundation functionality to enhance user experience, limiting custom solutions when foundation tools are available. Uses analytics to drive workflow changes and process decision. Develops measurements and tools for monitoring value and success of system changes. Facilitates a handoff of monitoring value and success to operations. We strive to maintain a 90% Epic enhancement adoption rate. Essential Functions: • General • Plans and organizes time effectively. • Meet with application analysts and report consumers to understand their workflow and reporting needs; work with end users to provide key insights and results analysis for proper data interpretation. • Participates and guides the phases of system changes, including design, build, testing, documentation and education. Create design specifications for new reports / datasets; identify and validate the appropriate technological solutions for various reporting needs. Creates new reports/data solutions using vendor supplied reporting tools and/or modify existing reports/data solutions as necessary. • Review upgrade documentation related to Reporting Workbench/Radar features and released reporting content and determine how to implement the changes. • Complies with department processes for change management and risk mitigation. Using tools such as Epic Content Management, Data Courier, and other department tools. • Learn and implement new reporting tools as needed and determined by the vendor and / or the enterprise. • Reporting Workbench administration including template creation for Chronicles sourced data and development of more complex Reporting Workbench reports / Radar dashboards • Deliver data via standard reporting tools, ie CSV, Excel and SlicerDicer custom development. • Ability to research and troubleshoot reporting content functionality to ensure data is accurate and daily processing has been completed. • Communicates with team, stakeholders and vendors to discuss the status of issues, trends, deliverables, end-user concerns, and anticipated milestones. Provides feedback to vendors on existing functionality and desired new / modified functionality to enhance overall system capabilities. • Maintains and reviews the status of projects and escalates issues and risks on an ongoing basis with leadership. • Follows standard work for documentation of all solutions ensuring consistent deliverable and reusable solutions • Actively reviews and responds to vendor, enterprise, and team correspondence. • Makes use of IT and enterprise problem/request tracking tools. Keeps current documentation on all assigned tasks. Completes work status and time allocation documentation as required. • Work with training staff to ensure documentation and training materials are in line with delivered solutions. • Makes formal and informal presentations to leadership and end users both orally and in writing. • Participates in Epic team integrated workgroup(s). (40%) • Provide primary support to End-users • Break/fix support- provides troubleshooting and data validation when data integrity issues arise with existing reports • Identify reoccurring issues or weaknesses, and proactively document solutions to expedite issue resolution. • Standing maintenance tasks such as, managing and acting on error reports, work queues, and other notifications. (30%) • Service Requests/Projects • Follow established processes to complete service requests. • Meets with end users and/or application analysts to understand workflow and specifications to develop new reporting content and determine best delivery method • Leads or participates in the evaluation, solution analysis, prioritization, and delivery of changes to existing system or workflows. Evaluates and presents feasibility, effort and timelines required to complete customer requests. • Create and execute project plans - defining deliverables, developing and managing schedule, task identification and ownership, and overall status tracking. • Maintains regular communication with project team members and leadership as role dictates. (30%) Education: • Associate's Degree required. • In lieu of degree, High School Diploma or GED and (4) years Epic application support experience required. Work Experience: • 2+ years working with core Business Intelligence/Data Warehousing technologies including Microsoft SQL Server or Epic reporting tools include RW/Radar/SlicerDicer required. Knowledge, Skills and Abilities: • Demonstrates data literacy with strong analytical and problem-solving skills; the ability to prepare and transform raw data to deliver insights. • Ability to adapt and excel in an evolving technical environment; identifies and validates the appropriate solution to meet various needs. • Understands analytics and application environment capabilities, and limitations in supporting various workflow and process requirements of the enterprise. • Demonstrates strong ability to identify, analyze, and solve problems. Can use analytical reasoning to determine root causes, define the problem, generate solutions, and implement the best option. • Communicates in a way that builds relationships and fosters collaborative work. Tailors the mode and content of communication to both technical and non-technical colleagues in and outside of the organization. • Displays high level of initiative, including the ability and willingness to take ownership of work, recognize assignments or tasks that need to be completed, seek out additional assignments or tasks, and help others. • Exceptional organizational skills with an ability to handle multiple efforts of varying priority, demonstrating flexibility with respect to changing organizational needs. Ability to work both independently and as part of a team to accomplish goals. • Business analysis skills to identify data solutions by interviewing business users, analyzing processes/operations, establishing solution objectives, prototyping solution, and preparing specifications. • Intermediate SQL skills and strong understanding of relational and dimensional database concepts, including primary keys, foreign keys, and joins. Proficiency and demonstrated experience with report writing and data visualization tools. • Experience with healthcare clinical operations and / or healthcare financial workflows preferred. For financial reporting: prior experience working with an A/R system is desirable. For clinical reporting: prior experience working with an EMR system is desirable. • Supports Denver Health’s mission, values, and vision of growing alongside the community to become a complete health care system, proudly providing care for all residents -- at every point in their lives. • Minimum Intermediate skills in Microsoft office suite • Intermediate SQL Skills • Experience with developing reporting content out of Cogito suite including: RW/Radar/SlicerDicer and/or data visualization tools like Tableau Shift Days (United States of America) Work Type Regular Salary $83,100.00 - $128,800.00 / yr Benefits At Denver Health, we take care of the people who take care of our community. Our benefits are built to support your life, your family, and your future — with generous paid time off, fully paid parental leave, exceptional retirement contributions, comprehensive health coverage, and nationally recognized well-being programs. We invest in your growth through tuition assistance, career advancement pathways, and professional development — while also offering meaningful financial advantages through loan forgiveness eligibility and employer contributions. When you join Denver Health, you’re joining a mission-driven organization that invests in you. Here is a small list of our benefit programs: • 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 About Denver Health Denver Health is an integrated, high-quality academic healthcare system considered a model for the nation that includes a Level I Trauma Center, a 555-bed acute care medical center, Denver’s 911 emergency medical response system, 10 family health centers, 19 school-based health centers, Rocky Mountain Poison & Drug Safety, the Public Health Institute at Denver Health, Denver Health Medical Plan and Denver Health Foundation. As Colorado’s primary, and essential, safety-net healthcare system, Denver Health is a mission-driven organization that has provided millions in uncompensated care for the uninsured each year. Located near downtown Denver, Denver Health is just minutes away from many of the cultural and recreational activities Denver has to offer. Denver Health is an equal opportunity employer (EOE). We value the unique ideas, talents and contributions reflective of the needs of our community. All job applicants for safety-sensitive positions must pass a pre-employment drug test, once a conditional offer of employment has been made. Applicants will be considered until the position is filled.