(Senior) Analytics Engineer

(Senior) Analytics Engineer

TubeScience Labs: Los Angeles in person $110000$165000

TubeScience Labs mission is to create trusted scalable and self-improving AI systems that power the largest performance-based paid social creative video company in the world.

TubeScience is Metas largest creative partner and AppLovins #1 creative partner producing 8000 original ads every month from a 100000 sq. ft. Los Angeles studio backed by a library of 1.6 million performance ads and $3B in annual managed ad spend. That is what gives TubeScience one of the richest first-party creative-performance datasets anywhere.

Labs turns that data and the playbook behind billions in spend into frontier AI tools that actually ship. We are an AI-native lab working end to end from research and design to coding experimentation and delivery. Our pipelines run against real creative real deadlines and real budgets every day.

Youll join a small AI-empowered senior team of engineers and product managers with direct access to expert users and full ownership of the systems you build. Youll be expected to use the latest frontier and open-weight models in every phase of the job from discovery and prototyping to building testing and deployment.

The role

Youll build the data systems that connect ad performance to creative decisions. Our platform brings together data from advertising channels creative production workflows and business operations and your work makes that data reliable understandable and useful in reports internal products and future analytics and machine learning applications.

The role is hands-on across the whole data lifecycle: extracting data from APIs maintaining dependable pipelines modeling data in Snowflake defining metrics and delivering insights through Power BI and other tools. Much of the foundation already exists. Youll learn how its parts fit together make it faster and more reliable and help shape what we build next.

We weigh directly relevant experience heavily. This platform carries real advertising data and feeds the reporting the business runs on from the first week so tell us plainly where your background maps: advertising data warehouse modeling pipelines or BI.

We are open to hiring at Analytics Engineer or Senior Analytics Engineer level depending on experience and scope of ownership.

Responsibilities

• Build and evolve the data platform from external sources through ingestion transformation and curated models to BI and application delivery
• Extract and integrate advertising data from Meta TikTok Google and Snapchat using their APIs and Python handling pagination rate limits backfills schema changes and reconciliation with the platforms
• Build performant Snowflake models and define and document the metrics the business relies on together with stakeholders
• Maintain and improve Power BI reporting including a possible migration to a better BI tool and build datasets that link ad outcomes to creative strategy and production decisions
• Investigate discrepancies and pipeline failures add checks and observability and use agents to automate the repetitive work
• Work with data product engineering and business partners on analytics and machine learning approaches that feed ad performance back into creative development

Minimum qualifications

• You have 5 years in analytics engineering data engineering or a closely related role with meaningful ownership of production data systems.
• You have worked with advertising or marketing performance data ideally pulling it directly from platforms such as Meta TikTok Google or Snapchat.
• You are strong in SQL and Python and you can reason through the full path from a source API to a business-facing metric or report.
• You have designed data models and warehouse architecture that support changing business needs including layered approaches such as medallion architecture where useful.
• You have built or maintained orchestrated pipelines and you understand failure recovery backfills data quality and operational reliability.
• You have developed Power BI reports or semantic datasets and you have worked with stakeholders to resolve ambiguous metric definitions.
• You are comfortable with GitHub-based development code review and cloud infrastructure on AWS or GCP.
• You investigate problems independently make practical engineering decisions and explain the trade-offs to technical and business partners alike.

Preferred qualifications

• You have worked on creative analytics attribution or cross-platform performance measurement.
• You have optimized Snowflake or Databricks performance including dynamic tables.
• You have used transformation tools such as Coalesce and orchestration tools such as DBOS or Airflow.
• You have built datasets or features for internal applications experimentation or machine learning.
• You use AI-assisted development fluently while applying your own judgment to system design correctness and production changes.

The problems to solve

• Advertising data from many platforms. Meta TikTok Google and Snapchat each with its own API limits and quirks reconciled with what the platforms themselves report.
• A platform that grows with the business. Architectural choices that still hold as data volumes and use cases grow.
• Metrics people trust. Consistent definitions across advertising creative client and operational data agreed with stakeholders and documented.
• Reporting that connects ads to creative. Datasets that show which creative decisions actually moved performance.
• Reliability without the toil. Fewer surprises in the pipelines with agents handling the repetitive checks.
• Feedback loops. Analytics and machine learning that feed ad performance back into creative development.

How the hiring works

Three conversations and a short piece of practical work. Recruiter screen then an engineer from the team then a practical assignment and a walkthrough with the hiring 17 business days end to end if we both move quickly. You will get a decision either way at every stage.

Required Experience:

Senior IC