Analytics Engineer

Fixed-term Analytics Engineer role focused on restoring reliability for reporting pipelines and keeping cost reporting logic reconciled as product types change.

Responsibilities

• Diagnose and repair a defined backlog of stalled or broken data pipelines feeding reporting dashboards, prioritized by the hiring manager.
• Replace drop-and-recreate table builds with an in-place write approach to preserve existing access permissions.
• Migrate workflow alerting off a deprecated notification setting and route alerts to a team distribution list.
• Inventory BI data sources, including Tableau published data sources and embedded SQL, to identify duplicated logic and confirm downstream consumers before making changes.
• Retire unused workflows and tables using a staged process: confirm no consumers, disable for one billing cycle, then remove.
• Implement dashboard freshness/staleness checks for data extracts.
• Provide first-line triage for failures on in-scope workflows (up to ~4 hours/week, business hours only; no on-call; no external communication).
• For newly launched product types, verify they flow into cost reporting and produce a short reconciliation of the first cycle’s volumes.
• Create a runbook for every workflow touched and hand documentation to the hiring manager by the end of the term.
• Meet weekly with the hiring manager to review progress.
• Ensure all code changes are submitted via pull request review before merge.

Requirements

• 3+ years in analytics or data engineering, including hands-on ownership of production pipelines.
• Strong SQL on a distributed query engine such as Trino/Presto or similar.
• Proficiency with Python and pandas for data processing and validation.
• Experience building and maintaining scheduled workflows in Airflow or a similar orchestration tool.
• Working knowledge of Tableau published data sources and Tableau extracts.
• Comfort with git and pull-request workflows.
• Proven ability to debug pipelines you did not originally build, even with incomplete documentation.
• Clear written documentation habits.

Technologies

• SQL, Trino, Presto
• Python, pandas
• Airflow
• Tableau, Tableau published data sources, Tableau extracts
• git

Preferred / Nice to Have

• Experience with billing, cost, or financial reporting data.
• Jupyter notebooks and parameterized notebook execution (for example, papermill).
• Airtable (read-only reporting).
• Familiarity with Iceberg or Hive table formats.
• Background in media, localization, or content supply chain data.

Role Details

• Location: Remote (remote)
• Type: Fixed-term
• Compensation: USD 85–95 per hour
• Minimum experience: 3 years