CentralSquare Technologies is Hero-Grade. As the trusted provider of public sector software in North America, more than 8,000 agencies rely on our comprehensive, cloud-based platform to manage critical operations – from dispatch to records, permitting to payroll. We serve with purpose and stand together with our heroes, committed to supporting the public sector with software built for impact.
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 Opportunity
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 direct supervision. 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.
Job Duties include:
- Write, modify, and troubleshoot somewhat complex SQL queries, ETL (Extract, Transform, Load) processes.
- Obtain data from their legacy system and determine how best to translate it into the destination system.
- Present converted data in the target system to clients, make any modifications needed, and verify results of modifications.
- Analyze 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.
- Seek guidance from leadership or more experienced staff as needed.
- Analyze data on legacy systems to estimate project scope and length.
- Performs all other duties as assigned.
Requirements:
- Associate's or 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
- Ability to work collaboratively with internal and external clients
CJIS Clearance
A required part of the onboarding process for this role involves obtaining CJIS (Criminal Justice Information Services) clearance—a critical credential for safeguarding public safety data. At CentralSquare, we’ll stand with you every step of the way to secure this clearance should you be selected for hire. As part of the process, a comprehensive background check will be conducted, and please note that U.S. citizenship or permanent residency is generally required to obtain CJIS clearance.
CentralSquare Technologies: Where Mission Meets Innovation
CentralSquare Technologies is proud to be an Equal Opportunity Employer. We are committed to fostering a workplace that is inclusive, respectful, and free from discrimination—where all individuals are valued, supported, and provided equal opportunity to succeed.
We place a strong emphasis on supporting military veterans and their spouses and recognize the leadership, discipline, resilience, and mission-oriented mindset they bring to the workforce. The skills developed through military service—such as accountability, teamwork, adaptability, and the ability to perform under pressure—are highly valued at CentralSquare and directly contribute to our success.
In addition to our commitment to veterans, CentralSquare Technologies welcomes and encourages applicants from all backgrounds. We are committed to equal employment opportunity for all qualified individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, disability, veteran status, or any other characteristic protected by applicable federal, state, or local law.
Our employees reflect a wide range of experiences, perspectives, and identities, and this diversity strengthens our ability to innovate and serve the public sector, whether through our public safety or public administration businesses. Through our technology, we support public servants and the communities they serve, and we believe our workforce should reflect those communities as well.
If you are seeking an opportunity to contribute to meaningful work that impacts communities nationwide—whether continuing a legacy of service or beginning a new chapter—CentralSquare Technologies invites you to apply.
Your next mission starts here.
