Data Conversion Manager

About us ProPhoenix is a leader in the design and delivery of the most comprehensive, dynamic, and secure Public Safety software products in the industry. Established in 2003 and headquartered in Moorestown, New Jersey, ProPhoenix Corporation provides responsive, analytical, and manageable COTS (commercial-off-the-shelf) applications for Law Enforcement, Communication Centers, Fire/EMS, and Corrections Management. Job Description The Data Conversion Manager will work directly with customers, subject matter experts (SMEs) and development team to establish a conversion approach and complete the data conversion of Phoenix Law/CMS/Fire Record Management Systems. The Data Conversion Manager must understand technical data conversion issues, and expertly resolve issues and communicate solutions. Responsibilities: Analyze data on legacy systems to estimate project scope and duration. Assist customers with data extraction planning, explain the conversion process, define data requirements, and undertake other activities to prepare for data conversion. Develop and maintain an understanding of application software including functionality and database schema; use this knowledge to make informed decisions regarding data mapping and review data within the target system. Communicate directly with customer agencies and Project Managers throughout implementation projects to clarify questions arising regarding data mapping, demonstrate converted data in target system, understand any necessary modifications, and verify modifications results. Lead/direct the Development and other members of the Conversion team to develop new conversion tools and processes. Perform tests and execute the final data conversion at the time of system go-live. Required Skills: 5+ years of experience in data conversion management to and from SQL-Server databases, MySQL, AS 400, Oracle and various data sources. SQL Server query writing skills. SSIS experience with stored procedures, optimization, views and indexes. Expertise in the Law/CMS/Fire Record Management Systems. Preferred Skills: Strong knowledge of ETL processes, including a complete functional understanding with hands on experience using Microsoft SSIS packages for data migration between OLTP, staging and OLAP environments. Familiarity with control flow, data flow items, variable handling, expressions, SCD, Lookup, Merge Join, Precedence constraint and the ability to demonstrate the usage of each. SSIS Advanced component experience (transformation objects in data flow) Experience in SSIS administration, including how to create and manage complete ETL flows. Creation and management of SQL Integration Services packages to support ETL jobs and ad hoc tasks. Job Type: Full-time Benefits: Dental insurance Health insurance Schedule: Monday to Friday Ability to Relocate: Moorestown, NJ: Relocate before starting work (Required) Work Location: In person