Senior BI Engineer - Remote work | REF#305883

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

Benefits offered by this job

100% remote work

USD or local currency compensation

Hardware and home setup

Job summary

BairesDev offers a 100% remote BI Engineer role focusing on building end-to-end BI pipelines and semantic models. You will craft Python-based ETL/ELT processes, design Star/Snowflake data models, and deliver Power BI reports with advanced DAX metrics.

Expect strong collaboration across data engineering and analytics teams in a fully remote setup. Candidate should bring 5+ years in BI or data engineering, plus expertise in SQL, Delta Lake, PySpark, and CI/CD for BI using Azure DevOps or GitHub

Qualifications

• 5+ years of experience in BI or data engineering.
• Proficient in Python for ETL/ELT with Delta Lake, PySpark, pandas and REST API integrations.
• Experience with data modeling (Star/Snowflake) and semantic layer design in Power BI/Fabric.
• Strong DAX skills, including complex measures and KPIs.
• Advanced SQL skills and CI/CD for BI using Azure DevOps or GitHub Actions.

Responsibilities

• Build ETL/ELT pipelines in Python using Delta Lake, PySpark, pandas, and REST API integrations.
• Design data models with Star/Snowflake schemas and semantic layer in Power BI/Fabric.
• Develop and maintain Power BI reports with complex DAX measures and KPIs.
• Write advanced SQL queries and manage data 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.

Skills

Python ETL

Delta Lake

PySpark

Pandas

REST APIs

Data modeling

Star/Snowflake

Semantic layer

Power BI

Fabric

DAX

SQL Server

SQL

CI/CD BI

Azure DevOps

GitHub Actions

Data quality

English

Tools

Delta Lake

PySpark

Power BI

Fabric

SQL Server

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!