Senior Data Analyst — Data Modeling & Dashboards (1 Day Remote/Week)

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

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.