Senior Data Analyst

Description

**About the Role** ---------------- We are looking for a **Senior Data Analyst** to transform media and business data into reliable, organized, and analysis-ready information. You will join the squad responsible for client deliverables, working side-by-side with professionals from Marketing, Media, Customer Success, and Data Science. We seek someone with a solid technical foundation who can independently manage their workflows and enjoys investigating data, identifying inconsistencies, and simplifying and improving processes. **Job Description** --------------------- Your challenge will be to ensure that client-provided data is complete, consistent, and prepared for use in measurement models, dashboards, and analyses. In practice, you will work with various files, spreadsheets, APIs, and platforms. You will be responsible for understanding this information, identifying issues, performing necessary transformations, and helping convert manual processes into more automated routines. This is an excellent opportunity for those who wish to grow in an environment connecting data, marketing, and technology—with room to advance in Analytics, Automation, Visualization, or Data Engineering. **Responsibilities** --------------------- * Receive, organize, interpret, and validate media and business data. * Identify duplicates, missing data, breaks in historical series, and discrepancies across sources. * Combine information from files, spreadsheets, platforms, and other sources. * Prepare data used in measurement models, dashboards, and analyses. * Document identified issues and collaborate with the squad to define solutions. * Support mapping of accounts, fields, and information extracted via APIs. * Develop and maintain data cleaning and transformation routines. * Support building automated pipelines for recurring updates. * Create analyses to identify relevant patterns, trends, and behaviors. * Contribute to building and evolving dashboards delivered to clients. * Identify opportunities to reduce manual work and make processes faster and more reliable. **Requirements** -------------- This role may be a good fit if you have: * Practical experience in data analysis, manipulation, and processing. * Knowledge of Python, especially Pandas. * Strong experience with SQL for queries, joins, and analyses. * Proficiency with Excel and Google Sheets. * Ability to organize and combine data from diverse sources. * Attention to detail for identifying inconsistencies and data quality issues. * Organizational skills to manage multiple clients, requests, and recurring updates. * Autonomy to handle medium-complexity tasks and seek support when needed. * Strong communication skills to collaborate with stakeholders across different domains and technical backgrounds. It’s even better if you have prior experience with: * Media, marketing, or measurement project data. * Agencies, consulting firms, or technology companies. * dbt. * Data pipelines and ETL or ELT processes. * APIs and routine automation. * Data visualization tools. **What We Offer** -------------------- **Employment type:** PJ or CLT. **Health insurance.** **Wellhub.** **Hybrid or remote work**, with an office in São Paulo – SP.