Home › Jobs › Caselle

Technical Consultant I

Caselle · Remote · Provo, Utah · Posted October 13, 2026 (37 days ago)

Apply on Caselle’s siteFill the application with AutoFillSee your fit for this role

Job description

About us

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.

About 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.

Responsibilities

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

Required qualifications

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

Benefits

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.

Posting 4242228 on applicantpro. Source: the employer’s listing. Valid through November 27, 2026 unless closed earlier.