Back to jobs

Data Analytics & Automation Specialist

New York City, NY, United States

Actively hiring, first seen by us 1 day ago
Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Build and maintain dashboards and recurring and ad hoc reports in Power BI or Tableau

  • Write and maintain SQL queries to extract, transform, validate and analyze data

  • Develop Python scripts, ETL processes and automated pipelines to replace manual data handling

  • Design Power Automate workflows and Power Apps for approvals, tracking and data intake

From the employer’s posting
Design, develop, and maintain interactive dashboards, reports, and data visualizations using Power BI, Tableau, or similar tools
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
Design and build Power Automate workflows and Power Apps to automate multi-step administrative processes, such as approvals, tracking, and data intake
Apply at City of New York

Posting record

Report an error

Actively hiringFirst seen by us 1 day ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 20, 20261 day ago
Recorded sightings
2
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 1

Early. Similar jobs usually come down between day 5 and day 43.

At City of New York, jobs usually come down by about day 13.

From 16,008 similar postings that came down, and 355 of City of New York’s. Coming down is not always a hire.

City of New York is hiring

44 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Analyst hiring is picking up
  • Takes jobs down quickly
  • 36% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Power BI
  • Tableau
Where the posting names them
The Technology and Innovation (T&I) Division serves as DDC’s centralized Information, Technology, and Telecom operation, organized into four core units: Network, Infrastructure and Security; Service Delivery; Application Development, and Administrative Analytics. Together, these units provide the hardware, software, enterprise applications, and data ecosystem that support the agency’s daily operations. In addition to maintaining core systems, the division leads strategic modernization efforts aimed at improving efficiency, strengthening security, and advancing programmatic excellence across the agency. Reporting directly to the Director of Administrative Analytics, the Data Analytics & Automation Specialist will blend business intelligence and reporting with hands-on data engineering and automation. The selected candidate will build the dashboards leadership relies on and the automated pipelines that feed them across HR, budget, contracting, procurement, and other administrative functions. The ideal candidate will combine strong technical skills in business intelligence, SQL, Python, and automation with excellent communication and interpersonal skills, and will be comfortable working directly with non-technical users to gather requirements, conceptualize business challenges, and deliver practical solutions. This role involves working with sensitive and sometimes confidential data, including personnel information and internal agency operations. The selected candidate will emphasize security and access control in the design of pipelines, the distribution of reports and tools, and the infrastructure that hosts this data.
This role involves working with sensitive and sometimes confidential data, including personnel information and internal agency operations. The selected candidate will emphasize security and access control in the design of pipelines, the distribution of reports and tools, and the infrastructure that hosts this data. The responsibilities include: - 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 the speed, reliability, and accuracy of reporting. - 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 leverage automation, advanced analytics, and emerging technologies to modernize administrative processes across the agency. Additionally, educational credentials must be from a U.S. Department of Education-recognized accredited institution. Credentials from foreign institutions require independent equivalency verification from an approved evaluation service. A list of providers (fees apply) is available at: https://www.nyc.gov/assets/dcas/downloads/pdf/employment/nyc-dcas-foreign-education-evaluation-guide.pdf.

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

Hours: Full-Time – 35 Hours
Work Location: 30-30 Thomson Avenue, LIC, NY 11101

The Technology and Innovation Division (T&I) within the New York City Department of Design and Construction (DDC) seeks to hire a skilled, data-driven Data Analytics & Automation Specialist.

DDC is the City’s primary capital construction agency, responsible for delivering safe, sustainable, and innovative public buildings and infrastructure across the five boroughs. Partnering with client agencies, design professionals, and the construction industry, DDC manages a broad portfolio of projects from firehouses, libraries, and community centers to roadways, sewers, and resiliency initiatives helping to shape a more equitable, efficient, and resilient city. Through its commitment to design excellence, technological modernization, and public service, DDC ensures that critical civic projects are delivered on time, on budget, and to the highest standards of quality.

The Technology and Innovation (T&I) Division serves as DDC’s centralized Information, Technology, and Telecom operation, organized into four core units: Network, Infrastructure and Security; Service Delivery; Application Development, and Administrative Analytics. Together, these units provide the hardware, software, enterprise applications, and data ecosystem that support the agency’s daily operations. In addition to maintaining core systems, the division leads strategic modernization efforts aimed at improving efficiency, strengthening security, and advancing programmatic excellence across the agency.

Reporting directly to the Director of Administrative Analytics, the Data Analytics & Automation Specialist will blend business intelligence and reporting with hands-on data engineering and automation. The selected candidate will build the dashboards leadership relies on and the automated pipelines that feed them across HR, budget, contracting, procurement, and other administrative functions. The ideal candidate will combine strong technical skills in business intelligence, SQL, Python, and automation with excellent communication and interpersonal skills, and will be comfortable working directly with non-technical users to gather requirements, conceptualize business challenges, and deliver practical solutions.

This role involves working with sensitive and sometimes confidential data, including personnel information and internal agency operations. The selected candidate will emphasize security and access control in the design of pipelines, the distribution of reports and tools, and the infrastructure that hosts this data.

The responsibilities include:
- 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 the speed, reliability, and accuracy of reporting.
- 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 leverage automation, advanced analytics, and emerging technologies to modernize administrative processes across the agency.

Additionally, educational credentials must be from a U.S. Department of Education-recognized accredited institution. Credentials from foreign institutions require independent equivalency verification from an approved evaluation service. A list of providers (fees apply) is available at: https://www.nyc.gov/assets/dcas/downloads/pdf/employment/nyc-dcas-foreign-education-evaluation-guide.pdf.

All applicants, including City Employees:
Please go to NYC Government Jobs | Explore Careers | City of New York, go to Search for Open Jobs, and type in the Job ID # listed above. Submit job application as prompted. Do not apply via Employee Self-Service (ESS), e-mail, mail, or fax your resume to DDC directly.

IT PROJECT SPECIALIST - 95710

Qualifications

1. A baccalaureate degree from an accredited college 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 experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or

2. An associate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and six years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or

3. A baccalaureate degree from an accredited college, and eight years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or

4. Education and/or experience which is equivalent to "1", "2", or "3" above.

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

New York City, NY, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.