Senior Analytics Engineer — Data Delivery

2 weeks ago

Philippines XtendOps, Inc. Remote Full-time ₱4 - ₱7 Contract

Senior Analytics Engineer, Data Delivery

XtendOps · Business Intelligence / Data · Full-time · Remote

ABOUT XTENDOPS

XtendOps delivers outsourced customer experience and back-office operations for a growing portfolio of client accounts. Our Business Intelligence / Data team owns the warehouse, the semantic layer and the delivery path behind the reporting and in-product analytics that executives, team leaders and clients use to track performance, monitor financials and find root causes.

ABOUT THE ROLE

Our platform is already in production: a Snowflake warehouse with a medallion-style architecture, transformation in dbt, orchestration in Airflow, and a metric catalog held as data rather than code. That modeled output is becoming the data layer behind a client-facing analytics product. The work ahead is bringing our portfolio of accounts onto it.

This role is weighted toward the last mile. Not just modeling a metric correctly, but conforming it to shared definitions, proving it against a known-good source, wrapping it in a contract, and getting it into the product unchanged and on schedule.

This is a hands‑on senior IC role. You will own production models and the feeds built on them, and set the standard others model to.

Reports to: Senior Data Engineer

Works with: Data engineers, analysts, BI leads, product and platform engineers, PM, operations and client stakeholders

Location: Remote, with overlap with North America and Asia‑Pacific business hours

WHAT YOU'LL DO

Product-ready data delivery

  • Take accounts from modeled warehouse output to live in the analytics product: conform metrics, build the serving feed, reconcile it and schedule delivery
  • Own the metric conformance layer that maps client‑specific source values to master, catalog‑registered definitions
  • Design and maintain feed contracts: grain, keys, period semantics, null and late‑arrival behavior, versioning and backfill rules
  • Build automated reconciliation that runs on every load and proves numbers arrive in the product unchanged
  • Build serving models that support account-, team- and agent‑level entitlements and filtering
  • Own freshness and delivery SLAs for your feeds, including monitoring and alerting
  • Instrument the delivery path so a wrong tile can be traced to a run, model and source in minutes

Client onboarding at scale

  • Move accounts from source data landing through conformance, reconciliation and a scheduled, monitored push
  • Assess new and legacy accounts honestly and defend realistic effort estimates
  • Migrate legacy reporting assets onto the shared foundation instead of carrying them forward
  • Improve onboarding scaffolding so every new account is measurably cheaper than the last

Shared metric foundation

  • Build and maintain core metric models across accounts: handle time, CSAT, QA, FCR, SLA attainment and workforce measures
  • Own master and conformed dimensions (company, client, employee, team, channel, date)
  • Maintain the master metric dictionary with the analyst team
  • Resolve definition conflicts between accounts and document deliberate divergence
  • Collapse per‑account metric copies into shared models

Quality and correctness

  • Write tests covering structure, business logic and cross-model consistency
  • Apply model contracts and versioning so breaking changes are caught in CI, not in a client dashboard
  • Own freshness and anomaly monitoring and lead incident response and post‑mortems
  • Treat incentive, compensation and billing reporting as audit‑grade work

Collaboration and delivery

  • Review analyst modeling contributions and raise the quality bar
  • Turn spreadsheet‑and‑conversation requirements into buildable, testable specs
  • Partner with product and platform engineers, and push back when a request would break a shared definition
  • Mentor mid‑level analytics engineers and analysts
  • Write documentation, runbooks and architectural decision records
  • Work in Agile sprints with a definition of done that includes tests, reconciliation and docs

WHAT YOU'LL NEED

Required

  • 5 to 8 years in analytics engineering, data engineering or BI engineering with substantial production data modeling
  • Hands‑on production dbt experience: models, sources, tests, macros, exposures, contracts, versions, materializations and incremental strategies
  • Strong SQL, including window functions, complex aggregation and query performance reasoning
  • Proven delivery of data to a downstream consumer under contract (dataset, API feed, reverse‑ETL or serving table)
  • Experience building automated reconciliation checks and explaining discrep