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

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

ABOUT THIS ROLE:
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 TikTok, Instagram, Meta, and Google Ads—leveraging tools such as Fivetran, BigQuery, 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 GitHub 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.

RESPONSIBILITIES:

• Build, maintain, and optimize scalable data pipelines (ETL/ELT) that ingest, transform, and model marketing data from multiple sources (e.g., TikTok, Instagram, Meta, Google Ads, YouTube, Pinterest, Reddit) using tools like Fivetran, BigQuery, 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 GitHub for version control, code check-in/check-out, and code merge workflows; collaborate with team on pipeline and dashboard code.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

REQUIRED EXPERIENCE:

• 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, BigQuery, Snowflake, Airflow, and related tools.
• BI tooling: Highly proficient in Tableau; able to build dashboards from scratch and automate reporting.
• GitHub: 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 (TikTok, Instagram, Meta, Google Ads, etc.) and relevant metrics.
• Automation: Experience automating data extraction and reporting jobs for social platforms.
• Strong communicator: Able to translate complex data work into clear narratives for non-technical stakeholders.

PLUSSES:

• Experience with Python for analytics workflows and automation.
• Hands-on experience with brand measurement methodologies (MMM, lift studies, attribution modeling).
• Experience presenting insights and recommendations to marketing leadership.
• Experience collaborating with cross-functional teams (Brand, Growth, Data Science).

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.