Job description

Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things.  *This is an exempt position. Salary commensurate with experience* Job Title: Reports Developer – Integrated Eligibility Systems Location: Albany, NY (Hybrid)/ Lake Mary, FL (4 month project) Duration: 6 Months (with potential for extension) W2 Hourly Rate: $35-$40/hour Application Deadline: 9/21/2026 Overview: We are seeking a Reports Developer – Integrated Eligibility Systems who will support our NYS client. This role supports reporting and analytics for Non-MAGI Medicaid, Medicare Savings Program (MSP), and Integrated Eligibility systems, including federal, state, and program-level reporting. The consultant will develop complex SQL, reporting solutions, and dashboards; validate reporting accuracy and compliance; and lead coordination across business, policy, QA, and development teams. The engagement is hybrid and includes a four-month project assignment in Lake Mary, Florida, with a 4–6 week relocation window after project start. Duties: • Write, tune, and troubleshoot complex SQL queries against eligibility, benefits, and case management data, including SNAP, TANF, and Childcare data. • Design, develop, and maintain operational, compliance, and federal/state reports for Integrated Eligibility programs. • Translate business and policy requirements into technical report specifications in coordination with program, policy, and QA teams. • Build and maintain dashboards and visualizations to support caseworker, program manager, and executive reporting needs. • Validate report outputs against source systems and business rules to ensure data accuracy and regulatory compliance. • Optimize report and query performance through indexing, query tuning, and data model recommendations. • Support UAT and defect triage for reporting deliverables, document issues, and coordinate fixes with the development team. • Maintain report documentation, data dictionaries, and mappings of eligibility rules to reporting logic. • Mentor junior report developers and analysts, review SQL and report designs, and help lead reporting workstream priorities, timelines, and cross-functional coordination. Mandatory Qualifications: • 3+ years of experience as a Reports Developer with direct experience supporting Non-MAGI Medicaid, Medicare Savings Program (MSP), and Integrated Eligibility systems. • 2–5 years of Java experience. • 2–5 years of SQL experience, with strong hands-on ability to write, tune, and troubleshoot complex SQL queries. • 2–5 years of Java Spring experience. • Solid understanding of Integrated Eligibility systems. • Ability to lead a reporting workstream, including managing priorities, timelines, and coordination with cross-functional teams. Desirable Qualifications: • Tableau development experience, including dashboard design, calculated fields, data blending, publishing, and administration. • Experience reporting from Databricks, SQL Server, Oracle, or similar enterprise data platforms. • Familiarity with federal reporting requirements. • Exposure to ETL and data pipeline tools supporting reporting data marts. What We Offer: Opportunities to lead impactful transformations in the public sector infrastructure. Engagement with high-profile government initiatives, supporting meaningful change. Professional development through exposure to innovative Agile practices and leadership collaboration. A collaborative environment that values ownership, initiative, and continuous learning. Ready to make a difference? Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws. AI-Assisted Resume Evaluation Notice Cloud and Things – Talent Management Notice to Candidates Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals. How AI Is Used Our AI tools assist by: Analyzing resumes against job requirements Supporting our recruiters in candidate data evaluation Ensuring consistent review standards across all applications Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation. Your Data and Privacy Cloud and Things Data Handling: Your information is processed securely and used exclusively for recruitment purposes Cloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunities You may opt out of long-term ATS storage by emailing your name and your request to opt out of storing your resume in the ATS to: security@cloudandthings.com All personal information is handled confidentially in accordance with our privacy policy AI Tool Data Processing: AI processing data is retained for a maximum of 90 days, after which it is deleted All data sent to AI tools is encrypted in transit and at rest AI tools comply with applicable privacy laws including GDPR and CCPA Personal data is anonymized or minimized wherever possible during AI processing Your Participation By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration.

Requirements

Must-haves

This is an exempt position. Salary commensurate with experience*
Job Title: Reports Developer – Integrated Eligibility Systems
Location: Albany, NY (Hybrid)/ Lake Mary, FL (4 month project)
Duration: 6 Months (with potential for extension)
W2 Hourly Rate: $35-$40/hour
Application Deadline: 9/21/2026
We are seeking a Reports Developer – Integrated Eligibility Systems who will support our NYS client.
Write, tune, and troubleshoot complex SQL queries against eligibility, benefits, and case management data, including SNAP, TANF, and Childcare data.
Design, develop, and maintain operational, compliance, and federal/state reports for Integrated Eligibility programs.
Translate business and policy requirements into technical report specifications in coordination with program, policy, and QA teams.
Build and maintain dashboards and visualizations to support caseworker, program manager, and executive reporting needs.
Validate report outputs against source systems and business rules to ensure data accuracy and regulatory compliance.
Optimize report and query performance through indexing, query tuning, and data model recommendations.
Support UAT and defect triage for reporting deliverables, document issues, and coordinate fixes with the development team.
Maintain report documentation, data dictionaries, and mappings of eligibility rules to reporting logic.
Mentor junior report developers and analysts, review SQL and report designs, and help lead reporting workstream priorities, timelines, and cross-functional coordination.
3+ years of experience as a Reports Developer with direct experience supporting Non-MAGI Medicaid, Medicare Savings Program (MSP), and Integrated Eligibility systems.
2–5 years of Java experience.
2–5 years of SQL experience, with strong hands-on ability to write, tune, and troubleshoot complex SQL queries.
2–5 years of Java Spring experience.
Solid understanding of Integrated Eligibility systems.
Ability to lead a reporting workstream, including managing priorities, timelines, and coordination with cross-functional teams.
Tableau development experience, including dashboard design, calculated fields, data blending, publishing, and administration.
Experience reporting from Databricks, SQL Server, Oracle, or similar enterprise data platforms.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqljavaagileairest

Platform: bullhorn
Effort: medium

Benefits

Benefits detected in the listing.

Professional Development