Data Analyst 2

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

Benefits offered by this job

Holiday & Paid Time Off

Public Service Loan Forgiveness (PSLF)

Pension from New York State Employees'

Shift & Geographic pay differentials

Affordable Health Care options

Family dental and vision benefits at a

NY 529 and NY ABLE College Savings

NYS Deferred Compensation plan

Job summary

The Department of Health for the State of New York is hiring a Data Analyst 2 to support the Center for Health Data Innovation in the Data Engineering Unit. This onsite role will help create and run analytics engineering solutions that support healthcare and public health policy and decision-making.

You will focus on building and operating enterprise data pipelines, contributing to data governance standards, and improving internal processes so they scale reliably.

Qualifications

• Seven years of experience in data visualization, statistical models, and data mining tools.
• Proficiency in Python, SQL, dbt, and Git.
• Strong SQL skills and the ability to write efficient queries (experience with Snowflake, Redshift, or BigQuery is preferred).
• Proven experience in data analytics, data engineering, or related roles, preferably in the Health Data domain, including modern data pipelines and data warehousing platforms.
• Ability to quickly learn new methods and technologies.

Responsibilities

• Collaborate with Product Managers to gather technical requirements and run project scoping sessions with subject matter experts and stakeholders to define data needs.
• Work with analysts to design value-focused pipelines, including data integrations and transformations, model feature development, and statistical models.
• Maintain standards for data reliability, data integrity, and data governance to support accurate, consistent, and trustworthy datasets, business intelligence products, and analyses.
• Identify, design, and implement internal process improvements such as automating manual workflows, optimizing data delivery, and redesigning infrastructure for increased scalability.

Skills

Python

SQL

dbt

Git

Data visualization

Statistical models

Data mining tools

Problem solving

Education

Bachelor's degree may substitute for four years of general experience

Tools

Airflow

Docker

Terraform

Snowflake

Redshift

BigQuery

Job description

The Department of Health for the State of New York is hiring a Data Analyst 2 to support the Center for Health Data Innovation. In the Data Engineering Unit, this onsite role will help create and run analytics engineering solutions that support healthcare and public health policy and decision-making.

You will focus on building and operating enterprise data pipelines, contributing to data governance standards, and improving internal processes so they scale reliably.

What you will do

• Collaborate with Product Managers to gather technical requirements and run project scoping sessions with subject matter experts and stakeholders to define data needs.
• Work with analysts to design value-focused pipelines, including data integrations and transformations, model feature development, and statistical models.
• Maintain standards for data reliability, data integrity, and data governance to support accurate, consistent, and trustworthy datasets, business intelligence products, and analyses.
• Identify, design, and implement internal process improvements such as automating manual workflows, optimizing data delivery, and redesigning infrastructure for increased scalability.

Required qualifications

• Seven years of experience in data visualization, statistical models, and data mining tools.
• Proficiency in Python, SQL, dbt, and Git.
• Strong SQL skills and the ability to write efficient queries (experience with Snowflake, Redshift, or BigQuery is preferred).
• Proven experience in data analytics, data engineering, or related roles, preferably in the Health Data domain, including modern data pipelines and data warehousing platforms.
• Ability to quickly learn new methods and technologies.
• Capability to work both independently and as part of a larger team.
• Strong analytical thinking and critical reasoning skills, with aptitude for problem-solving.
• Experience with object-oriented/object function scripting in Python.

Tools and technologies

• Python, SQL, dbt, Git, Airflow, Docker, Terraform, Snowflake, Redshift, BigQuery

Location and schedule

• Albany, NY (onsite)
• Travel throughout New York State may be required, including overnights, to areas not served by public transportation.

Compensation and experience

• Annual salary: USD 90,582 - 114,585
• Minimum experience: 7 years

Benefits

• Holiday & Paid Time Off
• Public Service Loan Forgiveness (PSLF)
• Pension from New York State Employees' Retirement System
• Shift & Geographic pay differentials
• Affordable Health Care options
• Family dental and vision benefits at no additional cost
• NY 529 and NY ABLE College Savings Programs, and U.S. Savings Bonds
• NYS Deferred Compensation plan

Substitution for experience

• An associate's degree may substitute for two years of general experience; 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; a Ph.D. may substitute for two years of general experience.

Reasonable accommodation

If you require reasonable accommodation to complete a job application, a job interview, or otherwise participate in the hiring process, contact 518-486-1812 or email [e-mail] to make a request.

E-Verify and visas

The NYS Department of Health does not participate in E-Verify and does not sponsor visa applications.

Additional notes

• Some positions may require additional credentials or a background check to verify your identity.
• For new State employees appointed to graded positions, the annual salary is the hiring rate at the beginning of the salary range.
• Promotion salaries are calculated by the NYS Office of the State Comptroller according to NYS Civil Service Law, OSC Payroll rules and regulations, and negotiated union contracts.