Reference # 19-00635 Title SQL Database/Business Analyst
Location Phoenix, ARIZONA
Position Type Contract
Experience Level Contract
Start Date / End Date 01-10-2019 --- 31-10-2019
Description
Position Description A SQL Database/Business Analyst with strong experience in writing SQL queries, analyzing and integrating data from legacy system. This position is responsible for the data mapping, validation and any data migration between the legacy Time Matters systems at the Office of Legal Advocate to the Justware system at the Office of Public Defense services. Extensive experience with data conversions and data mapping is required. Position will require development of scripts to convert and import data from existing legacy case management systems that are contained in disparate database environments into a single SQL database environment. Prefer experience in large-scale data integration projects that required learning the systems and data structure with limited information. Scope: The SQL Database/Business Analyst shall provide the services in this section: " Data mapping, conversions and data integration. " Interaction with SME and Business for clarification of business rules and requirements " Interaction with Program Manager " Fully document source code Background: The Time Matters database systems were converted to Justware but due to conflicting requirements, not all the data was converted, and the data needs to be evaluated to determine what is missing, map the missing data and integrate the missing data into Justware. The Time Matters database systems are on legacy servers and could possibly crash at any time. The data needs to be converted. The project requires additional development support to expedite completion of programming tasks.
Skills Required Candidate must interface with existing database and table structure and have the ability to develop SQL queries, convert and export/import data. Candidate must be able to learn case management systems and business terms quickly. " Assess and make recommendations for data conversions and associated scripts to ensure SDLC standards and best practice " Develop scripts to convert and import data from existing legacy case management systems from disparate database environments into a single SQL database environment " Knowledge transfer and final technical documentation " Apply SDLC standards and best practice " Ability to work with limited supervision independently or in a team environment " Excellent verbal and communication skills a must " Preference given to candidates with MS SQL Server knowledge and integration and loading of data via SSIS (integration) " Knowledge of legal and/or case management systems a plus " Knowledge of the Justware product is a plus
Skills Preferred " Knowledge of legal and/or case management systems a plus " Knowledge of the Justware product is a plus
Experience Required " Requires a minimum of 5 years of data migration including data mapping between legacy and new system. " Requires a minimum of 3 years SQL experience
Experience Preferred " Knowledge of legal and/or case management systems a plus " Knowledge of the Justware product is a plus
Education Required Requires a Bachelor's degree in Computer Programming, Computer Information Systems (CIS), Computer Science, or other related field; or, an equivalent combination of training and progressively responsible experience that will result in the required specialized knowledge and abilities to perform the assigned work.
Education Preferred
Additional Information Deliverables: Candidate must interface with existing database and table structure and have the ability to develop SQL queries, convert and export/import data. Candidate must be able to learn case management systems and business terms quickly. " Assess and make recommendations for data conversions and associated scripts to ensure SDLC standards and best practice " Develop scripts to convert and import data from existing legacy case management systems from disparate database environments into a single SQL database environment " Knowledge transfer and final technical documentation " Apply SDLC standards and best practice