Data Analytics & Automation Specialist

City of New York•New York, NY
•$75,000 - $98,584•Onsite

About The Position

The Technology and Innovation Division (T&I) within the New York City Department of Design and Construction seeks a skilled, data-driven Data Analytics & Automation Specialist. DDC is the City’s primary capital construction agency, delivering public buildings and infrastructure across the five boroughs. T&I provides the hardware, software, enterprise applications, and data ecosystem that support the agency’s operations and leads modernization efforts to improve efficiency, security, and programmatic excellence. Reporting directly to the Director of Administrative Analytics, this role combines business intelligence and reporting with hands-on data engineering and automation. The specialist will build dashboards and automated data pipelines supporting HR, budget, contracting, procurement, and other administrative functions. The position requires working with non-technical users to gather requirements, understand business challenges, and deliver practical solutions. The role involves handling sensitive and sometimes confidential information, including personnel data and internal agency operations. Security and access control must be emphasized in the design of data pipelines, report and tool distribution, and the infrastructure hosting the data.

Requirements

  • A baccalaureate degree in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication, or a related field, and four years of satisfactory full-time related experience with a relevant specialization; or an associate degree in one of those fields and six years of such experience; or a baccalaureate degree from an accredited college and eight years of such experience; or equivalent education and/or 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.
  • Strong technical skills in business intelligence, SQL, Python, and automation.
  • Excellent communication and interpersonal skills.
  • Comfort working directly with non-technical users to gather requirements, conceptualize business challenges, and deliver practical solutions.
  • Ability to account for security and access control when working with sensitive or confidential data.

Responsibilities

  • Design, develop, and maintain interactive dashboards, reports, and data visualizations using Power BI, Tableau, or similar tools, including recurring and ad hoc reporting for agency leadership.
  • Write and maintain SQL queries to extract, transform, validate, and analyze data from agency databases and citywide systems.
  • Develop Python scripts, ETL processes, and automated pipelines to integrate data from multiple sources, replace manual data handling, and improve reporting speed, reliability, and accuracy.
  • Design and build Power Automate workflows and Power Apps to automate multi-step administrative processes such as approvals, tracking, and data intake, and integrate them with other agency systems.
  • Build and maintain data models and automated reporting processes to improve the reliability, efficiency, and integrity of administrative reporting.
  • Identify opportunities to use automation, advanced analytics, and emerging technologies to modernize administrative processes across the agency.
  • Gather requirements from non-technical users, conceptualize business challenges, and deliver practical solutions.
  • Emphasize security and access control in data pipelines, report and tool distribution, and data-hosting infrastructure.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service