Data Analyst, BERS

$86,201 - $103,911/Yr

City of New York - New York, NY

Full-time - Entry Level

New York, NY

1,001-5,000 employees

Executive, Legislative, and Other General Government Support

About the position

The Data Analyst position at the New York City Department of Education involves performing technical work in data analysis under the supervision of the Director of Data Analytics. The role requires responding to ad-hoc requests, performing data extraction and transformation, and ensuring data integrity. The analyst will work closely with various staff members across the Board of Education Retirement System (BERS) and other City Retirement Systems.

Responsibilities

• Respond to ad-hoc requests from other units within BERS and other city agencies.
• Perform data extracts, transformations, and loads using SQL and PL/pgSQL.
• Merge data sets from multiple sources and formats.
• Create spreadsheets, PDFs, and graphs/charts using Python.
• Automate recurring tasks using MFT software and Bash scripts.
• Verify the integrity of data received from external sources and report on problems.
• Assist other units with data cleanup projects.

Requirements

• A baccalaureate degree from an accredited college including or supplemented by 24 semester credits in computer science or a related computer field and one year of satisfactory full-time computer software experience in computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development and design.
• A four-year high school diploma or its educational equivalent and five years of satisfactory full-time computer software experience as described above.
• Education and/or experience equivalent to the above qualifications.

Nice-to-haves

• Strong analytical and research skills.
• Basic understanding of Unix CLI tools (e.g. grep, sed, awk).
• Experience using Python libraries such as Pandas, NumPy, OpenPyXL, and ReportLab.

Benefits

• Loan forgiveness