Analytics Engineer Cenergy International Sacramento, CA Job Details Contract $85 - $95 an hour 20 hours ago Qualifications Airtable Data visualization software proficiency Defect resolution root cause analysis Data permissions Data validation techniques Procedural guides Process optimization Triage Defect analysis IT system monitoring Dashboard creation support Process improvement Git Apache Hive Mid-level Tableau 3 years SQL Pandas Jupyter Data pipeline scheduling Airflow Jupyter Notebook Data reporting support Software documentation Technical writing Monitoring system implementation Root cause analysis Query management Backlog management Full Job Description Major Entertainment Company is looking for an Analytics Engineer for a fixed-term contract focused on stabilizing and improving production data pipelines that support reporting and dashboards.

JOB TITLE

Analytics Engineer

LOCATION

Remote - PST Time Zone Preferred

PAY RATE

$85-$95/hr

JOB TYPE

Fixed-Term Contract Job Overview:

This role focuses on stabilizing a set of reporting data pipelines inherited from another team. You'll troubleshoot stalled or broken workflows, clean up outdated processes, improve monitoring and alerting, and document the systems so they can be maintained going forward. This is primarily stabilization and cleanup work rather than new development . You'll work from a prioritized backlog with weekly check-ins with the hiring manager. Strong written communication, careful execution, and the ability to identify the root cause of problems are important.

Key Responsibilities:

Diagnose and repair stalled or broken data pipelines supporting 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. 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; no on-call or external communication. Validate that new product types flow correctly into cost reporting and 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 through pull-request review before merging.

Qualifications & Skills:

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. Comfortable working with Git and pull-request workflows. Demonstrated ability to troubleshoot and repair pipelines you did not originally build, including systems with incomplete documentation. Strong written communication and documentation skills.

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.

Pay:

$85.00 - $95.00 per hour Expected hours: 40.0 per week

Work Location:

In person