Professional Services Consultant II
Centralsquare Technologies
What We’re About
At CentralSquare, we don’t just build software - we power public servants and uplift communities with Hero-Grade Technology. Every line of code, every feature we deliver helps heroes across North America protect, serve, and save lives. When you join us, you become part of a mission-driven team creating technology that makes communities safer and stronger.
Your Growth Matters. We believe heroes deserve opportunities to rise. That’s why we invest in your career with mentorship, learning programs, and clear paths for advancement. If you’re motivated, there’s no limit to how far you can go.
Your Commitment Deserves Reward. We offer competitive compensation and a benefits package designed to support your life inside and outside of work—tuition reimbursement, parental leave, paid volunteer hours, and unlimited PTO. Plus, our flexible work environment gives you the freedom to balance your heroic work with personal well-being, whether you’re in the office or remote.
Join us and help build the tools that power real-life heroes. Together, we make a difference.
The Role
The Financial Systems General Ledger consultant role requires ability to engage in discussions with customer's senior accounting and budget staff relating to new implementations, internal projects, and new service offerings, as a subject matter expert in Finance Enterprise General Ledger and Core Finance Systems. The consultant will have a passion for the customer demonstrated through professionalism and striving for excellence in all aspects of the customer experience. The Financial Systems Consultant must have proven experience implementing projects throughout the entire project lifecycle. This includes implementing complex projects to conclusion while maintaining high customer satisfaction. The role requires an individual who is resourceful, confident under pressure, and has demonstrated skill as a subject matter expert in multiple areas of the software.
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.