[Hiring] Senior Technical Services Analyst @First Due

Role Description

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 is forward-looking, investing in ETL automation, data pipeline tooling, and AI-assisted workflows to scale delivery.

• 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.
• Author advanced SQL to extract, join, and transform disparate data from customer sources.
• Solve novel migration challenges: multi-system consolidations, new module implementations, non-standard data structures.
• 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.
• Identify gaps and edge cases between legacy systems and First Due; propose creative solutions or escalate to Product.
• Guide customers through data decisions using deep platform knowledge and a consultative approach.
• Serve as the technical voice in 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.
• Provide direction and technical review across active migration projects.
• Contribute expertise to internal tooling, process design, and documentation.
• Partner with Implementation Managers to scope and sequence data work.
• Coordinate with Data Operations on load specifications and production deployment.
• Support Product and Engineering with data-informed feedback.
• Contribute knowledge to the team's ETL pipeline and automation initiatives.
• Identify repetitive work and build scripts, templates, and workflows to reduce it.
• Experiment with AI-assisted workflows and tooling.
• Maintain awareness of modern data engineering practices and tools.

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

Requirements

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

Benefits

• Comprehensive compensation and benefits package including competitive pay, medical, dental, and vision coverage.
• FSA/HSA, 401(k), flexible PTO, and a fully remote workplace.
• Technology stipend and opportunities for advancement.