Professional Services Consultant II
Company: Centralsquare Technologies
Location: Washington
Posted on: January 28, 2023
|
|
|
Job Description:
Job DescriptionJob SummaryThis 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 minimal supervision with some latitude
for independent judgment and quality of life improvements (automate
scripting when possible). We work closely with our clients to
effectively shape the data into a structure they can trust moving
forward using their CentralSquare product 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
customer satisfaction.
Job Duties Include: Write, modify, and troubleshoot complex SQL
queries, ETL (Extract, Transform, Load) processes, and Python
scripts. 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. Communicate directly
with customer agencies and Project Managers throughout
implementation projects to clarify questions that arise regarding
data mapping. Demonstrate converted data in the target system,
understand any modifications needed, and verify results of
modifications. Mentor and train other members of the team. Analyses
long-running conversion processes and tune for optimum performance.
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. 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 the configuration of agencies
CentralSquare systems. Perform tests and execute the final data
conversion at the time of system go-live. Works independently.
Seeks guidance from leadership or more experienced staff as needed.
Identify deficiencies in converted data and work to resolve them.
Analyses data on legacy systems to estimate project scope and
length. Performs all other duties as assigned.Requirements: 2-5
years of experience Associate's or Bachelor's Degree in a
technology-related field or related 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 Working
Python experience Ability to make technical problems understandable
to non/technical customersby Jobble
Keywords: Centralsquare Technologies, Washington DC , Professional Services Consultant II, Other , Washington, DC
|
Click
here to apply!
|
