Data Analytics Specialist

Department-of-Finance; New York (NY); Hybrid; USD 85,000 - 110,000; Full time

Job summary

NYC Department of Finance is seeking a data-focused analyst to support the Property Valuation and Tax Mapping division. Responsibilities include extracting data with SAS/SQL, generating annual PRV exemption and appeal reports, and liaising across divisions for valuation and exemption processes.

The role emphasizes data quality, timely reporting, and cross-unit collaboration to improve the accuracy of property assessments and surcharge administration.

Qualifications

• SQL, Power BI, SAS, Excel, data analysis
• Strong statistical and programming skills
• Experience with data reporting

Responsibilities

• Use data tool systems, SAS or SQL, to extract data concerning Non-Primary Residence Surcharge parcel level and aggregate data and create statistical reports and summaries.
• Create annual summary reports on Primary Residence Verification exemptions handled by DOF, Tax Commission rulings on market value and/or PRV appeals, and Article 78 cases.
• Serves as the unit’s liaison within DOF, coordinating operations or tech issues per divisions for valuation, exemption, and surcharge programs.
• Respond to data report requests from various Property Division units under tight deadlines; produce canned reports for CAMAP and PTS.
• Improve data available for QA staff, assessors, and supervisors; cleanup parcel data and consolidate data sources.
• Manage projects and aid field units to identify parcels with incomplete data; conduct analysis.
• Assist other business units with special projects as needed.

Job description

NYC Department of Finance (DOF) is responsible for administering the tax revenue laws of the city fairly, efficiently, and transparently to instill public confidence and encourage compliance while providing exceptional customer service.

DOF’s Property Valuation and Tax Mapping is responsible for valuing more than one million properties in the city and overseeing assessments and valuations in a fair and equitable manner. The valuations enable the efficient and effective collection of property tax revenues for New York City.

The Property Division’s Compliance and Quality Assurance Units, serve as independent functions that promote quality assurance, consistency, and integrity in property valuation, property exemptions, and the administration of the Non-Primary Residence Surcharge. The units also assist with Primary Residence Verification (PRV) exemption requests submitted by property owners who disagree with DOF determination regarding PRV eligibility and subsequently the surcharge levy.

The ideal candidate will become familiar with Non-Primary Residence Surcharge Rules and learn how to process Primary Residence Exemption Appeal applications in Smartfile. The overall goal is to ensure the accuracy and the integrity of the assessment role, including matters related to the Non-Primary Residence surcharge; promote the consistent application of policies and procedures by assessors and processors; foster transparency, accountability, and integrity throughout the assessment process; and provide recommendations to improve operations, training, resource development, and business processes.

Reporting to the Senior Director of Compliance and Quality Assurance, the selected candidate’s duties and responsibilities will include, but are not limited to the following:

• Use data tool systems, SAS or SQL, to extract data concerning Non-Primary Residence Surcharge parcel level and aggregate data and create statistical reports and summaries. Track changes to relevant property information following the initial surcharge.
• Create annual summary reports on Primary Residence Verification Exemption appeals handled by DOF, Tax Commission rulings on market value and/or primary residence verification appeals, and the number of property owners that file Article 78 cases per DOF PRV exemption denials.
• Serve as the unit’s liaison within DOF, coordinating operations or technological issues per Executive, Tax Policy, Information Technology and or Legal Divisions for Property valuation, Property Exemption and Non-Primary Residence Surcharge programs.
• Respond to requests for data reports from various Property Division units under tight deadlines. Produce canned reports for both the Computer Assisted Mass Appraisal application as well as Property Tax System (PTS) and assist other staff to run reports as needed.
• Improve and increase data available for Quality Assurance staff, assessors, and supervisors concerning parcels with filed Industrial Commercial Abatement Program (ICAP’) applications. Assist in the cleanup of parcel data by updating descriptive and valuation data, to ensure all changes to properties are captured. Work to consolidate and streamline data sources and reports.
• Manage projects and aid Property Field or other units to identify parcels with incomplete or erroneous data. Research and provide additional data and analysis.
• Assist other business units with special projects as needed.

Additional Information:

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program agreed between the City and the Collective Bargaining Unit representing employees serving in the civil service title.

BUSINESS RESEARCH & DATA ANALY - 13135

Minimum Qualifications

Level I

1. A master’s degree from an accredited college or university in social science, economics, statistics, computer science, data analysis, geography, sciences, technology, engineering, mathematics (STEM), or a closely related field, with at least 12 credits or five courses in economics, public policy, econometrics, statistics, mathematics, engineering, geography or computer science.
2. A baccalaureate degree from an accredited college or university as described in “1” above and two years of full-time, professional experience performing statistical analysis and programming work in any of the areas described in “1” above.

Level II

1. A master’s degree from an accredited college or university in social science, economics, statistics, computer science, data analysis, geography, sciences, technology, engineering, mathematics (STEM), or a closely related field, with at least 12 credits or five courses in economics, public policy, econometrics, statistics, mathematics, engineering, geography or computer science.
2. A baccalaureate degree from an accredited college or university as described in “1” above and two years of full-time, professional experience performing statistical analysis and programming work in any of the areas described in “1” above.

Special Note:

To be eligible for placement in Assignment Level II, individuals must have, in addition to meeting the minimum requirements, at least one year full-time work experience in a related field, or a master’s degree from an accredited college or university, in the areas described in “1” above, with at least 12 credits or three advanced courses in economics, public policy, econometrics, statistics, mathematics, engineering, geography, or computer science.

Level III

1. A master’s degree from an accredited college or university in social science, economics, statistics, computer science, data analysis, geography, sciences, technology, engineering, mathematics (STEM), or a closely related field, with at least 12 credits or five courses in economics, public policy, econometrics, statistics, mathematics, engineering, geography or computer science.
2. A baccalaureate degree from an accredited college or university as described in “1” above and two years of full-time, professional experience performing statistical analysis and programming work in any of the areas described in “1” above.

Special Note:

To be eligible for placement in Assignment Level III, individuals must have, in addition to meeting the minimum requirements of Level II, at least three years full-time work experience in a related field, or a Doctorate degree from an accredited college or university, in the areas described above, with at least 12 credits or three advanced courses in economics, public policy, econometrics, statistics, mathematics, engineering, geography or computer science.

Preferred Skills

• Above average written communication skills.
• Experience with SQL Server Management Studio and Power Bi.
• Intermediate to advance level skills with SAS.
• Intermediate to advance level experience/skills using Microsoft Excel and Office Suite Products.
• Familiarity with Property Valuation and Exemption Processing.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

Residency Requirement

New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.