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 experience and location.
• High-visibility position within a growing Data & Analytics function, with significant ownership of the organization’s reporting infrastructure.
• Opportunity to build and evolve the data backbone supporting education and nonprofit organizations working toward meaningful social impact.
• Direct ownership of pipelines, models, and reporting infrastructure that influence how partners understand and trust their performance data.
• Collaborative culture focused on continuous improvement, teamwork, high performance, and finding better ways to solve complex challenges.
• Opportunity to work with modern data engineering, cloud analytics, marketing technology, automation, AI, and Machine Learning capabilities.
• Strong potential for professional growth as the data and analytics function continues to scale.
• Compensation and any additional benefits are determined by the hiring company and will be discussed during the recruitment process.