Analytics Engineer, Data Pipelines

BlueInGreen is seeking an experienced Analytics Engineer to support reporting data pipelines for a leading media and entertainment company. The role focuses on repairing, monitoring, documenting, and improving production workflows behind dashboards using SQL, Python, Airflow, and Tableau, while providing limited business-hours triage and collaborating with the client team lead.

Responsibilities:

• Repair a prioritized backlog of stalled and broken pipelines behind reporting dashboards, fixing each failure at its root cause
• Replace drop-and-recreate table builds with in-place writes that preserve access permissions
• Move workflow alerts from deprecated notification settings to a team distribution list, where someone will act on them
• Inventory Tableau published data sources and embedded SQL, find duplicated logic, and confirm downstream consumers before any change
• Retire unused workflows and tables in stages: confirm nothing depends on them, disable them for one billing cycle, then remove them
• Build freshness checks that catch stale dashboard extracts before anyone relies on them
• As new product types launch, confirm each appears correctly in cost reporting and write a short reconciliation of its first cycle
• Provide first-line triage when an in-scope workflow fails: about 4 hours a week, business hours only, no on-call
• Write a runbook for every workflow you touch, and hand all documentation to the client's team lead
• Ship every change through pull-request review, and meet weekly with the client's team lead on progress and priorities
• By the end of the engagement, leave every pipeline you touch running cleanly, monitored, and documented

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 or Presto
• Python and pandas for data processing and validation
• Experience building and maintaining scheduled workflows in an orchestration tool such as Airflow
• Working knowledge of Tableau published data sources and extracts
• Fluency in git and pull-request review
• A record of debugging sparsely documented pipelines you did not build, down to the root cause
• The habit of confirming who depends on something before you change or remove it
• The independence to work from a prioritized backlog between weekly check-ins
• Clear writing: runbooks and summaries a teammate can follow without you
• Must be able to use a Mac as the primary working device for this assignment
• Must be eligible to work directly for BlueInGreen in a W2 hourly with benefits role
• Must be legally authorized to work in the United States
• Billing, cost, or financial reporting data
• Data-quality monitoring: freshness checks, alerting, or similar
• Retiring legacy workflows or tables without breaking what depends on them
• Iceberg or Hive table formats
• Jupyter notebooks and parameterized runs with a tool such as papermill
• Airtable, for read-only reporting
• Media, localization, or content supply chain data