Data Conversion Engineer II

What We’re About

At CentralSquare, you’ll get the opportunity to work in a collaborative environment within a company that builds complex web-based enterprise applications for our Public Servants across North America. As over 250 Million citizens in the US are impacted by CentralSquare Software, we are on a trajectory to revolutionize the way agencies address citizens’ needs by improving quality of life and building safer, smarter communities...and we need great candidates to do it!

Looking to grow your career? That’s great! Hard work should be rewarded, and we are committed to cultivating careers while providing competitive compensation and a great benefits package, including tuition reimbursement, parental leave, paid volunteer hours, and unlimited PTO. Our flexible work environment also enables you to take advantage of an excellent work-life balance whether you are in office or working remotely.

The Role:

This role is responsible for extracting and transforming data from our client's legacy database systems and loading that data into their new CentralSquare software system. This role works with moderate supervision with some independent judgment. We work closely with our clients to effectively shape the data into a structure they can trust moving forward using their CentralSquare products in a way that works best for them. The work performed in this role will directly impact the productivity and effectiveness of the overall project and lead to client satisfaction.

Job Duties Include:

Write, modify, and troubleshoot complex SQL queries, ETL (Extract, Transform, Load) processes.
Work collaboratively with clients undergoing project implementation to obtain data from their legacy system and determine how best to translate it into the destination system.
Communicate effectively with Project Managers, Consultants and other internal groups throughout the implementation process. 
Present converted data in the target system to clients, make any modifications needed, and verify results of modifications.
Contribute to technical team discussions.
Analyses long-running conversion processes and tune for optimum performance, with oversight.
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 the target system.
Assist in maintaining documentation for data conversion processes.
Perform tests and execute the final data conversion at the time of system go-live.
Work colaberatively, ask questions when needed, and share knowledge when able.
Seek guidance from leadership or more experienced staff as needed.
Analyses data on legacy systems to estimate project scope and length.
Performs all other duties as assigned.

Requirements:

• Bachelor's Degree in a technology-related field or related experience
• 2-5 years of experience
• Ability to continually pass background check requirements for working on and connecting to public safety and/or public administration information systems (if required).
• Intermediate SQL skills.
• Python/PowerShell experience preferred.
• Salesforce experience preferred.
• Ability to make technical problems understandable to non/technical clients.

•

Last updated on Jun 10, 2024