Senior Technical Services Analyst
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Technical Services Analyst leading complex data migrations for First Due’s fire and EMS software platform. Designing SQL transformations, validating deployments, and advancing ETL automation.
Responsibilities:
- Own the full lifecycle of complex data migration projects, including requirements gathering, extraction, transformation, loading, validation, and go-live support
- Analyze complex legacy data structures and design migration approaches accounting for system-level impact within First Due's architecture
- Author advanced SQL to extract, join, and transform data from SQL backups, CSV, XML, TXT, and multi-system exports
- Solve multi-system consolidations, new module implementations, non-standard data structures, and advanced operational requirements
- Execute quality assurance on deployed data and resolve discrepancies with minimal escalation
- Translate customer operational models and legacy data structures into First Due's architecture
- Identify gaps and edge cases, propose solutions, or escalate actionable context to Product
- Guide customers through data decisions and serve as the technical voice in customer-facing data discussions
- Serve as SQL and data architecture subject matter expert and coach junior analysts
- Provide technical direction and review across active migration projects
- Contribute to internal tooling, process design, and documentation
- Partner with Implementation Managers to scope and sequence data work
- Coordinate with Data Operations on load specifications, environment readiness, and production deployment
- Support Product and Engineering with feedback on schema changes, import tools, and data features
- Contribute to ETL pipeline and automation initiatives
- Build or help build scripts, templates, and workflows to reduce manual work
- Experiment with AI-assisted workflows and tooling
- Maintain awareness of modern data engineering practices and tools
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, including pivot tables, VLOOKUP/XLOOKUP, Power Query, conditional formatting, and data cleansing
- Strong organizational and time management skills with the ability to manage multiple concurrent complex projects
- Clear, professional written and verbal communication
- Must be authorized to work for any US employer in the United States
- Must successfully pass a criminal background check
- Preferred: Experience with ETL pipeline concepts, workflow orchestration, and data pipeline automation, such as dbt or Airflow
- Preferred: Familiarity with data warehouse architectures, staging environments, and schema-as-code practices
- Preferred: Experience with cloud data infrastructure, such as AWS S3, Redshift, or RDS
- Preferred: Knowledge of data validation frameworks and automated testing approaches
- Preferred: Experience with Fire/EMS data standards or public safety technology
- Preferred: Understanding of GIS data components and geospatial data handling
- Preferred: Familiarity with Python, Rust, or Bash for data transformation or automation
- Preferred: Experience with Git and collaborative development workflows
Benefits:
- Medical, dental, and vision coverage
- FSA/HSA
- 401(k)
- Flexible PTO
- Fully remote workplace
- Technology stipend
- Opportunities for advancement
- Other benefits and perks
- Minimal travel expectations
- Reasonable accommodation during employment and interview process
Similar Jobs
Senior eBilling Analyst
Senior eBilling Analyst managing complex electronic billing, accruals, budgets, and invoice resubmissions for RRD, a global marketing, packaging, print, and supply chain solutions provider.
Senior PMO Analyst
Senior PMO Analyst supporting TransUnion's global portfolio governance, reporting, and assurance. Managing PMO processes remotely from a fibre-ready South African home.
Senior Digital Consulting Analyst, Oracle Cloud SCM
Oracle Cloud SCM Senior Analyst supporting procurement, inventory, and Product Hub implementations. Delivering digital transformation solutions for Huron’s consulting clients.
IB Coverage Analyst II
Investment banking coverage analyst supporting Texas Capital Bank’s transaction execution, valuation, and financial modeling. Preparing pitch materials, researching industries, and mentoring analysts.
Senior Workday HRIS Analyst – Talent and Performance
Senior Workday HRIS Analyst owning Talent and Performance solutions for Lamb Weston, a global frozen-food manufacturer. Configuring Workday, managing releases, integrations, reporting, security, and HRIS projects.
Commercial Analyst, III
Analista Comercial III apoiando campanhas, indicadores e projetos comerciais da Ânima Educação. Interface com parceiros e áreas internas para garantir prazos, execução e melhoria contínua.
Patient Engagement Analyst – Telehealth
Patient Engagement Analyst analyzing appointment data for CareTalk Health’s virtual medical practice. Improving patient show rates through reporting, dashboards, outreach analysis, and testing.
Fraud Prevention Analyst
Analista de prevenção a fraudes protegendo transações na plataforma VExpenses de despesas e viagens corporativas. Analisando riscos, chargebacks, regras antifraude e validações biométricas.
Functional Analyst II – SAP CO
Analista Funcional SAP CO modernizando contabilidade e controladoria do Grupo Boticário. Atuando na transição ECC-S/4HANA e automação financeira do ecossistema de beleza.
Revenue Integrity Analyst
Revenue Integrity Analyst optimizing charge capture, coding, and claims for Intermountain Health. Analyzing healthcare data and regulations to improve compliance and revenue.
Measurement Analyst
Measurement Analyst optimizing statistical modeling, experimentation, attribution, and forecasting. Power Digital helps brands grow through AI-native marketing strategy and analytics.
Coding Quality Analyst – Inpatient
Coding Quality Analyst auditing inpatient cases for UW Health, Wisconsin’s #1 hospital. Ensuring coding compliance, improving quality, and training inpatient coders.
Loss Prevention Fraud Analyst
Loss Prevention Fraud Analyst monitoring fraudulent transactions and securing accounts for Elavon, U.S. Bank’s payment-processing subsidiary. Resolving merchant issues and maintaining processing records.
Senior Behavioral Health Quality Audit Analyst
Senior behavioral health quality analyst supporting Massachusetts Medicaid care oversight at Elevance Health. Investigating safety concerns, auditing records, and coordinating quality improvement reporting.
Senior HRIS Analyst
Senior HRIS Analyst managing Workday HRIS configuration, reporting, and support. Leading system enhancements and serving as SME across multiple functional areas.
Valuation Analyst I
Valuation Analyst reviewing appraisals and other real estate valuations for ValuationNEXUS, a business-purpose lending AMC. Analyzing collateral risk, supporting review quality, and mentoring valuation staff.
Student Engagement Analyst III
Analista de comunicação estudantil operando fluxos, CRM e campanhas segmentadas para alunos. Uso de dados, automação e IA no ecossistema educacional Ânima.
Senior Benefits Analyst
Senior Benefits Analyst managing U.S. employee benefits programs for Qualfon. Overseeing compliance, vendors, open enrollment, analytics, and benefits strategy.
Automation Analyst (Mid-Level)
Analista de automação de testes na Stefanini, ecossistema global de tecnologia e inovação. Desenvolvendo frameworks, testes funcionais e APIs REST para garantir entregas de qualidade.
Medical Claim Analyst
Medical Claim Analyst reviewing and triaging healthcare claims for CVS Health. Verifying eligibility, preparing authorizations, and resolving payment issues remotely from West Virginia.