Report Developer IV, LTSS and Dual Eligible Program

Role Overview

• Generate complex reports and dashboards to track KPIs and metrics related to LTSS & Dual Program reporting impacting patient care, operational efficiency, and financial performance; utilizing statistical methods and machine learning techniques to identify trends, forecast future outcomes, and drive actionable insights
• Design and develop dynamic, user-friendly dashboards using business intelligence tools (e.g., Tableau, Power BI) for stakeholders at various levels of the organization
• Continuously enhance and update dashboards to ensure data relevance, accuracy, and timeliness
• Analyze and evaluate current operations processes to identify opportunities for optimization, cost reduction, Case manager effectiveness and improved patient experience
• Recommend strategies for improving operational efficiency and implementing changes to workflows in alignment with business objectives
• Ensure high levels of data accuracy, integrity, consistency, and completeness through effective data governance practices
• Work closely with data engineering teams to ensure data is sourced and integrated from multiple systems with high reliability
• Develop LTSS & Dual Program reporting solutions that are scalable and include efficient database solutions for supporting reporting functionality
• Work in close collaboration with cross-functional teams to better understand data needs
• Create ETL solutions for automated, scheduled data refreshes and regular report delivery
• Develop and deploy Power BI dashboards which provide leadership with actionable insights that drive critical business decisions
• Transform data sets and quantitative and qualitative analysis into usable and effective data for department leaders to make informed business decisions
• Build complex analytic tools that utilize the data pipeline to provide actionable insights and other key business performance metrics, historical trends or benchmarks
• Identify, design, and implement internal process improvements, automating manual processes, optimizing data delivery
• Perform complex analysis on data to provide insight and address critical business questions
• Transform data analysis and present findings in a consumable, appealing, and impactful executive level format
• Create cohesive, cross-functional strategic plans for developing complex data solutions
• Gather and analyze data, define and document business requirements, recommend technology requirements, review functional specs, and test relevant systems
• Develop, document and perform testing and validation as needed
• Conduct examination, testing activities, and explanation of complex data relationships to answer questions identified by the business/department
• Create, implement and enforce coding standards for the team
• Lead and participate in complex, large-effort data transformation and visualization projects which require cross functional coordination and collaboration across teams
• Performs any other job related duties as requested.

Requirements

• Bachelor's degree in Computer Science, MIS, or related field required
• Five (5) years of experience working with ETL, BI, and database solutions required
• Experience translating business requirements required
• Extensive data analysis experience required
• Relevant healthcare or LTSS and/or Dual Eligible reporting experience preferred
• Familiarity with LTSS/DSNP data/report regulations preferred
• Advanced proficiency in data modeling, business intelligence tools, and process optimization strategies
• Advanced proficiency with SQL, SSIS, and Power BI
• Expert analytical skills in solving multi-dimensional problems and ability to create reports, dashboards, and presentations
• Expert proficiency using Microsoft Excel
• Demonstrated graphic development and strong presentation skills
• High level of skill in building analytic tools that utilize the data pipeline
• Advanced proficiency performing root cause analysis
• Critical listening and thinking skills
• Ability to manage multiple priorities, meet deadlines and produce quality results in a fast-paced environment
• Knowledge of statistical techniques and concepts, AI or ML preferred
• Proven ability to influence key decision-making across diverse functional areas
• Excellent written and verbal communication skills
• Experience with DevOps and CI/CD is preferred

Tech Stack

• ETL
• SQL
• SSIS
• Tableau

Benefits

• in addition to base compensation, you may qualify for a bonus tied to company and individual performance
• substantial and comprehensive total rewards package