Senior Data Service Developer

City of New York; New York (NY); On-site; USD 125,000 - 150,000; Full time

Job summary

City of New York's Office of Technology and Innovation is seeking a Senior Data Service Developer to join the Integration Services - Data Analytics team in Brooklyn, NY. You will design and implement scalable data pipelines and analytics capabilities across City agencies.

The role requires advanced data engineering skills, API development, and collaboration with cross-functional teams to deliver impactful government tech projects on a 24/7 operation environment.

Qualifications

• Bachelor's degree in CS/engineering/related field with 4 years full-time experience.
• Associate degree with 6 years full-time experience in related area.
• Bachelor's degree with 8 years relevant experience.
• Education/experience equivalent to above options.

Responsibilities

• Create and maintain optimal data pipeline architecture that is coherent and scalable.
• Build analytics tools to provide insights into engagement and performance.
• Develop APIs for data access or landing data downstream.
• Perform the technical design, development, and testing of repository changes.
• Build ETLs for data extraction, transformation, and loading using SQL, cloud, and big data tech.
• Develop ETLs to move data securely between sources and targets.
• Contribute to new technology projects and provide operations & maintenance support.
• Troubleshoot errors, defects, and issues.
• Create, update, and maintain system documentation.
• Collaborate with City’s Cyber Command for security accreditation.
• Perform special projects and initiatives.

Education

Baccalaureate degree in CS/engineering/related field

Associate degree + 6 years experience in related area

Baccalaureate degree + 8 years relevant experience

Education/experience equivalent to 1-3 above

Tools

SQL

ETL

Cloud technologies

APIs

Job description

• Salary Band: $125,000 to $150,000
• Compensation: USD 75,000 - USD 140,000

Job Description

The Office of Technology and Innovation (OTI) leverages technology to drive opportunity, improve public safety, and help government run better across New York City. From delivering affordable broadband to protecting against cybersecurity threats and building digital government services, OTI is at the forefront of how the city delivers for New Yorkers in the 21st century. Watch our welcome video to see our work in action, follow us on social media NYCOfficeofTech, and visit www.oti.nyc.gov to learn more.
At OTI, we offer great benefits, and the chance to work on projects that have a meaningful impact on millions of people. You'll have the opportunity to work with cutting-edge technology and collaborate with other passionate professionals who share your drive and commitment to making a difference through technology.
The Office of Data Strategy (ODS) works with City agencies and their data to help serve New Yorkers more equitably and effectively. Historically, this work has mainly taken the form of analyzing agency data to improve City agency operations and working to make Open Data more accessible to all New Yorkers. ODS has also assumed a greater role in determining the direction of the infrastructure that powers non-public data sharing between City agencies, and an expansion of our role in automating data feeds, providing more robust quality assurance, and improving the user experience of the City’s data sharing platforms.
We are seeking a versatile and driven Senior Data Service Developer to join our innovative Integration Services - Data Analytics team. This role ensures the efficient and successful implementation and support of complex data engineering solutions for City agencies. The Senior Data Service Developer should demonstrate a solid understanding of industry-standard implementation methodologies using data engineering technologies, tools, and processes; and will be responsible for developing, supporting and expanding our extensive data products and will collaborate closely with cross-functional teams to translate business requirements into technical implementations that drive our agency’s growth and success.
The Senior Data Service Developer will report to the Director of Integration Services, and work closely with cross-functional teams and ODS office on projects. Primary responsibilities will include:

• Create and maintain optimal data pipeline architecture that is coherent and scalable, based on best practices of integrating data into a consolidated repository.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer engagement and experience, operational efficiency, and other key business performance metrics.
• Develop new or build against existing APIs for data access or landing data as output for further downstream consumption in the appropriate target data store.
• Perform the technical design, development, and component testing of repository changes.
• Build the infrastructure required for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources using SQL, cloud, and “big data” technologies.
• Develop ETLs to move data securely from source to target systems.
• Contribute to new technology projects as assigned and provide operations & maintenance support for existing applications.
• Troubleshoot errors, defects, and other system issues.
• Create, update, and maintain system documentation.
• Work with City’s Cyber Command unit to pass application security accreditation.
• Perform special projects and initiatives assigned.

HOURS/SHIFT
Day - Due to the necessary technical duties of this position in a 24/7 operation, candidate may be required to work various shifts such as weekends and/or nights/evenings.

WORK LOCATION
Brooklyn, NY

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.