CSpring

• Design and develop reusable, parameter-driven ingestion and transformation pipelines • Build and maintain medallion architecture solutions • Develop performant ELT workflows • Create and optimize PySpark notebooks and distributed processing jobs • Design dimensional data models • Implement data vault patterns • Optimize distributed SQL workloads • Implement CI/CD processes • Build monitoring, logging, and auditing solutions • Lead or contribute to cloud modernization initiatives

• Review and process prescription prior authorization and appeal requests • Organize and manage documents, verify profiles, and ensure accuracy for patient/member records • Use decision trees and protocols to evaluate requests and provide approvals or rationales for denials • Communicate decisions and updates to patients and providers, ensuring they feel supported • Forward complex cases for additional review and follow up as needed • Provide compassionate, timely support while staying organized and detail focused

Role Description At CSpring, we believe in the power of people and data to drive real-world impact. We’re a purpose-driven consulting firm that helps organizations solve complex problems, gain insights, and achieve measurable results. Our clients span the public and private sectors, and our work — from data strategy and engineering to workforce transformation — improves lives across Indiana and beyond. We’re seeking talented professionals who are collaborative, curious, and committed to making a difference. - Engage with business and technical stakeholders to gather, analyze, document, define, and standardize business/data requirements (2%). - Perform or lead Gap Analysis between as-is and to-be systems to identify shortcomings (5%). - Develop and maintain documentation including requirement specifications, RTMs, acceptance criteria, process flows, and data mapping documents, using SharePoint and Confluence for version control and collaboration (2%). - Design, develop, and optimize complex data models and validation frameworks using SQL and Teradata (5%). - Perform/conduct comprehensive root cause analysis for data quality issues and develop/implement solutions or automated preventive controls (5%). - Represent the State/organization in interactions with the CMS federal team (alongside manager or as lead SME), addressing queries and serving as subject matter expert on CMS reporting standards (5%). - Oversee or ensure timely, accurate, error-free, and compliant submission of monthly extracts and quarterly CMS reports (claims, provider, eligibility, CMS-64.9 forms) (5%). - Lead enterprise level analytical initiatives supporting CMS reporting systems and Indiana healthcare programs (5%). - Conduct advanced data analysis, modeling, and automation using Excel (Power Query, Power Pivot, VBA macros, complex formulas, dynamic arrays, and scenario modeling) (10%). - Develop and maintain interactive dashboards and visualizations using Tableau and Power BI to identify trends, anomalies, compliance risks, and key performance metrics for executive and federal reporting (7%). - Define and implement enterprise data quality governance frameworks, KPIs, automated validation rules, and monitoring systems (5%). - Lead and coordinate complex testing/QA/UAT activities by establishing strategies, overseeing execution, and reviewing test cases prepared by junior analysts (5%). - Provide mentorship and technical leadership to junior analysts on advanced SQL, Informatica ETL, Power BI/Tableau development, and CMS processes (10%). - Recommend and drive implementation of process enhancements, tool upgrades, and automation initiatives for efficiency and compliance (10%). - Manage and analyze Treatment Episode Data Set (TEDS) Admission and Discharge data submissions for the Division of Mental Health and Addiction (DMHA) (4%). - Collaborate with the CMS State Support Team to analyze, document, and implement TMSIS (Transformed Medicaid Statistical Information System) updates and changes required by CMS (4%). - Research, interpret, and ensure application of HHS/CMS rules and regulations to maintain ongoing compliance with Indiana Medicaid/Medicare systems (7%). - Coordinate with the State Board of Accounts (SBOA) to design and deliver customized annual data extracts for audits and financial reporting, using automated workflows and secure transmission processes (4%). - Remote work requests will be considered consistent with company’s remote work policy. - Domestic travel required less than 2% of the time. Qualifications - Bachelor’s degree in Computer Science, Information Systems, Systems Engineering, or a related field, or foreign equivalent. - 7 years of relevant experience in data analysis, systems analysis, quality assurance, and CMS data reporting and compliance in the Business Systems Analyst or relevant position. Requirements - 7 years of experience with handling multiple projects/workstreams simultaneously. - 7 years of experience defining and executing test strategies, UAT, and QA methodologies. - 7 years of experience with Agile and Waterfall software development methodologies. - 7 years of experience using JIRA, Zephyr, and comparable tools for project tracking and test management. - 7 years of experience in SQL and Teradata for data extraction, modeling, and validation. - 7 years of experience developing data dashboards and analytical reports using Tableau and comparable BI tools. - 5 years of experience utilizing data quality frameworks and data governance best practices. - 5 years of experience with Medicaid including CMS reporting compliance experience. - Will accept any suitable combination of education, training, and experience. Benefits - At CSpring, we unlock the potential of people and data. - If you’re ready to lead meaningful work, collaborate with passionate teams, and grow your career in a people-first consulting environment — apply today!

