LTSS & Dual Eligible Program Report Developer IV

CareSource•Dayton, OH

About The Position

Job Summary: The LTSS & Dual Eligible Report Engineer IV will play a crucial role in utilizing data analytics to drive informed decision-making and optimize business processes within the healthcare environment. This senior-level position is responsible for developing, managing, and analyzing complex data sets, creating actionable insights, and building interactive dashboards to monitor key performance indicators (KPIs). This role requires the ability to work cross-functionally, collaborating with clinical, operational, and IT teams to support the healthcare organization's goals of improving patient outcomes and operational efficiency in the LTSS & Dual Eligible space. Essential Functions: 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
Equivalent years of relevant work experience may be accepted in lieu of required education
Five (5) years of experience working with ETL, BI, and database solutions required
Experience translating business requirements required
Extensive data analysis experience required
Advanced proficiency in data modeling, business intelligence tools, and process optimization strategies
Advanced proficiency with each of the following technologies: 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
Demonstrated ability to create cohesive, strategic plans for developing complex solutions
Strong problem solving and analytical 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
Ability to work independently and in a team environment
Proven ability to influence key decision making across diverse functional areas
Excellent written and verbal communication skills

Nice To Haves

Relevant healthcare or LTSS and/or Dual Eligible reporting experience preferred
Familiarity with LTSS/DSNP data/report regulations preferred
Experience with DevOps and CI/CD is preferred
Relevant certification in one or more of the following or related : Tableau, SQL, SSIS, SSRS, Databricks, Data Engineering, Power BI, Python preferred

Responsibilities

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.