Technical Consultant I

Caselle Inc; Provo (UT); Hybrid; USD 60,000 - 90,000; Full time

Benefits offered by this job

Remote-eligible role

Health/dental/vision insurance

401(k)

PTO

Professional development

Job summary

Caselle Inc. in Provo, UT is seeking a Technical Consultant I to support municipal data conversions, writing TSQL queries and ETL scripts to load client data into Caselle MSSQL databases.

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 building deep ERP data conversion expertise while contributing to local government modernization.

Qualifications

• 1-3 years of experience with TSQL/SQL Server or relational databases
• Foundational understanding of ETL processes and data conversion concepts
• Read and write TSQL queries, joins, and basic stored procedures
• Strong attention to data accuracy and ability to manage multiple tasks
• Clear communication with technical and non-technical teammates
• Proficiency with MS Office and SQL tooling
• Associate's or Bachelor's degree in CS/IS or related field (or equivalent experience)

Responsibilities

• Write TSQL queries and scripts to map and convert client data into Caselle MSSQL formats
• ETL: extract, transform, load client data from varying sources
• Validate converted data against source records for accuracy and completeness
• Assist clients with Caselle data layouts used in conversion
• Troubleshoot data corruption and formatting issues in source files
• Use data mining/reporting tools to analyze client data
• Coordinate with System Consultants and Project Managers to meet milestones
• Maintain confidentiality of client data
• Document conversion processes and build repeatable procedures

Skills

T-SQL/SQL Server

Relational databases

Attention to detail

Communication

Office software

Education

Associate's or Bachelor's degree in Computer Science/Information Systems

Tools

Microsoft SQL Server Management Studio

Excel

Job description

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.