BI Coordinator

Description

Job Summary: We are seeking a BI professional with experience to extract, consolidate, and analyze data from media platforms, strategically delivering actionable insights. Key Highlights: 1. Strategic engagement with actionable insights for various departments 2. Leadership in multichannel attribution models 3. Monitoring of market and competitive trends We are one of Brazil’s largest independent communications groups, comprising six specialized and complementary companies that operate autonomously yet unite whenever necessary. Our mission is to develop outstanding professionals grounded in strong values and to push them beyond their comfort zones—encouraging them to dream, conceptualize, and execute projects. We are looking for someone to join our \#BI team. Responsibilities: - Extract, consolidate, and ensure data quality from platforms such as Google Ads, Meta Ads, GA4, CRMs, and other relevant sources; - Develop, update, and present strategic dashboards and reports that translate campaign metrics and consumer behavior into clear, actionable insights for internal teams and clients; - Conduct in-depth performance analyses across paid media, SEO, and social media, identifying trends, opportunities, and areas for improvement; - Serve as a strategic partner to Media, Creative, Planning, and Account teams, providing actionable insights to support decision-making; - Support or lead multichannel attribution models to assess the impact of different touchpoints along the consumer journey; - Monitor market trends, competitor activity, and audience behavior, identifying opportunities and risks for brands; - Ensure data governance and consistency, proposing improvements to processes and tools used; - Research and recommend new BI and analytics tools and methodologies that add value to agency operations. Requirements: - Completed undergraduate degree in Marketing, Advertising and Public Relations, Business Administration, Engineering, Data Science, or related fields; - Proven experience in BI, Analytics, or similar roles, preferably within advertising agencies or digital marketing firms; - Experience leading or coordinating BI/Analytics teams; - Advanced proficiency in data visualization tools (Power BI, Tableau, Looker Studio, etc.); - Solid hands-on experience with SQL for data manipulation, extraction, and transformation from multiple sources; - Excellent understanding of paid media platforms (Google Ads, Meta Ads, TikTok Ads, LinkedIn Ads) and web analytics tools, especially Google Analytics 4\. Desirable: - Experience with Google Tag Manager (GTM); - Certifications in BI tools or Google Analytics. Benefits: Flash Card \- At Rái, we no longer use the traditional designations VR, VA, and VT. Instead, we offer flexible benefits usable across categories including education, health, meals, groceries, mobility, and culture; On-site cafeteria; Birthday day off, so you can celebrate however you like; Flexible dress code; Free SESC membership; Porto Seguro health insurance plans; Porto Seguro dental insurance plans; Partnership with Creditas; Life insurance.