IT Senior Business Analyst

NYC Department of Environmental Protection (NYC DEP); New York (NY); On-site; USD 75,000 - 109,518; Full time

Job summary

The City of New York’s Mayor’s Office of Environmental Coordination (MOEC) seeks an IT Project Specialist to help design and implement a new environmental review database. You will analyze business and technical needs, map data flows, and collaborate with city agencies and vendors to deliver scalable, compliant solutions.

You will oversee QA activities, manage onboarding workflows and ticketing processes, and transform system data into actionable insights with Power BI to boost efficiency across

Qualifications

• A bachelor’s degree in computer science, engineering, HCI, interactive media, data visualization, communication, or related field with four years of related experience.
• Associate degree with six years of related experience.
• A bachelor’s degree with eight years of related experience.
• Education/experience equivalent to the paths above.

Responsibilities

• Support the development and implementation of a new database for environmental review processes and records.
• Perform data flow modeling, workflow analysis, and functional decomposition; review workflows; write specifications.
• Coordinate QA activities, manage support queues and ticketing workflows; use Power BI to derive insights and improve onboarding.

Skills

QA management

SDLC knowledge

Agile/Iterative PM

Requirements development

User acceptance testing

SQL familiarity

Power BI

Ticketing workflows

Education

Bachelor's degree in CS/Engineering/IT/Related

Associate degree + 6 years experience

Bachelor's + 8 years experience

Equivalency of education/experience

Tools

Power BI

Microsoft Dynamics CRM/PowerApps

SQL

Job description

IT Project Specialist - 95710

The New York City Mayor’s Office is responsible for overseeing city services throughout the five boroughs, coordinating public agencies and departments, and managing public property. The administration is leading the fight to make the city more affordable, reduce inequality, improve public safety, ensure delivery of efficient and effective services, and strengthen New York City’s economy. We value leadership, transparency, fairness, and efficiency as we actively seek diverse talents from various sectors to join our team.

The Team You’ll Work With

The Mayor’s Office of Environmental Coordination (MOEC) oversees New York City’s environmental review process as mandated by the State Environmental Quality Review Act (SEQRA). MOEC reviews environmental analyses conducted pursuant to the City Environmental Quality Review (CEQR) framework for projects that the Office of the Mayor leads, including those sponsored by the New York City Economic Development Corporation. CEQR is the process by which New York City agencies determine the environmental impacts of discretionary actions. MOEC serves as the database repository for all CEQR analysis documents, maintains the CEQR Technical Manual, and acts as the City’s liaison to State and Federal agencies on environmental matters. It also advises the Mayor on environmental policy and oversees the City’s Capital Green Building Laws (GBL).

The Problems You’ll Solve

The Business Analyst will support the development and implementation of a new database that assists City agencies in efficiently managing environmental review processes and records. The role involves functional and non‑functional requirements analysis using data flow modeling, workflow analysis, and functional decomposition; reviewing current system workflows; revising requirement documentation; writing specifications; coordinating quality assurance; and collaborating with IT teams, project staff, and vendors. The Analyst will also manage support queues, ticketing workflows, and use Power BI to transform system data into actionable insights and streamline user onboarding.

About You

• You are a Business Analyst with at least three years of experience, including managing and leading QA activities on a project, database analysis and validation, familiarity with SQL, and a strong working knowledge of the software development life cycle (SDLC), Agile/Iterative project management, user/system/functional requirements development, and user acceptance testing.
• You work independently and are a team‑oriented professional.
• You will communicate and collaborate with many City agencies to support the new database and ensure efficient environmental review process management.
• Your communication and writing skills will support user interviews, training, workshops, and written analysis documentation.
• You will evaluate information from multiple sources, decompose high‑level information into details, and distinguish user requests from true needs, working with project management staff to raise and resolve issues, set deadlines, and mitigate risks.
• You will manage daily system operations and ticketing workflows, oversee the full user‑onboarding lifecycle, and provide expert troubleshooting for technical escalations.

Minimum Qualifications

• 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, plus four years of satisfactory full‑time experience related to the required area(s) and a specialization in a relevant technology, process, methodology, and/or domain.
• An associate degree in the same fields plus six years of satisfactory full‑time experience related to the required area(s) and a specialization in a relevant technology, process, methodology, and/or domain.
• A baccalaureate degree plus eight years of satisfactory full‑time experience related to the required area(s) and a specialization in a relevant technology, process, methodology, and/or domain.
• Education and/or experience equivalent to one, two, or three of the above paths.

Preferred Skills

• Bachelor’s in Information Systems, Information Technology, Data Analytics / Business Analytics, or Computer Science (focus on analytics and business processes).
• 3+ years of experience as an IT Business Analyst.
• 3+ years of proven experience managing and leading QA activities on a project.
• 3+ years of experience in database analysis and validation, familiarity with SQL and Power BI.
• Strong working knowledge of SDLC, Agile/Iterative project management, user/system/functional requirements development, and user acceptance testing.
• 3+ years of experience in test script execution and defect reporting.
• Experience in UX design, cloud computing, conflict resolution, negotiation skills, and exposure to Scrum methodologies.
• Experience in data clean‑up and conversion, migration of legacy applications and data to new platforms.
• Extensive experience in functional, regression, system integration (SIT), UAT, GUI, security, and performance/stress testing, data‑validation, browser, and operating system compatibility testing.
• Proficiency in Microsoft Dynamics CRM/PowerApps.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

Residency Requirement

New York City residency is not required for this position.

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.

$75,000.00 – $109,518.00