Job Description

Reference # : 20-00315Title : Systems Analyst
Location : New York, NY
Position Type : Contract
Experience Level : Start Date / End Date : 04/16/2020 / 04/16/2022
The Systems Analyst role is responsible for analysis and testing of multiple Department of Early Childhood Education (DECE) applications that support and meet key objectives, ensuring continued systems infrastructure, data integrity, system performance and availability. This includes understanding all Business Flows, Writing and Maintaining Data Dictionaries, providing scripts for all testing and ensuring all code developed is of the highest quality. The technical position is responsible for the development, maintenance and execution of all quality control deliverables including test cases, test scripts, test plans, status reports, traceability matrices, analysis of defects and testing results. Performs all related work as directed by the manager.

Completes all assigned functional, regression, performance, and tests of applications within the appropriate timeline.
-Participates in project-level planning and reviews and approvals sessions, which includes business requirements and Application Software Requirements/Design review meetings.
-Analyze and understand ETL structural mapping and technical specification documents. Create test cases to perform Sanity, Functional, Regression, Database and ETL Testing. Analyze and report on complex data; both source and target systems to identify potential gaps in

mapping documentation.
-Design tests for DW/ETL source data extraction, business transformation logic and target table loading.
-Identify, analyze and document problems with functionality, output files, or tables. Monitor defect resolution efforts and track progress.
-Write complex SQL queries and develop solution diagrams to demonstrate new capabilities.
-Defines data quality test strategy and test plan in collaboration with project stakeholders.
-Designs, creates and maintains test data as needed to support data quality testing.
-Authors high level data quality test documentation including flows within the documentation to demonstrate test approach and proposed paths through the system.
-Produces data quality test results and analysis.
-Maintains test plan documentation as project progresses and works with project team stakeholders to get signoff on plan as well as to educate project stakeholders on data quality test requirements, plans and status.
-Participates in the analysis of requirements and specifications necessary to create data flow models.
-Successfully design and run smoke tests and regression test suites
-Collaborates with project Technical Project Manager and QA Director in developing and maintaining documentation describing test scope and test schedules.
-Identify Performance thresholds using client side & server side metrics and build load models
-Work closely under the direction of the Project and Development Managers with stakeholders from multiple DOE departments.


Please see our complete list of jobs at:

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online