• You'll own the quality of data as it moves through ETL pipelines in a state Medicaid environment — from reviewing requirements all the way through defect resolution, regression testing, and automation. • Review Change Requests (CRs) and participate in requirement analysis for new EDW extracts and transformations. • Participate in data modeling and requirement gathering sessions to ensure testing stays aligned with business needs. • Perform backend testing to compare data in source systems to target Medicaid Enterprise Data Warehouses (EDW); verify source-to-target data mapping and transformation logic for Medicaid datasets. • Validate data quality, standardization rules, and loading accuracy across full-load and incremental-load cycles. • Write complex SQL queries — multi-table JOINs, aggregations, row counts, null checks, duplicate checks, and referential integrity validation — to validate ETL outputs against business rules. • Design test plans, test cases, and test scenarios for ETL processes; execute both manual and automated tests. • Identify, document, and track discrepancies using JIRA, HP ALM, or Azure DevOps Test Plans; collaborate with ETL developers to resolve defects and perform regression testing. • Develop automated database validation scripts using Python, SQLAlchemy, and Pandas; create shell scripts for ETL monitoring and log analysis. • Integrate test automation into CI/CD pipelines in Azure DevOps. • Document test results and provide detailed, actionable feedback to stakeholders.

• You'll design and maintain the data infrastructure that powers enterprise analytics and federal reporting for some of the nation's most critical public health programs. • Design, develop, and maintain enterprise ETL pipelines using Azure Data Factory (ADF), Informatica PowerCenter, and Python-based frameworks. • Build and optimize scalable data processing solutions using Python, Spark, and Databricks. • Support Medicaid analytics and federal reporting initiatives including T-MSIS, PERM, MARS, and Quality of Care programs. • Develop robust data validation, reconciliation, and audit-traceable pipelines that hold up under regulatory scrutiny. • Write and optimize SQL and stored procedures across relational platforms including Snowflake, Oracle, and SQL Server. • Participate in cloud migration and modernization initiatives within Azure-based architectures, bridging legacy and modern platforms. • Collaborate closely with analysts, QA engineers, and BI reporting teams to make sure data is accurate, timely, and trustworthy at every stage. • Participate in code reviews, source control, and CI/CD processes using Azure DevOps and GitHub.

• Be the hands-on technical lead for dashboard, reporting, and data engineering work within a large-scale Medicaid EDW and analytics program. • Design, develop, and maintain enterprise-level dashboards and reports using Tableau and Python-based frameworks, ensuring they're performant, reusable, and built to last. • Build and optimize scalable data processing pipelines using Python, supporting both ongoing analytics needs and federal reporting requirements. • Write and tune SQL and stored procedures across relational platforms — primarily Teradata — with a focus on accuracy and efficiency at enterprise scale. • Support Medicaid analytics and federal reporting initiatives including T-MSIS, PERM, MARS, and Quality of Care programs, working closely with SMEs and compliance teams. • Participate in cloud migration and modernization work within Azure-based architectures, contributing to the shift from legacy systems toward modern platforms. • Collaborate with analysts, QA teams, and BI reporting leads to validate data quality, resolve discrepancies, and ensure timely delivery of reporting deliverables. • Support production operations — including incident response and root-cause analysis — and contribute to a stable, reliable analytics environment. • Participate in code reviews, maintain source control hygiene, and work within CI/CD processes using Azure DevOps and GitHub.

Description At CSpring, we believe in unlocking potential—whether it’s for our clients, colleagues, or the communities we serve. We’re not just a consulting firm; we’re a team that values connection, growth, and purpose. If you’re looking for a role that combines your expertise with the opportunity to make a real impact, we’d love to have you join us! We are currently seeking a Pharmacy Technician to support our Medicaid Pharmacy Customer Service Team. In this fully remote role, you’ll deliver advanced inbound customer service to Indiana Medicaid members and providers, addressing inquiries about pharmacy coverage, claims, and medication pricing. You'll be the expert they trust to navigate their pharmacy needs. What You’ll Do - Review and process prescription prior authorization and appeal requests. - Organize and manage documents, verify profiles, and ensure accuracy for patient/member records. - Use decision trees and protocols to evaluate requests and provide approvals or rationales for denials. - Communicate decisions and updates to patients and providers, ensuring they feel supported. - Forward complex cases for additional review and follow up as needed. - Provide compassionate, timely support while staying organized and detail focused. Requirements What We’re Looking For - A valid Indiana Pharmacy Technician license. - A valid national CPhT certification (or ability to obtain within six months of hire). - High school diploma - 1–2 years of pharmacy experience (retail, LTC, hospital, etc.). - Proficiency in software systems, data entry, and the Microsoft Office suite. - Strong organizational and time management skills. - Excellent customer service and communication abilities. - A team player with a positive attitude who embodies our core values: Committed, Collaborative, Consultative, Caring. - Ability to work overtime as needed, pass background checks and pre-employment drug screen, and complete E-Verify requirements. - Must have access to a quiet, distraction-free workspace. Preferred Qualifications - Experience with Medicaid and/or government healthcare programs. - Previous experience in a remote work environment. - Call center or inbound/outbound call experience in a pharmacy setting. Why Join CSpring? At CSpring, we’re more than just a workplace—we’re a community. As part of our team, you’ll experience: - A strong culture of connection and collaboration. Enjoy team-building events with colleagues who support and inspire you. - Recognition and growth opportunities. Your hard work won’t go unnoticed; we value and reward our team members. - Outstanding benefits from day one. Comprehensive medical, dental, vision, life, and disability insurance, along with Paid Time Off and a 401(k) with company match. As a Best Place to Work award winner year after year, we pride ourselves on creating an environment where every team member feels respected, valued, and inspired to succeed. Ready to grow your career, help others, and be part of an incredible team? We can’t wait to hear from you! Apply today to become a part of the CSpring team and make a meaningful difference every day.

