Senior Technical Services Analyst

7Seventy; United States; Hybride; USD 100 000 - 125 000; Plein temps

Avantages offerts par ce poste

Technology stipend

Fully remote

Résumé du poste

7Seventy is seeking a Senior Technical Services Analyst to lead end-to-end data migration projects for enterprise and public sector clients on our SaaS platform. You will drive requirements, extraction, transformation, loading, validation, and go-live support while coordinating with Data Operations, Product, and Engineering.

The role emphasizes complex legacy data structures, advanced SQL, ETL practices, data architecture, and scalable delivery through automation and AI-assisted workflows.

Qualifications

• 4+ years of experience in data migration, data operations, or a technical implementation role within a SaaS environment.

Responsabilités

• Own the full lifecycle of data migration projects, including requirements gathering, extraction, transformation, loading, validation, and go-live support.

Connaissances

Data migration

SQL

ETL

Relational databases

Data modeling

Public safety technology

Data validation

Automation

Outils

dbt

Airflow

AWS S3

Redshift

Description du poste

Experience: 4+ years in data migration, data operations, or technical implementation within a SaaS environment

Core Areas: Data migration, SQL, ETL, relational databases, data modeling, public safety technology, data validation, automation

Compensation: $110,000 per year

Travel: Minimal travel expectations at this time

About the Role

The Senior Technical Services Analyst will own end-to-end delivery of complex data migration projects for enterprise, state, federal, and multi-agency customers implementing a public safety software platform. This role covers requirements gathering, data extraction, transformation, loading, validation, go-live support, and customer-facing technical guidance.

The position is focused on complex legacy data structures, advanced SQL, relational databases, structured data formats, ETL awareness, data architecture, and migration best practices. The successful candidate will work with customers, implementation teams, Data Operations, Product, and Engineering while helping scale migration delivery through automation, data pipeline tooling, and AI-assisted workflows.

What You'll Do

Data Migration Delivery & Technical Execution

• Own the full lifecycle of data migration projects, including 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 the target platform architecture.
• Consider system-level impact, not only field-level mapping, when designing migration strategies.
• Author advanced SQL to extract, join, and transform disparate data from customer sources.
• Work with SQL backups, CSV, XML, TXT, and multi-system exports as part of migration delivery.
• Solve novel migration challenges involving multi-system consolidations, new module implementations, non-standard data structures, and customers with advanced operational requirements.
• Identify and resolve data discrepancies with minimal escalation.

Requirements Translation & Solution Design

• Translate customer operational models and legacy data structures into the target platform architecture.
• Evaluate downstream impacts on workflows, reporting, and system behavior.
• Identify gaps and edge cases between legacy systems and the target platform.
• Propose creative solutions when gaps arise, or upscale to Product with clear and actionable context.
• Guide customers through data decisions using deep platform knowledge, industry context, 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 subject-matter expert for the Data Migration team.
• Coach junior analysts on query construction, data modeling, validation approaches, and data migration best practices.
• Provide technical direction and review across active migration projects.
• Help improve quality and consistency across data migration delivery.
• Contribute expertise to internal tooling, process design, and documentation that scale team capabilities.

Cross-Functional Collaboration

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

Automation, ETL Awareness & Continuous Improvement

• Contribute knowledge and expertise to ETL pipeline and automation initiatives, including pipeline orchestration, schema-as-code, and automated validation.
• Identify repetitive or manual work and build, or help build, scripts, templates, and workflows to reduce manual effort.
• 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.

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.
• Ability to translate complex data topics into clear, actionable guidance.
• Proficiency mentoring and coaching others on SQL, data practices, and migration methodology.
• Advanced proficiency with Microsoft Excel, including pivot tables, VLOOKUP, XLOOKUP, Power Query, conditional formatting, and data cleansing.
• Strong organizational and time management skills.
• Ability to manage multiple concurrent complex projects.
• Clear and professional written and verbal communication skills.

Preferred Qualifications

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

Work Conditions & Eligibility

• This role is remote and limited to candidates in the United States.
• Applicants must be authorized to work for any employer in the United States.
• Visa sponsorship and visa sponsorship transfers are not available for this position.
• Hiring is contingent upon successful completion of a criminal background check.
• The employer participates in E-Verify as part of the I-9 employment eligibility verification process.
• Travel expectations are minimal at this time.
• Reasonable accommodations may be made to enable qualified employees and applicants to perform the essential functions of the role.
• Candidates who require accommodation during the interview process may request assistance from the recruiting team.
• Eligible employees may receive medical, dental, and vision coverage.
• FSA and HSA options are available for eligible employees.
• Eligible employees may participate in a 401(k) plan.
• The role includes flexible paid time off.
• The workplace is fully remote.
• A technology stipend is provided.
• The role offers opportunities for advancement.
• Additional benefits and perks may be available for eligible employees.