Senior Data Analyst

New York State Unified Court System; City of Albany (NY); Hybrid; USD 99,767 - 121,938; Full time

Job summary

A state court system in Albany is seeking a Senior Data Analyst to join the Court Research Data Team. In this role, you will define project scope and make data architecture decisions, develop SQL queries, and transform large datasets for operational needs. Candidates should have a Master's degree in Public or Business Administration or equivalent experience, with strong SQL proficiency and technical writing skills preferred. The position offers a salary of $110,853 and potential telecommuting options.

Qualifications

• One year in the Management Analyst title or equivalent.
• Master’s degree in relevant field with four years of experience.
• Preferred background in data governance or public policy.

Responsibilities

• Define project scope and make strategic decisions on data architecture.
• Design logical and physical data models for efficient querying.
• Develop and optimize SQL queries for performance and scalability.
• Transform large datasets to support operational needs.
• Create reports and dashboards using SSRS.
• Document processes, data structures, and reporting logic.
• Collaborate with teams to ensure data accuracy.

Skills

Advanced proficiency in SQL

Data modeling

Working with large datasets

Data optimization workflows

SSRS or similar reporting platforms

Technical writing skills

Education

Master’s degree in Public or Business Administration

One year in Management Analyst title or equivalent experience

Job description

Senior Data Analyst – New York State Unified Court System

Join the New York State Unified Court System as a Senior Data Analyst. We are recruiting for one (1) position for the Court Research Data Team within the Office of Court Administration, Division of Technology and Court Research.

Key Responsibilities

• Define project scope and make strategic decisions on data architecture and implementation.
• Design logical and physical data models to support efficient querying and reporting.
• Develop and optimize SQL queries for performance and scalability.
• Transform and wrangle large datasets to support operational and analytical needs.
• Create meaningful reports and dashboards using SSRS and other tools.
• Document technical processes, data structures, and reporting logic clearly and thoroughly.
• Collaborate with internal teams to ensure data accuracy and usability.

Required Experience

• Advanced proficiency in SQL and experience with data modeling.
• Demonstrated ability to work with large datasets and optimize data workflows.
• Experience designing data structures that support efficient reporting and analysis.
• Experience with SSRS or similar reporting platforms.
• Strong technical writing skills for documentation and communication.

Preferred Experience

• Background in data governance, public policy, or government.

Qualifications

One year in the Management Analyst title; or Master’s degree in Public or Business Administration from an accredited college or university and four (4) years of relevant experience; or an equivalent combination of education and experience. Background in data governance, public policy, or government is preferred.

Salary

$110,853.

Telecommuting

This position has potential to be eligible for one day of telecommuting per week.

Visa

The Unified Court System does not participate in e-verify, therefore we are not able to accept candidates on F‑1 or OPT Visa(s).