Analytics Engineer

Cenergy International; United States; Remote; USD 243,560,000 - 272,214,000; Full time

Benefits offered by this job

Remote work

Fixed-term contract

Competitive hourly rate

Job summary

Cenergy International is seeking a Fixed-term Analytics Engineer to restore reliability for reporting pipelines and ensure cost reporting remains reconciled as product types evolve. You will diagnose broken data flows, migrate alerts, and implement freshness checks while delivering runbooks and weekly updates.

Ideal candidates have 3+ years in analytics or data engineering, strong SQL on distributed engines, Python with pandas, and Airflow experience.

Qualifications

• 3+ years in analytics or data engineering with ownership of production pipelines
• Proficient SQL on distributed engines such as Trino/Presto
• Proficient in Python and pandas for data processing and validation
• Experience building and maintaining scheduled workflows in Airflow or similar
• Working knowledge of Tableau published data sources and Tableau extracts
• Comfort with git and pull-request workflows
• Ability to debug pipelines not originally built and maintain clear docs

Responsibilities

• Diagnose and repair a backlog of stalled or broken data pipelines feeding reporting dashboards.
• Replace drop-and-recreate table builds with in-place writes to preserve access permissions.
• Migrate workflow alerts off deprecated settings and route to a team distribution list.
• Inventory BI data sources, including Tableau sources and embedded SQL, to identify duplicate logic and confirm downstream consumers.
• Retire unused workflows and tables via staged process: verify no consumers, disable for one billing cycle, then remove.
• Implement dashboard freshness and staleness checks for data extracts.

Skills

SQL

Python

Airflow

Tableau

Git

Pandas

Tools

Tableau published data sources

Tableau extracts

Iceberg/Hive

Job description

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