Data Conversion Analyst
CentralSquare Technologies | Professional Services
**This position can be worked out of our Greensboro, NC or Sioux Falls, SD office locations.
The Data Conversion Analyst plans, develops and executes the extraction of data from Public Safety (Administration, Computer Aided Dispatch, Records Management, Jail Management, Civil and Courts) legacy systems and loads it into Centralsquare Software. This position works with minimal supervision and some latitude for independent decision making.
Work collaboratively with customer agencies undergoing project implementation to obtain data from their legacy system, understand what it means and how it is used, and determine how best to translate it into the destination system.
Excellent verbal and written communication skills. Possess the ability to make a technical problem understandable to non/technical customers
Write, modify, and troubleshoot complex SQL queries, ETL (Extract, Transform, Load) processes, and Python scripts.
Identify deficiencies in converted data and work to resolve them.
Analyze data on legacy systems to estimate project scope and length.
Develop and maintain an understanding of application software including functionality and database schema; use this knowledge to make informed decisions regarding data mapping and to review data within target system.
Communicate directly with customer agencies and Project Managers throughout implementation projects to clarify questions that arise regarding data mapping, demonstrate converted data in target system, understand any modifications needed, and verify results of modifications.
Create and maintain documentation and wikis for data conversion processes; seek out process improvements.
Manipulate and load data such as code tables from secondary additional sources to assist in configuration of agencies’ CentralSquare Technologies systems.
Perform tests and execute the final data conversion at time of system go-live.
Analyze long running conversion processes and tune for optimum performance.
Education: Associate’s or bachelor’s degree in a technology-related field or related experience.
Specialized knowledge: Previous experience performing data conversion, data migration, and ETL. Proficiency with at least one programming language, preferably SQL.
Computer skills: Experience with PostgreSQL, SQL Server or other RDBMS; an ETL tool such as MS SQL Server Integration Services (SSIS); Microsoft Office Suite
Experience: 1-2 or more years customer facing experience with 1-2 or more years’ experience writing SQL.
Competencies: Ability to learn new applications and processes quickly. Passion for technology; eager to learn new tools and technologies. Strong customer-facing skills and personal interaction/interpersonal skills. Ability to adapt quickly to changing business and customer needs, maintaining a high degree of flexibility. Self-motivated; able to work independently.