Data Analyst (Medicaid Claims and Encounter Data)

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*

Overview:

We are seeking an experienced Data Analyst to support our NYS client in analyzing and extracting insights from the Medicaid Data warehouse (MDW); run queries on the claims and encounter data . This role requires hands-on experience working within a Medicaid Data Warehouse (MDW) environment. The ideal candidate will have a strong background in healthcare data analytics, particularly claims and encounters, and will be expected to run complex SQL queries and navigate Medicaid-specific data structures.

Duties:

• Query and analyze Medicaid claims and encounter data from the Medicaid Data Warehouse (MDW).
• Write, optimize, and troubleshoot complex SQL queries to extract meaningful data.
• Interpret data trends, anomalies, and key metrics to inform decision-making and operational improvements.
• Collaborate with technical and non-technical stakeholders to present data-driven insights.
• Create and maintain Tableau dashboards or similar visualization tools to display analytical findings.
• Ensure data integrity and consistency across multiple data sources.
• Maintain clear documentation of all queries, processes, and analysis for transparency and reproducibility.

Mandatory Qualifications:

• Bachelor's degree in Data Analytics, Computer Science, Statistics, Public Health, or a related field.
• 4+ years of NYS Medicaid Data Warehouse (MDW) experience.
• 4+ years of experience analyzing healthcare claims and encounter data.
• Strong knowledge of Medicaid data, including common tables, relationships, and reporting metrics.
• Advanced SQL skills with the ability to write and optimize large, complex queries.
• Experience building dashboards with Tableau or similar BI tools.
• Strong communication skills, with the ability to explain complex data concepts to stakeholders.

Desirable Qualifications:

• Experience working with NYS government agencies or healthcare systems.
• Familiarity with ETL processes and data warehousing best practices.
• Exposure to statistical tools or languages like Python or R is a plus.

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.