Data Analytics & Automation Specialist
- Pay
- $75,000 – $98,584 per year
- Location
- New York City, NY · On-site
- Job type
- Full-time
- Level
- Mid-level
- Experience
- 4+ years
- Listed
- Today
Skills & highlights for this role
- Power BI
- SQL
- Python
- ETL
- Power Automate
Also useful
- Tableau
- Power Apps
How well does your resume fit this job?
Upload your resume to see your score for this City of New York role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
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.
Additional information
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.
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.
Qualifications & Requirements
- 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
- 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
- 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
- Education and/or experience which is equivalent to "1", "2", or "3" above.
Equal opportunity and legal notices
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.
From City of New York's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Data Analytics & Automation Specialist role at City of New York, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
All Data Analyst jobs- Product Analytics EngineerStedi · Remote in the
- ServiceNow Data and AI Readiness AnalystAccenture Federal Services · Suitland, MD
- Data Analyst (R, SAS, SQL) - w/ Public Health Data Experience (Job 1528)DLH · Atlanta, GA
- Data Analyst - Credit Risk Management & Counterparty Risk (Client & Markets Data)Citigroup · Tampa, FL · $87.3k – $131k/yr
- Carbon Accounting Analyst IIIKaiser Permanente · Oakland, CA
- Senior Data Engineering SpecialistUnitedHealth Group · Eden Prairie, MN · $24 – $43/hr
More at City of New York
All City of New York jobs- Senior Data Analyst for the Division of Budget & Program Operations (City HAP Program)City of New York · New York City, NY · $62.9k – $90k/yr
- Junior Data Analytics & Automation SpecialistCity of New York · New York City, NY · $62.9k – $72.3k/yr
- Analytics & Reporting Engineer for the Division of Strategic Operations & AnalyticsCity of New York · New York City, NY · $95k – $101k/yr
Common questions
What is the salary for the Data Analytics & Automation Specialist role at City of New York?
The Data Analytics & Automation Specialist posting at City of New York states compensation of $75,000 – $98,584 per year. It is listed as a full-time position. Final pay may depend on location, experience, and interview evaluation on City of New York's official career site.
Where is the Data Analytics & Automation Specialist job at City of New York located?
This Data Analytics & Automation Specialist position at City of New York is located in New York City, NY (On-site). Always check City of New York's application page for specific state eligibility or relocation policies.
What qualifications are required for Data Analytics & Automation Specialist at City of New York?
For the Data Analytics & Automation Specialist role, City of New York highlights 4+ years of relevant experience; experience with Power BI, SQL, Python, ETL, Power Automate. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Data Analytics & Automation Specialist position at City of New York?
This listing links directly to City of New York's SmartRecruiters application page. You can apply directly on City of New York's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.