Senior BI Analyst

Role Overview

About the position

We are looking for a Senior BI Analyst with strong skills in data modeling, transformation and analytics, able to move between technical and business areas and support strategic decisions through data.

The person will play a key role in building analytical models, organizing pipelines and advancing the data maturity of the area.

**

Responsibilities

• Develop and maintain analytical data models
• Build and optimize SQL queries for analysis and data transformation
• Work with dimensional modeling (Star Schema, Data Marts, etc.)
• Develop and maintain pipelines using DBT
• Work with data in GCP (BigQuery)
• Version code and collaborate via Git
• Support business areas with data-driven analyses and insights
• Participate in the evolution of analytical architecture and BI best practices
• Work with data orchestration tools (e.g., Airflow)
• Identify opportunities for automation and applied AI in data

Requirements

Mandatory requirements

• Solid experience as a BI / Analytics Analyst
• Advanced knowledge of SQL
• Experience with DBT (data modeling and transformation)
• Experience with data modeling (dimensional, Star Schema, etc.)
• Experience with GCP (BigQuery)
• Experience with Git (versioning and collaboration best practices)
• Experience with orchestration tools (e.g., Airflow)
• Good communication and ability to interact with business areas
• Analytical profile, organized and with a sense of priority

**

Differentials

• Experience with Power BI
• Knowledge of Python
• Experience or interest in AI / automation

Expected profile

• Good communication and ability to influence
• Proactivity and sense of ownership
• Ability to work with multiple demands
• Ease in transitioning between technical and business contexts
• Collaboration with multidisciplinary teams
• Organization and autonomy in delivering results

Tech Stack

• Airflow
• BigQuery
• Google Cloud Platform
• Python
• SQL

Benefits

• 🏥 Porto Seguro Medical Plan Comprehensive care for you and your family, with the possibility to include spouse and children.
• 🦷 Porto Seguro Dental Plan Dental coverage for you and your dependents.
• 💰 Profit Sharing (PLR) Recognition for your work and contribution to the company’s success.
• 👶 Childcare Allowance Financial support to help parents care for their children with peace of mind.
• 🍽️ Alelo Food and Meal Vouchers Ensuring convenient and comfortable meals in your daily routine.
• 💻 Home Office Allowance Support to help you set up a comfortable workspace at home.
• 📚 Partnerships with Educational Institutions Access to education with discounts and incentives for courses and degrees.
• 🚀 Support for Certifications, including Cloud Advance your career with certifications in leading technologies such as GCP, Azure, AWS, and others.
• 🎁 Livelo Points Earn points and use them as you prefer, with full freedom of choice.
• 🏋️‍♂️ Total Pass Health incentive with discounted gym plans for employees and family members.
• 🧘‍♂️ Mindself Support to improve quality of life through meditation and mindfulness.