Junior Data Solutions Analyst

Jobtailor; São Paulo; Presencial; BRL 89 280 - 133 920; Tempo integral

Resumo da oferta

Jobtailor in São Paulo, Brazil is seeking a BI/Data Analytics specialist to gather requirements, validate data, and develop Power BI dashboards for internal and external use. You will work closely with marketing and tech teams to turn data into actionable insights and reliable reports.

Responsibilities include data ingestion, taxonomy management and QA, plus exploratory web analytics to validate campaign metrics.

Qualificações

• Experience in BI or data/tech analytics teams at advertising agencies, media companies, or digital marketing.
• Ability to work autonomously on most deliverables after the learning period.
• Analytical mindset for interpreting and solving problems.
• Power BI proficiency.
• Intermediate Excel/spreadsheets skills.
• Familiarity with SUMIF, VLOOKUP, ARRAYFORMULA and QUERY.
• Knowledge of taxonomy logic and parameterization of digital campaigns.
• Concepts of digital marketing and media.
• Agile methodologies desirable.
• Intermediate English desirable.
• Office tools: Excel/Spreadsheets, PowerPoint/Slides, Jira/Trello.
• Data visualization: Power BI; Looker Studio.
• Data: SQL, Google BigQuery and other GCP products.
• GA4 basics for reporting and metrics.

Responsabilidades

• Gathering and documenting requirements for data lake / dashboards
• Data validation and quality assurance (QA)
• Developing Power BI dashboards for internal and external use
• Exploratory Web Analytics analyses for data validation
• Ingestion of non-automated data
• Taxonomy management (implementation and training)
• Reports in database-format datasets

Conhecimentos

Power BI

Excel

Looker Studio

Data Visualization

Data Ingestion

Taxonomy Management

SQL

Google BigQuery

Python

GA4

Web Analytics

Agile Methodologies

SUMIF

VLOOKUP

Ferramentas

Jira

Trello

Google Analytics

Descrição da oferta de emprego

Responsibilities

• Gathering and documenting requirements for data lake / dashboards
• Data validation and quality assurance (QA)
• Developing Power BI dashboards for internal and external use
• Exploratory Web Analytics analyses for data validation
• Ingestion of non-automated data
• Taxonomy management (implementation and training)
• Reports in database-format datasets

Requirements

• Experience working in BI or data/technology/web analytics teams at advertising agencies, media companies, or areas related to digital marketing
• Ability to work autonomously on most deliverables after the learning period
• Analytical mindset for interpreting and solving problems
• Power BI
• Intermediate Excel/Spreadsheets skills
• Familiarity with formulas such as SUMIF, VLOOKUP, ARRAYFORMULA and QUERY
• Knowledge of taxonomy logic and parameterization of digital campaigns
• Concepts of digital marketing and media
• Agile methodologies: desirable but not mandatory
• Intermediate English is desirable
• Office tools: Excel/Spreadsheets, PowerPoint/Slides, Jira/Trello
• Data visualization: Power BI; Looker Studio
• Data: SQL, Google BigQuery and other GCP products
• Conceptual knowledge: Agile methodologies, media platforms
• Google Analytics – basic setup, basic reporting, metrics and dimensions
• Nice to have: BigQuery; Python; GA4

Hard Skills

• Data Visualization
• Data Ingestion
• Taxonomy Management
• Web Analytics
• Agile Methodologies
• Formulas (SUMIF, VLOOKUP, ARRAYFORMULA, QUERY)
• Google BigQuery
• Python
• GA4

Soft Skills

• Analytical Mindset
• Autonomous Work