ABOUT CASELLE
Caselle is a leading provider of integrated ERP and enterprise software solutions purpose-built for local government. For over 40 years, we have partnered with municipalities, counties, and special districts across the United States to modernize their operations-from finance and utilities to payroll and asset management. Our cloud-forward platform empowers public servants to serve their communities more effectively, and our team is driven by the belief that better technology leads to better government.
THE ROLE
As a Technical Consultant I, you will support the data conversion pipeline that enables municipal clients to migrate from legacy systems to Caselle's ERP platform. Working under the guidance of senior technical staff, you will write TSQL queries and scripts to extract, transform, and load client data into MSSQL databases in Caselle-compatible formats. You will validate conversion accuracy, troubleshoot data issues, and collaborate with System Consultants and Project Managers to meet project deadlines. This is an ideal role for someone with foundational SQL skills who wants to build deep expertise in ERP data conversion.
WHAT YOU'LL DO
- Write TSQL queries and scripts to map and convert client data from existing sources into Caselle-compatible MSSQL database formats
- Extract, transform, and load (ETL) customer data received in varying formats into structured MSSQL databases
- Validate converted data against source records to ensure accuracy, integrity, and completeness
- Assist clients with Caselle data layouts and formats used in the conversion process
- Troubleshoot data corruption, missing data, and formatting issues in client source files
- Utilize data mining and report-writing tools (e.g., Datawatch Monarch) to analyze and process client data
- Collaborate with System Consultants and Project Managers to coordinate conversion milestones and meet deadlines
- Maintain confidentiality of sensitive client data throughout the conversion process
- Document conversion processes and contribute to building repeatable procedures and templates
WHAT WE'RE LOOKING FOR
Required
- 1-3 years of experience working with TSQL, SQL Server, or relational databases in a professional setting
- Foundational understanding of ETL processes and data conversion concepts
- Ability to read and write TSQL queries, joins, and basic stored procedures
- Strong attention to detail-data accuracy is critical in this role
- Ability to manage multiple conversion tasks simultaneously and meet project deadlines
- Clear communication skills-able to work with both technical and non-technical team members
- Proficiency with Microsoft SQL Server Management Studio and Microsoft Office
- Associate's or Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience)
Preferred
- Exposure to data conversion or migration projects in a software implementation context
- Familiarity with accounting, finance, or utility billing data structures
- Experience with data mining or report-writing tools
- Knowledge of municipal government or public sector data environments
WHAT WE OFFER
- Mission-Driven Work: Help local governments deliver better services to their communities
- Flexibility: Remote-eligible role with a collaborative team based in Provo, UT
- Growth: Join a company investing in its next generation of products and expanding its market presence
- Comprehensive Benefits: Competitive compensation, health/dental/vision insurance, 401(k), PTO, and professional development support
- Work-Life Balance: Standard Monday-Friday schedule with minimal travel requirements
WORK ENVIRONMENT
Primarily office-based or remote role involving standard computer work. Minimal travel is required. The position requires the ability to manage moderate to high levels of stress associated with deadline-driven conversion projects.
Caselle is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this role.
1-3 years TSQL/SQL Server experience; ETL knowledge; ability to write queries and stored procedures; attention to detail; communication skills; proficiency with Microsoft SQL Server Management Studio and Microsoft Office; Associate's or Bachelor's in Computer Science or related field.
Key Responsibilities
- writing TSQL queries
- converting data
- troubleshooting data issues
Skills & Tools
TSQL, SQL Server, Microsoft SQL Server Management Studio, Microsoft Office, Datawatch Monarch
Job Details
- Category: Information Technology
- Seniority: Entry Level
- Commitment: Full Time
- Workplace: Remote — Provo, Utah, United States
- Salary: USD 60,000 – 85,000 / year
- Languages: English
Benefits
- Generous paid time off
- Retirement plan
About Caselle
A leading provider of integrated ERP and enterprise software solutions for local government. — Industry: Information Technology