Senior Data Analyst

Description

**About the Position** ---------------- We are looking for a **Senior Data Analyst** to take on more complex challenges in analyzing, structuring, and transforming media and business data. More than just executing data processing tasks, we expect someone who can understand the underlying problems behind the data, investigate their root causes, propose solutions, and transform complex information into actionable insights for clients. You will work within a multidisciplinary squad closely collaborating with Marketing, Media, Customer Success, and Data Science teams, participating in projects that connect data, measurement, and decision-making. **Job Description** --------------------- Your challenge will be to lead end-to-end data processing and analysis for high-volume or highly complex client data and projects. You will have autonomy to structure processes, define validation rules, automate routines, and improve how data is received, transformed, and delivered. We also expect curiosity about the business. It’s not enough to identify an incorrect number — it’s essential to investigate why it’s wrong, what impact it has, and how to prevent recurrence. This role is ideal for someone who values deep technical expertise while also being able to look beyond code and translate data into business-relevant recommendations. **Responsibilities** --------------------- * Conduct complex data analyses and transformations. * Ensure quality, consistency, granularity, and traceability of data used across projects. * Investigate complex issues such as discrepancies between data sources, historical failures, and changes in data structures. * Structure and integrate data from files, APIs, platforms, and various systems. * Define validation rules and build controls to reduce errors during updates. * Build, automate, and evolve recurring data processing pipelines. * Identify bottlenecks and implement improvements to increase process efficiency and reliability. * Develop analyses revealing patterns, trends, and opportunities relevant to clients. * Translate technical results into clear explanations and actionable recommendations. * Contribute to the evolution of Media Hero’s dashboards and analytical products. * Organize and document data sources, business rules, transformations, and technical decisions. * Share knowledge and best practices with the team without formal management responsibilities. **Requirements** -------------- This position may be a strong match for you if you have: * Solid experience working with data analysis, transformation, and quality assurance. * Proficiency in Python, especially Pandas. * Proficiency in SQL for complex queries, joins, and analyses. * Experience handling multiple data sources and large volumes of information. * Ability to structure end-to-end analyses — from problem understanding to final recommendation. * Experience automating routines and building or maintaining data pipelines. * Knowledge of ETL or ELT processes. * A critical mindset to investigate root causes, assess impacts, and propose sustainable solutions. * Autonomy to prioritize tasks and manage projects of varying complexity. * Ability to communicate effectively with both technical professionals and business stakeholders. * Skill in translating complex analyses into clear, actionable conclusions. It’s an even stronger match if you’ve previously worked with: * Marketing Analytics, media data, or measurement projects. * Agencies, consulting firms, or technology and data companies. * dbt. * API-based integrations and extractions. * Data visualization tools and dashboard development. * Statistical modeling, Analytics Engineering, or Data Engineering. **What We Offer** -------------------- **Hiring Type:** PJ (Individual Contractor) **Health Insurance.** **Wellhub.** **Hybrid or remote work**, with an office located in São Paulo – SP.