Senior Data Migration Architect (Remote)

First Due; United States; On-site; USD 99,000 - 121,000; Full time

Job summary

First Due is seeking a Senior Technical Services Analyst for remote work in the United States. You will own end-to-end data migration projects, collaborating with customers and internal teams to design strategies and ensure clean, scalable migrations.

In this role you will mentor analysts, apply advanced SQL and data modeling skills, and contribute to ETL automation initiatives, shaping how data migrations are delivered at scale within Professional Services.

Qualifications

• 4+ years of experience in data migration, data operations, or a technical implementation role within a SaaS environment.
• In-depth experience writing SQL from scratch, including complex joins, CTEs, subqueries, window functions, and output validation.
• In-depth understanding of relational databases, structured data formats, and data modeling concepts.
• Demonstrated ability to manage Enterprise-level customer relationships from a detailed, technical perspective.
• Demonstrated experience serving as the go-to technical voice with customers, translating complex data topics into clear, actionable guidance.

Responsibilities

• Own the full lifecycle of data migration projects: requirements gathering, extraction, transformation, loading, validation, and go-live support.
• Analyze complex legacy data structures and design migration approaches that account for how data will operate within First Due's architecture (not just field-level mapping, but system-level impact).
• Author advanced SQL to extract, join, and transform disparate data from customer sources including SQL backups, CSV, XML, TXT, and multi-system exports.
• Solve novel migration challenges: multi-system consolidations, new module implementations, non-standard data structures, and customers with advanced operational requirements.
• Execute quality assurance on deployed data; identify and resolve discrepancies with minimal escalation.

Skills

SQL

Data migration

Data modeling

ETL

Excel

Mentoring

Communication

Tools

dbt

Airflow

Power Query

Job description

First Due is seeking a Senior Technical Services Analyst for remote work in the United States. You will own end-to-end data migration projects, collaborating with customers and internal teams to design strategies and ensure clean, scalable migrations.

In this role you will mentor analysts, apply advanced SQL and data modeling skills, and contribute to ETL automation initiatives, shaping how data migrations are delivered at scale within Professional Services.