Sr Web Analyst | Remote for Marketing Agency for Education

Job description

**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.