Data Analyst

Kids for the Future; Indianapolis (IN); On-site; USD 70,000 - 110,000; Full time

Job summary

Kids for the Future is seeking a Data Analyst to support data-driven initiatives across state healthcare programs, including Medicaid and Human Services. You will partner with business and technical teams to analyze data and deliver actionable insights that support program outcomes.

The role requires 4+ years with Cognos Analytics and Tableau, strong SQL skills, and experience with Medicaid or government programs.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Mathematics, or a related field, or equivalent experience.
• 4+ years of production-level experience with data and BI tools including IBM Cognos Analytics and Tableau.
• 2+ years of data warehouse analysis experience, reading data flow diagrams and data models.
• 4+ years of SQL experience for reporting and analysis.
• 4+ years of experience with Medicaid, healthcare, or government programs.
• 4+ years in Agile environments or client-facing roles.
• Strong attention to detail and ability to handle complex data sets.
• Excellent written and verbal communication skills.

Responsibilities

• Design, develop, test, maintain, and enhance analytic reports and dashboards using Cognos and Tableau.
• Build ad hoc reports and perform data analysis based on client needs and business questions.
• Develop complex reports with sub-reports and well-formatted deliverables.
• Create and maintain analytics models, packages, and reporting structures.
• Mock up reports and dashboards with business users and refine requirements.
• Collaborate with analysts, data engineers, managers to deliver reporting solutions.
• Suggest insights, report enhancements, and data improvements.
• Monitor and troubleshoot reporting objects to ensure accuracy and timely delivery.
• Validate report results against data warehouse sources during development.
• Support testing activities including UAT and production readiness.
• Communicate findings clearly to technical and non-technical stakeholders.
• Work within a project team and manage assigned work to completion.

Skills

Data analysis

Attention to detail

Communication

Problem solving

Education

Bachelor's degree in Computer Science, Information Systems, Mathematics, or related field

Tools

IBM Cognos Analytics

Tableau

SQL

Cognos Cubes

Python

Excel

Job description

• Location 9365 Counselors Row,Suite 116,Indianapolis, IN, 46240,United States
• Employee Type FT Non-Exempt
• Required Degree 4 Year Degree

Contact information

Description

We are seeking a Data Analyst to support data-driven initiatives across state healthcare programs, including Medicaid and Human Services. This role partners with business and technical teams to analyze data, ensure data quality, and deliver actionable insights that support critical program outcomes.

Key Responsibilities

• Design, develop, test, maintain, and enhance analytic reports and dashboards using Cognos and Tableau.
• Build ad hoc reports and perform data analysis based on evolving client needs and business questions.
• Develop complex reports, including sub-reports, visual reports, and well-formatted deliverables that meet user requirements and present data in a clear, compelling manner.
• Create, enhance, and maintain business analytics models, including relational and DMR models, packages, and reporting structures used for report development.
• Work with business users and technical teams to mock up reports and dashboards, refine requirements, and identify the most effective way to present data to customers.
• Collaborate with business analysts, data engineers, managers, and other team members to design and deliver customer-specific reporting solutions.
• Recommend additional insights, report enhancements, and data improvements based on client needs and analysis findings.
• Support the operational stability of the reporting environment by monitoring, auditing, validating, and troubleshooting reporting objects to ensure accuracy, integrity, and timely delivery.
• Validate report results against data warehouse sources throughout the development process to ensure data quality and consistency.
• Support testing activities, including UAT, validation cycles, and production readiness reviews.
• Communicate findings, report outputs, and analytical insights clearly to both technical and non-technical stakeholders.
• Work within a project team environment, taking direction from project managers and technical leaders while managing assigned work to completion.

Requirements

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Mathematics, or a related field, or equivalent experience.
• 4+ years of production-level experience working with data and business intelligence tools, including IBM Cognos Analytics and Tableau. Experience working with Cognos Cubes, including cube-based reporting and analysis.
• 2+ years of data warehouse analysis experience, including the ability to read data flow diagrams and conceptual and physical data models.
• 4+ years of experience writing SQL for reporting, analysis, and report customization.
• 4+ years of experience with Medicaid, healthcare, or government programs.
• 4+ years of experience working in Agile environments or client-facing roles.
• Strong attention to detail with the ability to work with complex data sets and ensure data accuracy.
• Excellent written and verbal communication skills.

Preferred Qualifications

• Proficiency in Python, including Pandas or similar libraries, and Excel.
• Knowledge of data cleaning, formatting, and transformation techniques.
• Understanding of basic statistics and analytical problem-solving methods.