Integration Services Developer

Integration Services Developer

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 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 Analytics (ODA) 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. Upon joining the newly created Office of Technology and Innovation, ODA 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.

ODA seeks an Integration Services Developer to join a diverse mission-driven urban analytics office and serve as part of the Data Integration team, which implements and supports complex data engineering solutions for City agencies in the City of New York. The Integration Services Developer will develop and support software applications to help advancing citywide data infrastructure, integration, and sharing. The successful candidate should demonstrate a solid understanding of industry-standard implementation methodologies using data engineering technologies, tools, and processes. The Integration Services Developer will report to the Director of Data Integration, and work closely with other members of the Integration Team and ODA office on projects.

Responsibilities will include:

• Implementation and support of integration services with multiple City agency data sources, web services and APIs.
• Business requirements gathering and preparation of functional and technical designs throughout the software development life cycle.
• Contribute to new technology projects as assigned and provide operations & maintenance support for existing applications.
• Develop custom code and web services that allow seamless integration between systems.
• Support Extraction, Transformation, Load strategies (ETL) for data from a wide variety of data sources using SQL, cloud, and 'big data' technologies.
• Create, update, and maintain application repositories and documentation.
• Coordinate appropriate security scan accreditations.
• Support the team director and fellow team members as needed.
• Perform special projects and initiatives as assigned.

HOURS/SHIFT Day - Due to the necessary 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

Minimum 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.

Preferred Skills:

• 5+ years in application development using Java preferably with Spring Boot.
• 3+ years of experience with RDBMS and writing SQL.
• 3+ years of experience in copying, transferring, manipulating, and automating data operations that were manual processes.
• Extensive experience designing and developing microservices and Service-Oriented Architecture (SOA) based on SOAP and RESTful services with Java and Spring Boot frameworks.
• Hands-on experience with RESTful and SOAP web services using JSON, XML, XSD, WSDL and JDBC.
• Experience in MQ such as Rabbit MQ, IBM MQ and Active MQ.
• Experience with tools and components of data architecture such as IBM InfoSphere DataStage, Informatica Power Center, IICS, SSIS, or similar ETL tools.
• Experience working with Amazon Web Services or Microsoft Azure cloud computing platforms and services.
• In-depth knowledge of SQL and other database solutions.
• Knowledge of modeling database schemas for large datasets.
• Experience developing cloud-ready applications.
• Experience working with programming languages like Python, Javascript, and Perl
• Experience in version control and automation using tools like GitHub, SVN, Terraform, Ant, Jira, Jenkins, Docker and Azure DevOps.

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.