System Analyst

JOB ROLE :-   SYSTEMS ANALYST

JD

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 FDLE 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

·         Design and optimize a database

·         Develop the programming architecture for converting the data to the new structure

·         Write stored procedures, triggers, and SSIS packages for data management and migration.

·         Coordinate effectively with FDLE Information Technology Services (ITS) staff required to support the project

·         Effectively work with the multiple FDLE Divisions throughout the software development life cycle to complete this project

·         Offer solutions to problems and challenges related to data or otherwise

Deliverables:

·         Documented Detailed Data Conversion Plan

·         Converted data ready for import in to the target Microsoft SQL server database

·         Data conversion stored procedures

·         Reports to support the accurate results of the converted data (old and new 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 FDLE ITS MEPIC 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, middle to large-scale IT data conversion projects, of which 2 years must be as the lead data conversion person

·         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 an environment with multi-vendor project team members

·         Technical understanding of data conversion projects

·         Experience designing and programming in development projects, with the following:

·         J2EE/Java (JSP, EJB)

·         JBoss 7.x application servers

·         JDBC

·         MS-SQL 2019 database

·         PL/SQL stored procedures, triggers, views, etc.

·         XML