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
12/27/2025
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.
12/27/2025
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.
Senior SQL/Oracle 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. 60-84 months Candidate able to work independently, without assistance and provides guidance to others. May have an advanced education. Requirements: 84 Months experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc. 84 Months experience in a data modeling tool (e.g., ErWin, ER/Studio). 84 Months experience in relational data management disciplines and design and development experience using Oracle technologies. 84 Months experience with SQL programming. 60 Months experience working with business intelligence tools (e.g., OBIEE 11G). 60 Months experience working with ETL tools (e.g. Informatica). 60 Months experience with designing, creating applications and health care Data Warehouse and business intelligence reporting solutions. 48 Months experience working with HIPAA requirements or similar standards and NYS Accessibility Standards. 48 Months experience with reviewing the data modeling of others for compliance and accepted standards of development.
12/27/2025
Senior SQL/Oracle 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. 60-84 months Candidate able to work independently, without assistance and provides guidance to others. May have an advanced education. Requirements: 84 Months experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc. 84 Months experience in a data modeling tool (e.g., ErWin, ER/Studio). 84 Months experience in relational data management disciplines and design and development experience using Oracle technologies. 84 Months experience with SQL programming. 60 Months experience working with business intelligence tools (e.g., OBIEE 11G). 60 Months experience working with ETL tools (e.g. Informatica). 60 Months experience with designing, creating applications and health care Data Warehouse and business intelligence reporting solutions. 48 Months experience working with HIPAA requirements or similar standards and NYS Accessibility Standards. 48 Months experience with reviewing the data modeling of others for compliance and accepted standards of development.
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
12/27/2025
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 : Under the general direction of Application Team Lead/Architect, with latitude for independent initiative and judgment is responsible for planning, designing, developing, installing, enhancing, testing, troubleshooting, integrating and supporting the application in the Microsoft .NET environment. Makes high-level design choices and dictates technical standards, including software coding. Provide a list of the day to day tasks to be performed by the Selected Candidate: • Develops High-level design choices, re-enforces technical standards, works with application development in developing coding standards, selects developments tools and platforms. • Develops project architecture and reusable components for Advance/APPR platform. • Develops and implements phases of the computerized system development life cycle, including conceptual design, software development, testing, deployment, and post-implementation enhancements of applications utilizing Visual Studio .NET with SQL Server for data management and Active Directory for identity management, in accordance with Department of Education standards. • Analyze requirements and data access needs and propose file and screen designs. Deploys the applications to multiple environments, from development through Quality Assurance, Staging and Production, and conduct unit and integration testing. • Design and develop complex user interfaces using ASP.Net & Kendo/Telerik controls. • Designs database tables utilizing import or export data from SQL Servers into other data sources on a daily basis through the development and coding of stored procedures and triggers, as needed. • Utilizes Microsoft Team Foundation Server (TFS) for source control, data collection, reporting and project tracking, testing and collaboration of project development. • Develops SQL Server Integration Services (SSIS) packages and Web Services. • Codes new objects (programs) in .NET to meet the requirements of the Department of Education. • Conducts user acceptance review sessions and collaborates with other team members to perform debugging. 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. 1. 84 months of experience in developing web application using software development life cycle. 2. 24 months experience in leading a development team during the development process. 12 months of experience in transactional and dimensional database design. 12 months of experience in designing Object oriented programs and System Analysis Skills. 5. 24 months of experience in developing stored procedures that interface with SQL Server 6. 36 months of experience designing and developing Web applications using VISUAL (link removed), ASP.Net, (link removed), Telerik, XML, HTML, VB.NET, C#.NET, MVC, SQL Server 2012/2016, Internet Security. 24 months of experience on Team Foundation Server, .NET framework and .NET core Active Directory, LDAP, Cognos reporting knowledge 12 months of experience in developing and supporting multiple projects at given time 9. Bachelor s Degree 10. Any Microsoft or similar developer certificate Requested Documentation Please submit copy of resume, certificate, degree, etc.
12/27/2025
Description : Under the general direction of Application Team Lead/Architect, with latitude for independent initiative and judgment is responsible for planning, designing, developing, installing, enhancing, testing, troubleshooting, integrating and supporting the application in the Microsoft .NET environment. Makes high-level design choices and dictates technical standards, including software coding. Provide a list of the day to day tasks to be performed by the Selected Candidate: • Develops High-level design choices, re-enforces technical standards, works with application development in developing coding standards, selects developments tools and platforms. • Develops project architecture and reusable components for Advance/APPR platform. • Develops and implements phases of the computerized system development life cycle, including conceptual design, software development, testing, deployment, and post-implementation enhancements of applications utilizing Visual Studio .NET with SQL Server for data management and Active Directory for identity management, in accordance with Department of Education standards. • Analyze requirements and data access needs and propose file and screen designs. Deploys the applications to multiple environments, from development through Quality Assurance, Staging and Production, and conduct unit and integration testing. • Design and develop complex user interfaces using ASP.Net & Kendo/Telerik controls. • Designs database tables utilizing import or export data from SQL Servers into other data sources on a daily basis through the development and coding of stored procedures and triggers, as needed. • Utilizes Microsoft Team Foundation Server (TFS) for source control, data collection, reporting and project tracking, testing and collaboration of project development. • Develops SQL Server Integration Services (SSIS) packages and Web Services. • Codes new objects (programs) in .NET to meet the requirements of the Department of Education. • Conducts user acceptance review sessions and collaborates with other team members to perform debugging. 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. 1. 84 months of experience in developing web application using software development life cycle. 2. 24 months experience in leading a development team during the development process. 12 months of experience in transactional and dimensional database design. 12 months of experience in designing Object oriented programs and System Analysis Skills. 5. 24 months of experience in developing stored procedures that interface with SQL Server 6. 36 months of experience designing and developing Web applications using VISUAL (link removed), ASP.Net, (link removed), Telerik, XML, HTML, VB.NET, C#.NET, MVC, SQL Server 2012/2016, Internet Security. 24 months of experience on Team Foundation Server, .NET framework and .NET core Active Directory, LDAP, Cognos reporting knowledge 12 months of experience in developing and supporting multiple projects at given time 9. Bachelor s Degree 10. Any Microsoft or similar developer certificate Requested Documentation Please submit copy of resume, certificate, degree, etc.
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.
12/27/2025
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.