Junior Data Analytics & Automation Specialist

City of New York•New York, NY
•$62,868 - $72,298•Onsite

About The Position

The Technology and Innovation Division (T&I) of the New York City Department of Design and Construction (DDC) is hiring a motivated, data-driven Junior Data Analytics & Automation Specialist. DDC delivers public buildings and infrastructure across New York City, while T&I provides the technology, applications, and data ecosystem supporting the agency’s operations and modernization efforts. Reporting directly to the Director of Administrative Analytics, this growth-oriented role combines business intelligence and reporting with practical automation and data work. The specialist will help build dashboards and automated workflows supporting HR, budget, contracting, procurement, and other administrative functions. The position works with Power BI, SQL Server, Azure, the Microsoft Power Platform, and Python, with opportunities to build expertise over time. It also involves working directly with non-technical users to understand their needs and deliver practical solutions. The role handles sensitive and sometimes confidential data, including personnel information and internal agency operations. The selected candidate must follow security protocols and agency standards for handling and distributing data. Educational credentials must be from a U.S. Department of Education-recognized accredited institution. Foreign credentials require independent equivalency verification from an approved evaluation service.

Requirements

  • A baccalaureate degree from an accredited college and two years of experience in community work or community-centered activities related to the described duties; or high school graduation or equivalent and six years of such experience; or equivalent education and/or experience. All candidates must have at least one year of qualifying experience.
  • Educational credentials must be from a U.S. Department of Education-recognized accredited institution. Foreign credentials require independent equivalency verification from an approved evaluation service.
  • Ability to work directly with non-technical users to understand their needs and deliver practical solutions.
  • Ability to follow security protocols and agency standards when handling and distributing sensitive data.

Responsibilities

  • Develop, update, and maintain interactive Power BI dashboards, reports, and data visualizations, including recurring and ad hoc reporting for agency staff and leadership.
  • Write and maintain SQL queries to extract, transform, validate, and analyze data from agency databases and citywide systems.
  • Build automated workflows and applications with Power Automate and Power Apps for routine administrative processes, such as notifications, simple approvals, and data collection forms.
  • Develop Python scripts and support ETL processes and data pipelines integrating data from multiple sources, with guidance from senior team members.
  • Assist in maintaining data models, queries, and automated reporting processes to improve the reliability and integrity of administrative reporting.
  • Identify opportunities to use automation and new tools to streamline administrative processes across the agency.
  • Follow security protocols and agency standards for handling and distributing sensitive and confidential data.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service