Mid-Level BI Analyst – Paid Media Data Focus

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Perform swift ad hoc analyses of paid media effectiveness, addressing team inquiries and aiding optimization strategies.

• Extract, merge, and manipulate data from various media platforms, including Google Ads, Meta Ads, TikTok Ads, LinkedIn Ads, and DV360.

• Create and sustain paid media performance dashboards and reports, emphasizing investment efficiency and business results.

• Track critical campaign metrics, recognizing deviations, trends, and opportunities.

• Organize budget allocation analyses, cross-channel comparisons, and assessments of A/B tests, creatives, and audiences.

• Ensure the integrity and consistency of media data, identifying discrepancies between platforms and internal sources.

• Record queries, models, and metric definitions, contributing to the team's data governance efforts.

⛳️ Requirements

• Skilled in SQL for data extraction, processing, and joining.

• Prior experience with paid media data and familiarity with major advertising platforms.

• Knowledge of digital performance and business metrics (CPA, CAC, ROAS, LTV, conversion funnels).

• Experience utilizing data visualization tools (e.g., Power BI, Looker Studio, Tableau).

• Strong analytical skills, agility in addressing business questions, and the capability to prioritize effectively.

• Keen attention to detail and a critical viewpoint on data quality.

• Excellent communication abilities to convey data insights clearly to non-technical teams.

• Preferred: experience with Databricks.

• Preferred: familiarity with Python for data analysis.

• Preferred: experience with GA4, Google Tag Manager, or attribution tools (e.g., AppsFlyer).

• Preferred: background in financial institutions, cooperatives, or companies with established performance marketing operations.

🏝️ Benefits

• Meal and food allowance: financial support for purchasing meals and groceries.

• Home office and hybrid work allowance: monthly assistance for employees working remotely or in a hybrid setup.

• Daycare/nanny reimbursement: monthly reimbursement for childcare, preschool, or nanny costs.

• Mobility allowance: financial aid for transportation expenses.

• Profit-Sharing Program (PPR).

• Corporate life insurance.

• Private pension plan with company matching contributions.

• Health insurance coverage for you and your dependents.

• Dental insurance for you and your dependents.

• English Pass: access to a digital English-learning platform.

• Wellhub (Gympass).

• Zenklub: platform offering access to psychologists and personal development resources for you and your dependents.

• Holiday gift basket.

• Birthday day off.

• Day off on your children’s birthdays.

• Maternity leave: 180 days (six months).

• Paternity leave: 20 days.