Medicaid Analytics Data Analyst I

New York State Department of Health; City of Albany (NY); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Holiday & Paid Time Off

Public Service Loan Forgiveness (PSLF)

Pension from NYS Employees’ Retirement

Shift & Geographic pay differentials

Affordable Health Care options

Family dental and vision benefits

NY Deferred Compensation plan

529 College Savings Programs and U.S.B

And many more...

Job summary

New York State Department of Health’s Office of Health Insurance Programs seeks three Data Analysts 1 to support the Bureau of Data Insights and Research. The role focuses on data analytics, modeling, databooks, and BI solutions using the Medicaid Data Warehouse and Tableau to identify trends and inform budget decisions.

Responsibilities include preparing deliverables, conducting SQL reviews, predictive modeling, and collaborating with stakeholders across divisions to translate data into

Qualifications

• Four years of experience in data visualization, and statistical models and data mining tools and satisfactory completion of a two-year traineeship; OR six years of experience in data visualization, and statistical models and data mining tools.
• Substitution: An associate’s degree may substitute for two years of general experience; or a bachelor’s degree may substitute for four years of general experience. A master’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, may substitute for one year of general experience; or a Ph.D. in these fields may substitute for two years of general experience.
• Preferred Qualifications: Experience in Medciaid (New York Medicaid preferred), experience in SQL and Tableau; Experience working with large-scale data warehouses, Experience in reporting environments

Responsibilities

• Data analytics, deliverables, and summarized reports using the Medicaid Data Warehouse.
• SQL review of others’ work including ad-hoc, budget, and recurring requests.
• Predictive modeling.
• Provide customer service to program representatives and collaborate with stakeholders across the Division and The Office of Health Insurance Programs as it relates to both business and data domains.
• Act as a subject matter expert for databooks; including but not limited to, creation, review, backlog maintenance, and User Acceptance Testing (UAT).
• Ensure proper use of databooks by stakeholders to help inform budget and policy decisions, provide necessary training in the use of databooks.
• Tableau visualizations for trend analysis.
• Fiscal analysis for ad‑hoc requests, and budget inquiries.
• Audit support.
• Assist in creation and review of design documents.

Skills

Data visualization

Statistical models

Data mining tools

SQL

Tableau

Education

Two-year traineeship

Bachelor’s degree

Tools

SQL Server Management Studio

Tableau

Job description

New York State Department of Health’s Office of Health Insurance Programs seeks three Data Analysts 1 to support the Bureau of Data Insights and Research. The role focuses on data analytics, modeling, databooks, and BI solutions using the Medicaid Data Warehouse and Tableau to identify trends and inform budget decisions.

Responsibilities include preparing deliverables, conducting SQL reviews, predictive modeling, and collaborating with stakeholders across divisions to translate data into