LTSS & Dual Eligible Program Report Developer IV

CareSource; Dayton (KY); Hybrid; USD 94,000 - 165,000; Full time

Benefits offered by this job

Bonus program

Job summary

CareSource is seeking an LTSS & Dual Eligible Report Engineer IV to lead data analytics, develop scalable dashboards, and drive informed decision-making in a healthcare setting. You will partner with clinical, operational, and IT teams to deliver insights that improve patient outcomes and optimize processes.

The role emphasizes complex data modeling, ETL development, and advanced BI tools with a focus on LTSS and Dual Eligible reporting. Strong collaboration and governance are required.

Qualifications

• Bachelor's degree or equivalent in a related field.
• Five+ years of experience with ETL, BI, and database solutions.
• Experience translating business requirements into technical solutions.
• Healthcare or LTSS/DSNP data reporting experience preferred.

Responsibilities

• Generate complex reports and dashboards to track KPIs and metrics for LTSS & Dual programs.
• Develop dynamic dashboards using Tableau/Power BI for stakeholders at all levels.
• Create ETL processes for automated data refreshes and report delivery.
• Collaborate with data engineering to source data from multiple systems.
• Ensure data governance, accuracy, and timeliness across dashboards.

Skills

Data modeling

BI tools

Analytical thinking

Root cause analysis

Communication

Problem solving

Independence

Education

Bachelor's degree in Computer Science/MIS or related

Tools

SQL

SSIS

Power BI

Tableau

SSRS

Databricks

Python

Job description

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.

Education and Experience

Education and Experience: 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 Relevant healthcare or LTSS and/or Dual Eligible reporting experience preferred Familiarity with LTSS/DSNP data/report regulations preferred

Competencies, Knowledge and Skills

• 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
• Experience with DevOps and CI/CD is preferred

Licensure and Certification

• Relevant certification in one or more of the following or related : Tableau, SQL, SSIS, SSRS, Databricks, Data Engineering, Power BI, Python preferred

Working Conditions

General office environment; may be required to sit or stand for extended periods of time Travel is not typically required

Compensation Range

• $94,100.00 - $164,800.00

CareSource takes into consideration a combination of a candidate’s education, training, and experience as well as the position’s scope and complexity, the discretion and latitude required for the role, and other external and internal data when establishing a salary level. In addition to base compensation, you may qualify for a bonus tied to company and individual performance. We are highly invested in every employee’s total well-being and offer a substantial and comprehensive total rewards package.

Compensation Type (hourly/salary): Salary Organization Level Competencies Fostering a Collaborative Workplace Culture Cultivate Partnerships Develop Self and Others Drive Execution Influence Others Pursue Personal Excellence Understand the Business

This job description is not all inclusive. CareSource reserves the right to amend this job description at any time.

CareSource is an Equal Opportunity Employer. We are dedicated to fostering an environment of belonging that welcomes and supports individuals of all backgrounds.

The CareSource mission is known as our heartbeat. Just as we support our members to be the best version of themselves, our employees are driven by our mission to create a better world for members, stakeholders and providers. We are difference-makers who combine compassionate hearts with our unique business expertise to make every opportunity count. Each claim, each phone call, each consumer-centric decision is a chance to change the world for one member, and our employees look for ways to do that every day. The challenge is, there is no one right way to be the difference and we’re looking for people like you that will rewrite that definition every day. We do what it takes to form creative solutions that make our community and the world just a little better. Discover what it means to be #UniquelyCareSource.