Remote Analytics Engineer — Stabilize Data Pipelines

Cenergy International; Sacramento (CA); A distancia; USD 117.000 - 131.000; Jornada completa

Descripción de la vacante

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.

Formación

• 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.

Responsabilidades

• 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.

Descripción del empleo

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.