Systems Analysis and Data Conversion - SQL, Java

The person in this position: Must analyze the structure, content and quality of the data to be converted. Map the data elements from the source tables to target tables ensuring that all necessary data is accounted for. Convert the data from the source tables into the target format tables. Validate the accuracy and integrity of the converted data. Document the data conversion process to include how issues were resolved with particular data elements Clearly communicate with stakeholders the data conversion plan Systems Analyst responsibilities include, but are not limited to the following: Planning, Organizing, Integrating, and Implementing requirements with system interfaces, scheduled processes (jobs), functions and features Adhering to Project Control Processes, Procedures, and Change Control Technical issue identification and resolution Deployment and Implementation Planning Technical leadership in data conversion strategies for successful implementation Provide detail and summary reporting to the Project Manager on the progress of completing assignments by the developers Develop the programming architecture for converting the data to the new structure Coordinate effectively with Information Technology Services (ITS) staff required to support the project Effectively work with the Office of Statewide Investigative Systems (OSIS) Enforcement and Investigative Services (EIS) Leadership and MEPIC members throughout the software development life cycle to complete this project Deliverables: Documented Detailed Data Conversion Plan Converted data ready for import in to the target SQL system Reports to support the accurate results of the converted data Identification of issues immediately with recommendations to mitigate Assistance to the Project Manager ensuring Action Items, Decisions, and optimal design is documented Contributor to the Operations & Maintenance Plan Knowledge transfer to the ITS Maintenance Team Mandatory Skills and Experience: Bachelor's Degree in Computer Science, Business Administration, or other related Information Technology (IT) fields Minimum of 7 years of work experience designing successful, large-scale IT projects Proficient database management system skills to build SQL scripts to extract, transform, and load data from old structures to new structures Analysis and understanding of data structures and schemas Ability to troubleshoot and resolve issues that arise during the data conversion process Ability to clearly communicate with team members and stakeholders about the data conversion process and any issues that arise Ability to manage multiple tasks simultaneously and to work under tight deadlines Understanding the system from which the data is being moved from and to Ability to handle sensitive data responsibly Strong SQL programming skills Experience in completing the SQL scripts to convert the data within the schedule timeline Excellent oral and written communication skills Strong collaboration skills with stakeholders and project team Ability to communicate the technical data conversion design in non-technical terms for the end-users to understand Experience working in a multi-vendor project team members Technical understanding of data conversion projects Experience designing and programming in development projects J2EE/Java (JSP, EJB) JBoss 7.x application servers JDBC MS-SQL 2019 database PL/SQL stored procedures, triggers, views, etc. XML Preferred Knowledge Skills and Abilities: Government, Law Enforcement, or Public Safety IT projects Master's Degree in Computer Science, Business Administration, or other related IT fields or equivalent Project Management work experience Required Skills : J2EE,SQL,Java Additional Skills : Systems Analyst,Database Developer,Big DataThis is a high PRIORITY requisition. This is a PROACTIVE requisition

Created: 2026-03-10