Senior Technical Services Analyst

First Due

4d•Remote

About The Position

As a Senior Technical Services Analyst on the Data Migration team within Professional Services, you will own the end-to-end delivery of complex data migration projects for Enterprise, State, Federal, and Multi-Agency customers implementing the First Due platform. This role requires you to be a data expert and a systems thinker, capable of understanding customer data structures and translating them into a successful migration plan. You will work directly with customers, implementation teams, Data Operations, Product, and Engineering to define data requirements, design migration strategies, execute complex transformations, and validate deployed data. You will also serve as a subject matter expert on data architecture and migration best practices. The role is forward-looking, with an expectation to contribute to ETL automation, data pipeline tooling, and AI-assisted workflows to scale service delivery. If you are excited about solving hard data problems, mentoring others, and pushing boundaries on how technical services are delivered, this is the role for you.

Requirements

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
Proficiency mentoring and coaching others on SQL, data practices, and migration methodology
Advanced proficiency with Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, Power Query, conditional formatting, data cleansing)
Strong organizational and time management skills with the ability to manage multiple concurrent complex projects
Clear, professional written and verbal communication
All applicants must be authorized to work for any US employer in the United States.
Hiring is contingent upon candidates successfully passing a criminal background check.

Nice To Haves

Experience with ETL pipeline concepts, workflow orchestration, and data pipeline automation (e.g., dbt, Airflow, or similar tools)
Familiarity with data warehouse architectures, staging environments, and schema-as-code practices
Experience with cloud data infrastructure (AWS S3, Redshift, RDS, or equivalent)
Knowledge of data validation frameworks and automated testing approaches
Experience with Fire/EMS data standards (NFIRS, NERIS, NEMSIS) or public safety technology
Understanding of GIS data components and geospatial data handling
Familiarity with scripting languages (Python, Rust, Bash) for data transformation or automation
Experience with version control (Git) and collaborative development workflows

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
Translate customer operational models and legacy data structures into First Due's architecture, understanding downstream impacts on workflows, reporting, and system behavior
Identify gaps and edge cases between legacy systems and First Due; propose creative solutions or escalate to Product with clear, actionable context
Guide customers through data decisions using deep platform knowledge, industry context, and a consultative approach
Serve as the technical voice in the room during customer-facing conversations involving data scope, feasibility, and constraints
Serve as a SQL and data architecture SME for the Data Migration team; coach junior analysts on query construction, data modeling, validation approaches, and best practices
Provide direction and technical review across active migration projects, helping elevate quality and consistency across the team
Contribute expertise to internal tooling, process design, and documentation that scales the team's capabilities
Partner with Implementation Managers to scope and sequence data work within broader project timelines
Coordinate with Data Operations on load specifications, environment readiness, and production deployment
Support Product and Engineering with data-informed feedback on schema changes, import tool capabilities, and customer-facing data features
Contribute knowledge and expertise to the team's ETL pipeline and automation initiatives (pipeline orchestration, schema-as-code, automated validation)
Identify repetitive or manual work and build (or help build) scripts, templates, and workflows to reduce it
Experiment with AI-assisted workflows and tooling to deliver results faster with less manual overhead
Maintain awareness of modern data engineering practices and tools that can improve migration delivery at scale