• CSpring is looking for a Quality Engineer who brings both technical depth and a quality-first mindset to modern data and application environments. • In this role, you will help ensure the reliability, performance, and integrity of critical systems by designing thoughtful test strategies, executing manual and automated testing, and partnering closely with cross-functional teams throughout the development lifecycle. • This is an ideal opportunity for someone who thrives in complex environments, enjoys solving technical problems, and wants to play a meaningful role in delivering high-quality solutions across data platforms, applications, and integrations. • As a Quality Engineer, you will be a key contributor to product and platform quality from requirements through release. • You will work across functional, integration, regression, and end-to-end testing efforts while helping teams strengthen quality engineering practices in Agile and CI/CD environments. • Participate in walkthroughs, inspections, reviews, and user group meetings to support quality assurance activities across the delivery lifecycle. • Develop, maintain, and prioritize comprehensive test cases and testing plans. • Execute test cases, identify and document defects, and clearly communicate severity and priority. • Perform regression testing after code changes to ensure fixes do not create downstream issues. • Build strong system and application knowledge to improve testing quality, accuracy, and coverage. • Design, develop, and implement automated tests using BDD/TestNG approaches. • Create and execute automated tests using Selenium, Cucumber, and Java in alignment with enterprise development and operational standards. • Embed quality engineering practices within CI/CD pipelines, including version control, test management, and automation framework integration. • Conduct functional, integration, regression, system, and end-to-end testing. • Partner with scrum teams during user story grooming to help define clear, testable acceptance criteria. • Take ownership of quality outcomes and communicate effectively with business sponsors, project leaders, and technical teams. • Document test results and validate that business and technical requirements are fully met. • Ensure compatibility with existing product functionality and integration points across product lines. • Apply knowledge of Bronze/Silver/Gold data architecture in modern data platforms such as Databricks, Snowflake, and Azure Synapse. • Leverage AI-enabled testing tools to generate test data, auto-generate test cases from requirements or user stories, and enhance API testing through intelligent validation and recommendations.

Description At CSpring, we believe in unlocking potential—whether it’s for our clients, colleagues, or the communities we serve. We’re not just a consulting firm; we’re a team that values connection, growth, and purpose. If you’re looking for a role that combines your expertise with the opportunity to make a real impact, we’d love to have you join us! We are currently seeking a Pharmacy Technician to support our Medicaid Pharmacy Customer Service Team. In this fully remote role, you’ll deliver advanced inbound customer service to Indiana Medicaid members and providers, addressing inquiries about pharmacy coverage, claims, and medication pricing. You'll be the expert they trust to navigate their pharmacy needs. What You’ll Do - Review and process prescription prior authorization and appeal requests. - Organize and manage documents, verify profiles, and ensure accuracy for patient/member records. - Use decision trees and protocols to evaluate requests and provide approvals or rationales for denials. - Communicate decisions and updates to patients and providers, ensuring they feel supported. - Forward complex cases for additional review and follow up as needed. - Provide compassionate, timely support while staying organized and detail focused. Requirements What We’re Looking For - A valid Indiana Pharmacy Technician license. - A valid national CPhT certification (or ability to obtain within six months of hire). - High school diploma - 1–2 years of pharmacy experience (retail, LTC, hospital, etc.). - Proficiency in software systems, data entry, and the Microsoft Office suite. - Strong organizational and time management skills. - Excellent customer service and communication abilities. - A team player with a positive attitude who embodies our core values: Committed, Collaborative, Consultative, Caring. - Ability to work overtime as needed, pass background checks and pre-employment drug screen, and complete E-Verify requirements. - Must have access to a quiet, distraction-free workspace. Preferred Qualifications - Experience with Medicaid and/or government healthcare programs. - Previous experience in a remote work environment. - Call center or inbound/outbound call experience in a pharmacy setting. Why Join CSpring? At CSpring, we’re more than just a workplace—we’re a community. As part of our team, you’ll experience: - A strong culture of connection and collaboration. Enjoy team-building events with colleagues who support and inspire you. - Recognition and growth opportunities. Your hard work won’t go unnoticed; we value and reward our team members. - Outstanding benefits from day one. Comprehensive medical, dental, vision, life, and disability insurance, along with Paid Time Off and a 401(k) with company match. As a Best Place to Work award winner year after year, we pride ourselves on creating an environment where every team member feels respected, valued, and inspired to succeed. Ready to grow your career, help others, and be part of an incredible team? We can’t wait to hear from you! Apply today to become a part of the CSpring team and make a meaningful difference every day.