Business Intelligence Engineer​/Analytics Engineer; Tableau​/Marketing Data

Job Description

Title: Business Intelligence Engineer / Analytics Engineer (Tableau/Marketing Data)

Team: Marketing Analytics

Location: Remote – (Ideally near a hub – New York, NY or San Francisco, CA in order to convert)

Schedule: 30–40 hours/week (Hybrid or remote; EST/PST collaboration)

Duration: 3–6 Month Contract

This is a leading subscription platform company at the center of connected fitness, with more than 180 million community members in over 185 countries. The platform offers a holistic view of your active lifestyle, no matter where you live, which sport you love, and what device you use. Everyone belongs on Strava when they are pursuing an active life.

Insight Global is seeking a Business Intelligence Engineer / Analytics Engineer (Tableau/Marketing Data) to join our Marketing Analytics team. This is a highly technical, hands‑on role where you’ll be responsible for extracting, merging, and interpreting marketing data from platforms like Tik Tok, Instagram, Meta, and Google Ads—leveraging tools such as Fivetran, Big Query, and Snowflake.

You’ll build and automate Tableau dashboards that continuously update with fresh campaign data, segment paid and organic results, and deliver actionable insights to the marketing team.

By developing reusable code and automated pipelines (using tools like Airflow), you’ll streamline data workflows and ensure real‑time visibility into campaign performance and engagement.

Your work will empower marketing stakeholders to make data‑driven decisions, optimize strategies, and understand what’s working across channels—all while collaborating closely with the team and using Git Hub for version control and code collaboration.

This role is ideal for someone who thrives in a fast-paced environment, takes ownership, and is passionate about delivering high‑impact, technical solutions for marketing teams.

• Build, maintain, and optimize scalable data pipelines (ETL/ELT) that ingest, transform, and model marketing data from multiple sources (e.g., Tik Tok, Instagram, Meta, Google Ads, You Tube, Pinterest, Reddit) using tools like Fivetran, Big Query, Snowflake, and Airflow.
• Design and own the marketing data layer, including dimensional models, metrics definitions, and reusable data assets for KPIs (impressions, spend, engagement, registrations, brand awareness).
• Develop and maintain BI reporting infrastructure—owning Tableau and/or Power BI dashboards and self‑service reporting used across Brand Marketing, Growth Marketing, and leadership.
• Automate data extraction and reporting workflows, enabling real‑time and continuous updates for campaign performance dashboards.
• Partner with cross‑functional stakeholders to gather requirements, translate business needs into data models, and identify gaps in self‑service coverage.
• Support measurement and attribution work in collaboration with Data Science and external agencies, including building infrastructure for incrementality testing and attribution analysis.
• Consolidate multiple data sources into a single source of truth, ensuring data is accurate, fresh, and reliably accessible.
• Optimize SQL pipelines for ad hoc analysis, test units, and stakeholder deliverables.
• Troubleshoot and resolve data quality, scaling, and optimization issues (not security/platform engineering).
• Use Git Hub for version control, code check‑in/check‑out, and code merge workflows; collaborate with team on pipeline and dashboard code.

• Advanced SQL proficiency:
  Write complex queries independently, extract and transform large datasets, build data models, and optimize pipelines (joins, window functions, CTEs, aggregations, etc.).
• ETL pipeline expertise:
  Proven experience building and maintaining ETL/ELT workflows for marketing data; familiarity with Fivetran, Big Query, Snowflake, Airflow, and related tools.
• BI tooling:
  Highly proficient in Tableau; able to build dashboards from scratch and automate reporting.
• Git Hub:
  Working knowledge required; able to use for version control, code merge, and collaborative workflows.
• Marketing data fluency:
  Deep understanding of paid and organic channel performance (Tik Tok, Instagram, Meta,…