This fixed-term Analytics Engineer contract role with Cenergy International focuses on stabilizing and improving production reporting data pipelines. The work emphasizes troubleshooting stalled or broken workflows, cleaning up outdated processes, enhancing monitoring, and documenting systems for long-term maintenance.

Role Overview

You will take ownership of a backlog of pipeline stabilization tasks for reporting dashboards. The engagement is primarily focused on remediation and cleanup rather than new development. You will investigate workflow failures, improve visibility into pipeline health, and ensure reporting data continues to flow correctly into downstream dashboarding and cost reporting use cases. Progress is reviewed through weekly check-ins with the hiring manager.

Responsibilities

Diagnose and repair stalled or broken data pipelines that support reporting dashboards.
Replace drop-and-recreate table builds with in-place writes while preserving existing access permissions.
Migrate workflow alerting from deprecated notification settings to team distribution lists.
Inventory Tableau published data sources and embedded SQL to identify duplicated logic and downstream consumers.
Safely retire unused workflows and tables after confirming they have no active consumers.
Implement data extract freshness and staleness checks for dashboard reporting.
Provide first-line business-hours triage for in-scope workflow failures, approximately 4 hours per week, with no on-call responsibilities and no external communication.
Validate that new product types flow correctly into cost reporting and document the first reporting cycle reconciliation.
Create runbooks for workflows updated during the engagement.
Submit all code changes via pull-request review prior to merging.

Requirements

3+ years of experience in analytics or data engineering, including hands-on ownership of production pipelines.
Strong SQL experience with 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 using Airflow or a comparable orchestration tool.
Working knowledge of Tableau published data sources and extracts.
Comfort working with Git and pull-request-based workflows.
Proven ability to troubleshoot and repair pipelines not originally built by you, including systems with incomplete documentation.
Strong written communication and documentation skills.

Technologies

SQL, Trino, Presto
Python, pandas
Airflow
Tableau
Git, pull request
Jupyter notebooks, papermill
Airtable
Iceberg, Hive

Preferred Skills

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

Location, Schedule, and Compensation

Location: Sacramento, CA (remote)
Job type: Contract
Experience: 3+ years
Compensation: USD 85 to 95 per hourly

Analytics Engineer