Description Database / Business Intelligence Developer. Candidate will function as a database and business intelligence developer performing duties as directed. Provide a list of the day to day tasks to be performed by the Selected Candidate: Perform Data profiling on the source systems Design and review star schema dimensional model to support data warehouse and data marts Perform Source to Target Mapping between source system database and data warehouse target database Develop analytics and reports using Tableau and SQL Server Reporting Services (SSRS) Requirements Qualification IT Specialist works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer. 36-60 Months, Candidate is able to work independently, without assistance. 1. 36 months experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using SQL Server Integration Services (SSIS) or other similar ETL tool 2. 36 months experience in analytics and operational reporting using Tableau and SQL Server Reporting Services (SSRS 3. 36 months experience in Star Schema / Dimensional Modeling to support data warehouse environments as well as OLTP environments. 4. 48 months experience developing and tuning complex SQL and PL/SQL against Oracle (11g or newer) or SQL Server 5. 36 months experience in complex SQL development leveraging analytics functions Bachelors degree (or higher) in Computer Science, Software Engineering, Computer Information Systems, or some related field. Requested Documentation Proof of degree No telecommuting allowed. Candidate must participate in an on-site, in-person interview at the work office location listed above to be considered for the position
03/16/2026
Description Database / Business Intelligence Developer. Candidate will function as a database and business intelligence developer performing duties as directed. Provide a list of the day to day tasks to be performed by the Selected Candidate: Perform Data profiling on the source systems Design and review star schema dimensional model to support data warehouse and data marts Perform Source to Target Mapping between source system database and data warehouse target database Develop analytics and reports using Tableau and SQL Server Reporting Services (SSRS) Requirements Qualification IT Specialist works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer. 36-60 Months, Candidate is able to work independently, without assistance. 1. 36 months experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using SQL Server Integration Services (SSIS) or other similar ETL tool 2. 36 months experience in analytics and operational reporting using Tableau and SQL Server Reporting Services (SSRS 3. 36 months experience in Star Schema / Dimensional Modeling to support data warehouse environments as well as OLTP environments. 4. 48 months experience developing and tuning complex SQL and PL/SQL against Oracle (11g or newer) or SQL Server 5. 36 months experience in complex SQL development leveraging analytics functions Bachelors degree (or higher) in Computer Science, Software Engineering, Computer Information Systems, or some related field. Requested Documentation Proof of degree No telecommuting allowed. Candidate must participate in an on-site, in-person interview at the work office location listed above to be considered for the position
Description Project/Program Name: SESIS Provide a short description of the Position: The New York City Department of Education is seeking (1) Expert ETL Software Architect to help architect/manage the Extraction of data from various sources, Transformation/Integration of that data, and the Load of that data into the SESIS DWH/MS. The position will also ETL architect data for the SESIS transactional DB. Provide a list of the day to day tasks to be performed by the Selected Candidate: • Work with the DIIT (Division of Information and Instructional Technology) Data teams to facilitate the implementation of and maintenance of the SESIS DWH Data Architecture • Support the needed analysis, architectural design, build, test and documentation of complex data conversion and integration solutions • Architect user acceptance test activities for the data conversion and integration solutions • Architect, design and develop ETL code using Microsoft s SSIS ETL tool for the definition, development and testing of the processes and programs necessary to extract, transform, and load data from the various data sources • Architect, design and develop ETL code using Microsoft s SSIS ETL tool for the SESIS transactional Application System • Work with other data analysts, business users and IT professionals to ensure that architectural data requirements are met with the highest degree of integrity and efficiency that is practical and cost effective • Ensure that architectural design documentation is captured, maintained, understood by and available to business and/or IT partners • Participate in, or facilitate, business process, architectural sessions, and requirement sessions to ensure that all fully understand the requirements and the data necessary to support those requirements • Perform architectural design, develop, test and manage ETL jobs to specifications and design • Participate in focus group sessions as needed for information discovery on various architectural designs • Architectural designing and documenting conversion and interface specifications • Use design knowledge and experience in Microsoft s SSIS ETL and DOT NET technology • Use ETL and SQL for architectural performance tuning and concepts • Design/produce high quality, bug free and highly scalable work • Architect and code in various shell scripting languages • Design and perform independent data research • Architect, design, code test, and promote to production SSIS ETL, SQL, and Scripts • Architecturally design, code test, and promote to production SQL using MS SQL Server • Interface with various internal and external clients on a design and practical level • Document architectural designs, codes, and test plans • Troubleshoot ETL job and data issues • Re-architect existing ETL, data and process issues on an as needed basis Requirements Qualification Software Architect makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large-scale software system. Expert 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at 1. 84 Months of Experience Architecting Complex SSIS ETL Development 2. 84 Months of Experience Coding Complex ETL Job Architecture 3. 84 Months of Experience with the architecting of RDBMS Concepts, architecting Complex Stored Procedures, and architecting complex SQL in MS SQL Server 4. 24 Months of Experience architecting and coding Application ETL Design and Development Solutions 5. 84 Months Performing Complex Architecting Designs/Work with Little or No Supervision 6. 24 Months of Experience with Architecture and Code Interfaces to DOT NET, XML, and MS Dynamic CRM 7. 84 Months of Architectural Experience of Full Lifecycle Staging, ODS, Data Mart and DWH Experience in ETL Data Integration 84 Months of Experience in Shell/Power Shell/Bash Script Program Architecture and Development. 9. Bachelor s Degree from an accredited University Requested Documentation Please submit copy of resume, certificate, degree, etc.
03/16/2026
Description Project/Program Name: SESIS Provide a short description of the Position: The New York City Department of Education is seeking (1) Expert ETL Software Architect to help architect/manage the Extraction of data from various sources, Transformation/Integration of that data, and the Load of that data into the SESIS DWH/MS. The position will also ETL architect data for the SESIS transactional DB. Provide a list of the day to day tasks to be performed by the Selected Candidate: • Work with the DIIT (Division of Information and Instructional Technology) Data teams to facilitate the implementation of and maintenance of the SESIS DWH Data Architecture • Support the needed analysis, architectural design, build, test and documentation of complex data conversion and integration solutions • Architect user acceptance test activities for the data conversion and integration solutions • Architect, design and develop ETL code using Microsoft s SSIS ETL tool for the definition, development and testing of the processes and programs necessary to extract, transform, and load data from the various data sources • Architect, design and develop ETL code using Microsoft s SSIS ETL tool for the SESIS transactional Application System • Work with other data analysts, business users and IT professionals to ensure that architectural data requirements are met with the highest degree of integrity and efficiency that is practical and cost effective • Ensure that architectural design documentation is captured, maintained, understood by and available to business and/or IT partners • Participate in, or facilitate, business process, architectural sessions, and requirement sessions to ensure that all fully understand the requirements and the data necessary to support those requirements • Perform architectural design, develop, test and manage ETL jobs to specifications and design • Participate in focus group sessions as needed for information discovery on various architectural designs • Architectural designing and documenting conversion and interface specifications • Use design knowledge and experience in Microsoft s SSIS ETL and DOT NET technology • Use ETL and SQL for architectural performance tuning and concepts • Design/produce high quality, bug free and highly scalable work • Architect and code in various shell scripting languages • Design and perform independent data research • Architect, design, code test, and promote to production SSIS ETL, SQL, and Scripts • Architecturally design, code test, and promote to production SQL using MS SQL Server • Interface with various internal and external clients on a design and practical level • Document architectural designs, codes, and test plans • Troubleshoot ETL job and data issues • Re-architect existing ETL, data and process issues on an as needed basis Requirements Qualification Software Architect makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large-scale software system. Expert 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at 1. 84 Months of Experience Architecting Complex SSIS ETL Development 2. 84 Months of Experience Coding Complex ETL Job Architecture 3. 84 Months of Experience with the architecting of RDBMS Concepts, architecting Complex Stored Procedures, and architecting complex SQL in MS SQL Server 4. 24 Months of Experience architecting and coding Application ETL Design and Development Solutions 5. 84 Months Performing Complex Architecting Designs/Work with Little or No Supervision 6. 24 Months of Experience with Architecture and Code Interfaces to DOT NET, XML, and MS Dynamic CRM 7. 84 Months of Architectural Experience of Full Lifecycle Staging, ODS, Data Mart and DWH Experience in ETL Data Integration 84 Months of Experience in Shell/Power Shell/Bash Script Program Architecture and Development. 9. Bachelor s Degree from an accredited University Requested Documentation Please submit copy of resume, certificate, degree, etc.
Description The candidate will design and assist with the implementation of both small and large-scale software systems. The Software Architect will design, develop, implement, support and enhance, custom applications written in Java, .NET, Grails, ColdFusion or other programming languages. Ensure user interfaces and back-end services are developed according to architecture, programming and user experience (UX) standards. Solutions include interfaces with COTS solutions, mapping API s and applications, and other existing enterprise systems. Provide a list of the day to day tasks to be performed by the Selected Candidate: This individual will be expected to provide expertise and guide development efforts in the following activities: • Provide oversight on the analysis and design for enterprise applications using JAVA/JEE, GRAILS, JSF, XML, XSLT; • Expected to guide in the development of applications throughout the SDLC, including the redesign of legacy applications written in older technologies such as ColdFusion, VB, and Access; • Implement standards related to application technologies, including UI standards, development methodology, and coding and style guides; • Develop and guide quality assurance processes including code reviews, performance testing, security scans, and adherence to industry, state, and federal standards; • Identify and escalate technical risks and issues appropriately; • Guide and engage in development activities which may include data analysis, data structures, data manipulation, preparing logical database models. • Prepare, and/or review technical documentation such as system architecture designs, schemas, solution proposals, as appropriate. Requirements Mandatory Qualification Architect makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large-scale software system. Expert 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
03/16/2026
Description The candidate will design and assist with the implementation of both small and large-scale software systems. The Software Architect will design, develop, implement, support and enhance, custom applications written in Java, .NET, Grails, ColdFusion or other programming languages. Ensure user interfaces and back-end services are developed according to architecture, programming and user experience (UX) standards. Solutions include interfaces with COTS solutions, mapping API s and applications, and other existing enterprise systems. Provide a list of the day to day tasks to be performed by the Selected Candidate: This individual will be expected to provide expertise and guide development efforts in the following activities: • Provide oversight on the analysis and design for enterprise applications using JAVA/JEE, GRAILS, JSF, XML, XSLT; • Expected to guide in the development of applications throughout the SDLC, including the redesign of legacy applications written in older technologies such as ColdFusion, VB, and Access; • Implement standards related to application technologies, including UI standards, development methodology, and coding and style guides; • Develop and guide quality assurance processes including code reviews, performance testing, security scans, and adherence to industry, state, and federal standards; • Identify and escalate technical risks and issues appropriately; • Guide and engage in development activities which may include data analysis, data structures, data manipulation, preparing logical database models. • Prepare, and/or review technical documentation such as system architecture designs, schemas, solution proposals, as appropriate. Requirements Mandatory Qualification Architect makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large-scale software system. Expert 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Description Project/Program Name: DOH Medical Transparency Website Design and Implement REST web-services using Java, Sprint Boot, JSON and ElasticSearch for the Medical Transparency Website project. a list of the day to day tasks to be performed by the Selected Candidate: The candidate would be responsible for the following day to day tasks: 1. Design, Build and Implement highly scalable Java REST API s using ElasticSearch. 2. Assist the State Architect in building data structures for low latency applications using ElasticSearch and ElasticCache. 3. Build java-based applications using Spring Framework with integration to ElasticSearch. 4. Write complex queries with joins and aggregate that deals with large datasets. 5. Build and Deploy Java REST API s using DevOps automation tools such as Git, Jenkins & Artifactory. 6. Design and develop low-level API interfaces. 7. Design and develop low-level data structures using JSON. Requirements: Mandatory Qualification Software Developer will be involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software. 84 Months: Candidate can work independently, without assistance and provides guidance to others. Qualification 1. 48 Months of Experience in developing Java REST-based API s 24 Months of Experience in designing and developing Java-based applications using ElasticSearch 3. 60 Months of Experience in developing Java-based MVC web applications using Spring Framework 36 Months of Experience in designing data models using JSON 5. 36 Months of Experience in building automation scripts and deploying Java-based web applications using DevOps tools such as Git, Jenkins & Artifactory 6. 24 Months of Experience in designing and developing solutions using the Elastic stack (ElasticSearch, Kibana & Logstash) 24 Months of Experience in creating indexes and analytics on ElasticSearch data 36 Months of Experience in advanced database design, data modeling and data integration 9. 24 Months of Experience in distributed logging and metrics framework Bachelor s Degree
03/16/2026
Description Project/Program Name: DOH Medical Transparency Website Design and Implement REST web-services using Java, Sprint Boot, JSON and ElasticSearch for the Medical Transparency Website project. a list of the day to day tasks to be performed by the Selected Candidate: The candidate would be responsible for the following day to day tasks: 1. Design, Build and Implement highly scalable Java REST API s using ElasticSearch. 2. Assist the State Architect in building data structures for low latency applications using ElasticSearch and ElasticCache. 3. Build java-based applications using Spring Framework with integration to ElasticSearch. 4. Write complex queries with joins and aggregate that deals with large datasets. 5. Build and Deploy Java REST API s using DevOps automation tools such as Git, Jenkins & Artifactory. 6. Design and develop low-level API interfaces. 7. Design and develop low-level data structures using JSON. Requirements: Mandatory Qualification Software Developer will be involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software. 84 Months: Candidate can work independently, without assistance and provides guidance to others. Qualification 1. 48 Months of Experience in developing Java REST-based API s 24 Months of Experience in designing and developing Java-based applications using ElasticSearch 3. 60 Months of Experience in developing Java-based MVC web applications using Spring Framework 36 Months of Experience in designing data models using JSON 5. 36 Months of Experience in building automation scripts and deploying Java-based web applications using DevOps tools such as Git, Jenkins & Artifactory 6. 24 Months of Experience in designing and developing solutions using the Elastic stack (ElasticSearch, Kibana & Logstash) 24 Months of Experience in creating indexes and analytics on ElasticSearch data 36 Months of Experience in advanced database design, data modeling and data integration 9. 24 Months of Experience in distributed logging and metrics framework Bachelor s Degree
Description: Program Name: Office of the Professions, OP Modernization Program Programmer will create online services in Java to aid the OP Modernization Program s multiple projects that are migrating from a mainframe system to an Oracle database. Provide a list of the day to day tasks to be performed by the Selected Candidate: The candidate will work alongside the current development team to define technical requirements and approach to implement online services that are being rewritten in Java and related Web technologies. The work will involve participation in Scrum meetings to define project work and identify quality assurance testing for all development components. The programmer will assist with extending existing RESTful services for data transmission and user authentication in newly developed user interfaces and backend system. Requirements Qualification Programmer: Creates computer software. May specialize in one area of computer software or may write code for many kinds of software. Mid-Level: 36-60 months, candidate is able to work independently, without assistance. 1. 60 months of experience developing front-end and back-end Web applications in Java 2. 60 months of experience building applications with the Spring Framework 3. 48 months of experience developing technical architecture within a Service Oriented Architecture 48 months experience developing RESTful services 36 months experience developing responsive websites 6. Bachelor s degree Documentation Please provide copy of resume as well as vendor-screening documentation for candidate.
03/16/2026
Description: Program Name: Office of the Professions, OP Modernization Program Programmer will create online services in Java to aid the OP Modernization Program s multiple projects that are migrating from a mainframe system to an Oracle database. Provide a list of the day to day tasks to be performed by the Selected Candidate: The candidate will work alongside the current development team to define technical requirements and approach to implement online services that are being rewritten in Java and related Web technologies. The work will involve participation in Scrum meetings to define project work and identify quality assurance testing for all development components. The programmer will assist with extending existing RESTful services for data transmission and user authentication in newly developed user interfaces and backend system. Requirements Qualification Programmer: Creates computer software. May specialize in one area of computer software or may write code for many kinds of software. Mid-Level: 36-60 months, candidate is able to work independently, without assistance. 1. 60 months of experience developing front-end and back-end Web applications in Java 2. 60 months of experience building applications with the Spring Framework 3. 48 months of experience developing technical architecture within a Service Oriented Architecture 48 months experience developing RESTful services 36 months experience developing responsive websites 6. Bachelor s degree Documentation Please provide copy of resume as well as vendor-screening documentation for candidate.