You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Company hidden

Junior Data Analytics & Automation Specialist

  • Office
  • 0-3 years

Salary

Not stated

Similar roles pay $65K - 110K a year · our estimate

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

Hours: Full-Time Position – 35 Hours

Requirements

  • A baccalaureate degree from an accredited college and two years of experience in community work or community centered activities in an area related to the duties described above; or
  • High school graduation or equivalent and six years of experience in community work or community centered activities in an area related to the duties as described above; or
  • Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least one year of experience as described in "1" above.
  • Additional Information
  • The company 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.
  • Company Description

Conditions

The Technology and Innovation Division (T&I) within the New York City Department of Design and Construction (DDC) seeks to hire a motivated, data-driven Junior 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 Junior Data Analytics & Automation Specialist will combine business intelligence and reporting with hands-on automation and data work. The selected candidate will help build the dashboards leadership relies on and the automated workflows that feed them across HR, budget, contracting, procurement, and other administrative functions. This is a growth-oriented role: the candidate will work with the team’s tools, including Power BI, SQL Server, Azure, the Microsoft Power Platform, and Python, and will build depth in each over time. The position requires someone who is comfortable working directly with non-technical users to understand their needs 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 follow security protocols when building reports and tools and will adhere to agency standards for handling and distributing data.

The responsibilities include:

Develop, update, and maintain interactive dashboards, reports, and data visualizations using Power BI, 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 to automate routine administrative processes, such as notifications, simple approvals, and data collection forms.

Develop Python scripts and support ETL processes and data pipelines that integrate 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.

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 | the company, 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.

COMMUNITY COORDINATOR - 56058

Where you’d work

From the office

The office

About the company

Company hidden

Office in New York City, United States

Your chances

Likely still hiring, not crowded yet, and you'd be among the first.

  • 15 checks run
  • 5 good signs
  • 2 red flags

Still hiring?

10 checks

Likely active

In its favour2

  • Still on the company's own careers site, checked 1 h agoModerate evidence
  • Found in the last 48 hours, before the big job boardsModerate evidence

Against it1

  • No salary stated, though New York asks most employers to post oneModerate evidence

How crowded?

5 checks

Low

In its favour3

  • In its Early Window: not on the big job boards yetStrong evidence
  • In the office in New York City: only people nearby can take itSlight evidence
  • Asks for Power BI, which only 2% of open roles doSlight evidence

Against it1

  • Entry level: the most applied-to level there isModerate evidence

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details11 facts · Role, Location, Compensation, Employment
Tech stack
  • Python
  • SQL
  • Azure
  • Power BI
Seniority
Junior
Type
Full-time
Specialty
Data Analyst
Region
United States
Pay period
Annual
Show 5 more factsShow less

Role

Category
Data & Analytics
Specialty
Data Analyst
Seniority
Junior
Experience
0-3 years
Tech stack
  • Python
  • SQL
  • Azure
  • Power BI

Location

Work model
Office
Region
United States
Office
  • New York City, United States

Compensation

Salary
Salary by agreement
Pay period
Annual

Employment

Type
Full-time

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason