Sr Web Analyst | Remote for Marketing Agency for Education

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Sr Web Analyst | Remote for Marketing Agency for Education based in Brazil. This is a senior data and analytics role at the core of a fast-growing performance marketing environment serving higher education and nonprofit organizations. You will own the end-to-end flow of marketing and CRM data, connecting advertising platforms and business systems into a reliable source of truth. The role spans data ingestion, pipeline architecture, BigQuery warehousing, SQL transformations, reporting, automation, and data quality. You will play a key role in scaling an automated reporting infrastructure without compromising accuracy, performance, or client trust. Working closely with Data & Analytics leadership and client-facing teams, you will turn complex data workflows into clear and actionable insights. This is a high-ownership opportunity within a distributed, async-friendly team where your technical work directly influences how partners understand and improve their performance. Accountabilities: • Own the architecture and maintenance of data ingestion pipelines connecting paid media platforms such as Meta, Google Ads, LinkedIn, TikTok, and programmatic advertising into Adverity or comparable ETL environments. • Develop custom Python connectors and automation for data sources that are not natively supported, ensuring scalable and reliable movement of data from source systems through to reporting. • Build and maintain CRM data integrations with platforms such as Slate, Salesforce, and HubSpot, ensuring lead, enrollment, and customer information flows accurately into the central data warehouse. • Manage Google BigQuery as the core data warehouse, designing efficient schemas for complex multi-source marketing data and optimizing partitioning, clustering, storage, query performance, and associated costs. • Develop modular, version-controlled, and documented SQL transformation pipelines using dbt or Dataform, establishing standardized naming conventions, mappings, and metric definitions across channels and clients. • Maintain CI/CD workflows using GitHub Actions and automated testing to support reliable, version-controlled data releases and robust development practices. • Design and maintain strict data segregation across multiple client environments, protecting data integrity and ensuring appropriate separation of datasets and reporting structures. • Build clean and performant data models and views specifically designed to power Looker Studio dashboards and automated Google Sheets reporting. • Partner with Data & Analytics leadership and client-facing teams to translate reporting requirements, business questions, and marketing KPIs into scalable warehouse models and reliable reporting solutions. • Monitor pipeline health, troubleshoot API failures and data discrepancies, reduce data latency, and implement validation frameworks and automated tests to continuously improve data quality. • Investigate data issues across source systems, warehouse transformations, and BI layers to identify root causes and proactively communicate data quality risks to stakeholders. • Contribute to the evolution of AI and machine-learning capabilities within marketing data infrastructure, including predictive analytics, anomaly detection, forecasting, and automated audience or workflow optimization. Requirements • 5+ years of hands-on experience in data engineering, ideally within a marketing, advertising, analytics, or agency environment. • Strong experience configuring data streams, transformations, and destinations in Adverity or a comparable ETL platform such as Fivetran, Supermetrics, or Funnel. • Intermediate to advanced SQL skills with proven experience working with Google BigQuery, including data transformation, modeling, partitioning, clustering, and performance optimization. • Strong expertise with dbt or Dataform and the ability to build modular, documented, version-controlled SQL transformation pipelines. • Proficiency in Python for developing custom API integrations, data connectors, automation, and pipeline processes. • Experience managing CRM data flows and integrations, particularly with Slate, Salesforce, and/or HubSpot. • Deep understanding of digital marketing metrics such as ROAS, CPA, and CAC, as well as the data structures and schemas used by major paid media platforms. • Experience structuring and optimizing data models to support performant Looker Studio dashboards and automated reporting workflows. • Proficiency with Git and collaborative software development practices, including version control, CI/CD, testing, and release management. • Proven ability to manage data across multiple clients while maintaining strict data segregation, security, consistency, and reliability. • Analytical, solution-oriented, and growth-minded approach, with strong attention to detail and a proactive attitude toward identifying and resolving technical issues. • Excellent communication skills and the ability to explain complex data architectures, workflows, and analytical concepts clearly to non-technical stakeholders. • Experience in education marketing, particularly higher education or online education, is highly valued. • Experience integrating AI or Machine Learning capabilities into marketing data pipelines is a plus. • Familiarity with AI and LLM tools for forecasting, automated audience segmentation, workflow optimization, or other marketing use cases is desirable. • Experience integrating and maintaining APIs for Generative AI platforms within a marketing data architecture is an advantage. • Knowledge of AI/ML-driven anomaly detection for monitoring pipelines and proactively identifying data quality issues is a plus. Benefits • Fully remote role with the flexibility of working within a distributed and async-friendly team. • Competitive compensation based on