Data Migration Specialist

Description
Who We Are
Catalis is a leading government Software as a Service (SaaS) and integrated payments provider, powering a wide range of government operations at the municipal, county, state, and federal levels. Our innovative solutions are designed to streamline processes, enhance efficiency, and improve the delivery of government services to the public. At Catalis, we are committed to leveraging technology to make government interactions simpler, faster, and more accessible.

Join a dynamic team, focused on helping Municipal Governments "Connect and Simplify Municipal Information to help make data informed decisions." We are a data and service company with the goal of being an Alberta based technology company recognized across Canada. We are a small team that has seen year-over-year growth and is well positioned to increase our breadth and depth within the niche rural and small urban market, and we are looking for top-talent team members who can help take us to the next level.

What We Offer
Catalis is a fast growing and award-winning technology company that serves small urban and rural municipal governments across Canada. We offer competitive compensation, full paid vacation, and comprehensive health & dental benefits. We focus a lot of energy on professional development, offering free access to unlimited Udemy courses for personal and professional advancement, as we want our employees to ride the wave and grow with our business. We strive to be an example of a successful high-growth technology company in Alberta, and our team members depend on each other to make it happen.

This opportunity is based at Catalis' office in Old Strathcona (Edmonton, Alberta). Our new office includes an innovative vibe, stand-up desks for all staff, foosball games, an active workplace enrichment committee, fitness challenges, an office dog, lounge areas, and more

This is an onsite position working out of our Edmonton office Monday through Friday.

The Opportunity
The Data Conversion Engineer plays a pivotal role in implementing Computer-Assisted Mass Appraisal (CAMA) systems by converting legacy real and personal property assessment and taxation data into modern platforms. This position is responsible for the full lifecycle of data conversion—from source analysis to transformation, validation, and loading—ensuring data integrity, consistency, and alignment with jurisdiction-specific assessment requirements.

What You Will Do

• Analyze legacy CAMA and tax system data structures to develop data mapping to the target CAMA solution. Solicit support from Subject Matter Experts (SMEs) and clients to complete data mapping.
• Design, build, and maintain ETL processes using SQL and scripting tools to convert parcel, valuation, ownership, sales, exemptions, and building characteristics data. Additionally convert Personal Property data including ownership, asset, original cost, purchase year, and depreciated value.
• Collaborate with internal teams and client-side subject matter experts (SMEs), including assessors and IT staff, to understand jurisdiction-specific rules and nuances.
• Implement business rules and transformation logic that align with state regulations and IAAO standards for assessment data.
• Conduct multiple conversion passes (e.g., baseline, mid-project, final) and reconcile outputs with source data. Reconciliation Metrics include:
• Active/Inactive Record Count
• Improved Property County
• Number of Buildings
• Valuation by Land Use (Class code)
• Identify and resolve data anomalies, quality issues, and inconsistencies through cleansing and validation routines.
• Add validation elements to main QA checklist to reflect lessons learned from prior conversion projects.
• Provide converted datasets for User Acceptance Testing (UAT) and support client-side verification.
• Maintain clear documentation of mapping specifications, conversion logic, and data lineage.
• Support go-live activities and post-implementation troubleshooting.
• Ensure compliance with data security protocols and sensitive taxpayer information handling requirements.

Requirements
What you Will Need to Succeed
Required

• Bachelor's degree in Computer Science, Information Systems, GIS, or a related field
• 3+ years of experience with data conversion, data migration, or ETL development, preferably with the public sector data, specifically related to property tax.
• Strong proficiency in SQL (T-SQL, PL/SQL, or equivalent) and relational database systems.
• Experience working with property assessment, tax roll, and CAMA datasets.
• Strong understanding of property data structures such as parcels, land, improvements, permits, and sales.
• Ability to communicate effectively with technical and non-technical stakeholders.
• Proven ability to troubleshoot and resolve complex data issues.

Preferred

• Experience with CAMA platforms such as Catalis (Patriot), Vision, Tyler iasWorld, DevNet, ProVal, similar.
• Familiarity with government land records and assessment practices.
• Knowledge of IAAO standards and assessment ratio study methodologies.
• Experience with data migration tools (e.g., FME, SSIS, Talend).
• Exposure to GIS integration in property assessment workflows.
• Experience using project management tools (e.g., Jira, Smartsheet).

Catalis is committed to building and promoting a diverse workforce and celebrates the unique qualities that individuals of various backgrounds and experiences offer. As an equal employment opportunity employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, and other protected status as required by applicable law.