Senior Data Service Developer

Senior Data Service DeveloperThe 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 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