Senior BI Engineer - Remote work | REF#309043

BairesDev; São Paulo; Remote; BRL 383,000 - 602,000; Full time

Benefits offered by this job

Remote work

Competitive USD salary

Home setup provided

Flexible hours

Parental leave

Learning & growth

Job summary

BairesDev is seeking a Senior BI Engineer to build ETL/ELT pipelines in Python and shape data models that power meaningful dashboards. You’ll own end-to-end BI delivery, from data ingestion through semantic layer and KPI reporting.

The role requires 5+ years in BI or data engineering, strong SQL and Python skills, expertise with Power BI and Fabric, and experience with Delta Lake, PySpark, and CI/CD for BI using Azure DevOps or GitHub Actions. Remote work offered.

Qualifications

• 5+ years of experience in BI or data engineering.
• Strong Python for ETL/ELT, Delta Lake, PySpark, REST APIs.
• Data modeling with Star/Snowflake schemas and semantic layer in Power BI/Fabric.
• Experience with Power BI and DAX for KPI reporting.
• Advanced SQL skills and CI/CD for BI using Azure DevOps or GitHub Actions.
• Background building data quality and validation frameworks.
• Fluent English communication.

Responsibilities

• Build ETL/ELT pipelines in Python using Delta Lake and PySpark.
• Design data models and semantic layers for Power BI/Fabric.
• Develop and maintain Power BI reports with complex DAX measures.
• Write advanced SQL queries and manage data across SQL Server.
• Implement CI/CD pipelines for BI with Azure DevOps or GitHub Actions.
• Establish data quality and validation frameworks.

Skills

Python ETL

Delta Lake

PySpark

Pandas

REST API

Data modeling

Star/Snowflake schemas

Power BI

DAX

SQL

CI/CD for BI

Azure DevOps

GitHub Actions

Data quality

English

Tools

Power BI

Fabric

Delta Lake

SQL Server

Azure DevOps

GitHub Actions

Job description

At BairesDev®, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley.

Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant impact worldwide.

When you apply for this position, you're taking the first step in a process that goes beyond the ordinary. We aim to align your passions and skills with our vacancies, setting you on a path to exceptional career development and success.

Senior BI Engineer at BairesDev

In this role, you'll build ETL/ELT pipelines in Python that feed well-structured data models, powering the semantic layer behind meaningful business intelligence. Working across data modeling and Power BI, you'll ensure that KPIs and metrics reflect the underlying data accurately, from pipeline to dashboard. This is your opportunity to own the full BI lifecycle, combining strong data engineering fundamentals with deep expertise in delivering polished, reliable business intelligence.

What You'll Do

• Build ETL/ELT pipelines in Python using Delta Lake, PySpark, pandas, and REST API integrations.
• Design data models using Star/Snowflake schemas and semantic layer architecture in Power BI/Fabric.
• Develop and maintain Power BI reports, including complex DAX measures, KPIs, and calculated columns.
• Write advanced SQL queries and manage data manipulation across SQL Server or similar platforms.
• Implement CI/CD pipelines for BI using Azure DevOps or GitHub Actions.
• Build data quality and validation frameworks to ensure trustworthy reporting.

What We Are Looking For

• 5+ years of experience in BI or data engineering.
• Strong proficiency in Python for ETL/ELT, including Delta Lake, PySpark, pandas, and REST API integrations.
• Experience with data modeling, including Star/Snowflake schemas and semantic layer design in Power BI/Fabric.
• Experience with Power BI.
• Strong DAX skills, including complex measures, KPIs, and calculated columns.
• Advanced SQL skills with SQL Server or similar platforms.
• Experience with CI/CD for BI using Azure DevOps or GitHub Actions.
• Background building data quality and validation frameworks.
• Advanced proficiency in English.

Nice To Have

• Experience with Power Query (M) transformations.
• Familiarity with Microsoft Fabric, including Direct Lake and Lakehouse architecture.

How we do make your work (and your life) easier:

• 100% remote work (from anywhere).
• Excellent compensation in USD or your local currency if preferred
• Hardware and software setup for you to work from home.
• Flexible hours: create your own schedule.
• Paid parental leaves, vacations, and national holidays.
• Innovative and multicultural work environment: collaborate and learn from the global Top 1% of talent.
• Supportive environment with mentorship, promotions, skill development, and diverse growth opportunities.

Join a global team where your unique talents can truly thrive and make a significant impact!