Analytics Engineer, Data Pipelines

BlueinGreen, Inc; United States; Remote; USD 83,000 - 124,000; Full time

Benefits offered by this job

Benefits eligible

Fully remote

Job summary

BlueInGreen seeks an experienced Analytics Engineer to own the reporting data pipelines behind dashboards for a media and entertainment client. You will use SQL, Python, Airflow, and Tableau to fix root causes, retire unused components, and build monitoring with runbooks.

The engagement is fully remote within the United States, with a clear backlog and weekly check-ins with the team lead; there is no on-call requirement. Your work will emphasize reliability and clear documentation.

Qualifications

• Repair a backlog of stalled pipelines and fix root causes.
• Replace drop-and-recreate table builds with in-place writes.
• Move workflow alerts to a team distribution list.
• Inventory Tableau data sources and confirm downstream consumers.
• Retire unused workflows carefully with validation.
• Build freshness checks for dashboard extracts.
• Write runbooks for each workflow touched and hand off documentation.
• Ship changes through pull requests and weekly reviews.
• Leave pipelines running clean, monitored, and documented.

Responsibilities

• Repair a backlog of stalled pipelines behind reporting dashboards and fix root causes.
• Replace drop-and-recreate table builds with in-place writes preserving permissions.
• Move workflow alerts to a team distribution list and ensure action.
• Inventory Tableau data sources and confirm downstream consumers before changes.
• Retire unused workflows carefully and verify no dependencies.
• Build freshness checks to catch stale dashboard extracts.
• Provide first-line triage when in-scope workflow fails during business hours.
• Write a runbook for every workflow touched and hand off documentation.

Skills

SQL

Python

Airflow

Tableau

Git

Pandas

Data validation

Troubleshooting

Tools

Trino/Presto

Tableau

Git

Job description

We are looking for an experienced Analytics Engineer to own the reporting data pipelines behind the dashboards of a leading media and entertainment company. Working in SQL, Python, Airflow, and Tableau, you will track down why pipelines stall, fix the root cause, retire what no one uses, and build the monitoring that catches the next problem early. Expect a clear backlog, a weekly check-in with the team lead, and no on-call. After six months, every pipeline you touched will run cleanly, be monitored, and have a formalized runbook.

Schedule: Fully remote, US-only role. Assignment length and any extension or conversion details will be discussed during the hiring process.

Before you apply

What you will do

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

What we are looking for

• 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 located in the United States and perform work from within the United States.
• Must be eligible to work directly for BlueInGreen in a W2 hourly with benefits role.
• Direct applicants only; no recruiting agencies, third-party vendors, employer-of-record arrangements, or corp-to-corp submissions.
• Must be legally authorized to work in the United States and able to complete Form I-9 employment eligibility verification if hired.
• Must be willing to complete a background check, subject to applicable law and required candidate authorization.
• Must understand that this is an hourly W2 role with benefits eligibility and that assignment length or extension is not guaranteed.

Helpful, but not required

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

A few basics we need to confirm

You will answer a few practical questions in the application so we know the role details line up.

The questions are included in the application form.