Consultant- Data Analyst
The Consultant - Data Analyst at Confidential Client supports the Social Adult Day Care Compliance Surveillance Program by managing data operations including validation, performance measurement, and reporting. The role involves applying business rules, troubleshooting data issues, developing SQL queries, and enhancing databases and dashboards to deliver accurate insights and improve program efficiency.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Business Consulting and Services.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
What You’ll Do
As a Consultant — Data Analyst you will support a compliance surveillance program focused on Social Adult Day Care (SADC) oversight of Managed Long Term Care (MLTC) plans. You will work with technical and program teams to validate data, calculate performance measures, produce recurring and ad-hoc reports, and help automate repeatable processes.
- Process, validate, and analyze structured data submissions using established business rules.
- Run, troubleshoot, and improve Excel/VBA workflows; build analytical and reporting workbooks.
- Develop and troubleshoot SQL queries to retrieve, reconcile, and analyze relational data across multiple tables.
- Investigate missing, inconsistent, duplicate, or inaccurate data; identify root causes and resolve processing issues.
- Match and reconcile records across sources using exact and fuzzy matching (identifiers, names, addresses).
- Produce recurring and ad hoc findings reports and analytical deliverables; communicate results clearly to program and technical teams.
- Develop, maintain, test, and enhance databases, dashboards, HTML-based reporting interfaces, and reporting tools.
- Identify automation and process-improvement opportunities; document business rules, data logic, and procedures.
What We’re Looking For (Required Qualifications)
- Advanced Microsoft Excel skills with large datasets: formulas, lookups, data validation, cleansing, pivot tables, and reporting workbooks.
- Experience developing, maintaining, or troubleshooting VBA macros and Excel-based automation.
- Proficiency writing, modifying, and troubleshooting SQL queries involving joins, filters, aggregations, and multi-table operations.
- Strong experience working with relational data and reconciling information from multiple sources.
- Proficiency in data matching and reconciliation techniques, including exact and fuzzy matching.
- Advanced analytical thinking, independent problem-solving, troubleshooting, documentation, and clear communication skills.
- Ability to collaborate with program leads and technical staff to translate business rules into repeatable data processes.
Nice to Have (Preferred Qualifications)
- Direct experience querying or analyzing data from the NYS Medicaid Data Warehouse (MDW) or other NYS Medicaid sources.
- Experience with enterprise data warehouses or Microsoft SQL Server and tools such as DBeaver.
- Background analyzing Medicaid claims, encounters, service utilization, or experience supporting Medicaid managed care, MLTC, compliance, quality improvement, or regulatory surveillance.
- Experience developing dashboards or web-based reporting tools (Power BI, Tableau, HTML-based dashboards).
- Experience using Python or similar scripting languages to automate data validation, processing, or reporting.
Education & Experience
- Bachelor’s degree in data science, computer science, statistics, mathematics, health informatics, information systems, economics, or a related discipline plus two years of related experience in data analysis, data management, BI, healthcare analytics, or a similar role.
- Equivalent combinations of education, training, and experience will be considered.
Compensation & Location
- Location: City of Albany, NY (work performed in and for the City of Albany area).
- Target base salary: $73,476 - $95,518 per year. Compensation is determined based on skills, experience, location, and job-related qualifications.
- Applicants must be authorized to work in the United States without the need for visa sponsorship now or in the future.
- If you require a reasonable accommodation to apply or to perform the job, please state your need during the application process so the hiring team can assist you.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range