Analytics Engineer

Cenergy International; Sacramento (CA); Remote; USD 117,000 - 131,000; Full time

Job summary

Cenergy International is seeking a fixed-term Analytics Engineer contractor to stabilize and improve production reporting data pipelines in Sacramento, CA (remote). You will troubleshoot stalled workflows, modernize pipeline operations, and document systems for reliable maintenance.

Work involves weekly check-ins with the hiring manager, prioritizing stabilization over new features, and delivering runbooks and reconciliations. Strong SQL, Python, Airflow, and Tableau skills are required.

Qualifications

• 3+ years of analytics or data engineering with ownership of production pipelines.
• Strong SQL experience with distributed engines (Trino/Presto).
• Proficiency with Python and pandas for data processing.
• Experience building and maintaining scheduled workflows using Airflow.
• Working knowledge of Tableau published data sources and extracts.
• Comfort with Git and pull-request workflows.
• Ability to troubleshoot and repair pipelines with incomplete documentation.
• Strong written communication and documentation skills.

Responsibilities

• Diagnose and repair stalled or broken data pipelines feeding reporting dashboards.
• Replace drop-and-recreate table builds with in-place writes while preserving access permissions.
• Migrate workflow alerting to team distribution lists.
• Inventory Tableau published data sources and embedded SQL to find duplicated logic and downstream consumers.
• Retire unused workflows and tables after confirming no active consumers.
• Build freshness and staleness checks for dashboard data extracts.
• Provide first-line triage during business hours (approx. 4 hours/week) with no on-call or external communication.
• Document the first reporting cycle reconciliation for new product types in cost reporting.
• Create runbooks for touched workflows and review progress weekly with the hiring manager.
• Submit code changes via pull-request review before merging.

Job description

Cenergy International is hiring a fixed-term Analytics Engineer contractor to stabilize and improve production reporting data pipelines. This role is focused on troubleshooting stalled or broken workflows, modernizing pipeline operations, and documenting systems so they can be maintained reliably going forward.

Based in Sacramento, CA (remote), you will work from a prioritized backlog with weekly check-ins with the hiring manager. The work is primarily stabilization and cleanup rather than building new product features.

What you’ll do

• Diagnose and repair stalled or broken data pipelines that feed 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 find duplicated logic and downstream consumers.
• Safely retire unused workflows and tables after confirming they have no active consumers.
• Build freshness and staleness checks for dashboard data extracts.
• Provide first-line business-hours triage for in-scope workflow failures (approximately 4 hours per week), with no on-call and no external communication.
• Validate that new product types flow correctly into cost reporting, then document the first reporting cycle reconciliation.
• Create runbooks for workflows touched during the engagement.
• Meet weekly with the hiring manager to review progress.
• Submit all code changes via pull-request review before merging.

What you bring

• 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 similar orchestration tool.
• Working knowledge of Tableau published data sources and extracts.
• Comfort working with Git and pull-request workflows.
• Ability to troubleshoot and repair pipelines you did not originally build, including systems with incomplete documentation.
• Strong written communication and documentation skills.

Tools you’ll use

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

Nice to have

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

Compensation: USD 85 - 95 per hour. Experience: 3+ years. Job type: contract.