Senior Reporting Analyst / BI Solutions Specialist

Mars

Guararema

On-site

BRL 180,000 - 300,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Mars, Incorporated and its Affiliates is seeking a proactive Senior Reporting Analyst to design and deliver high-impact BI solutions. You will combine Power BI expertise and dimensional modeling with modern data engineering practices, acting as a bridge between internal customers and cloud data teams.

You will build scalable semantic models, author complex DAX calculations with time-intelligence and RLS, and craft executive dashboards that enable fast, data-driven decisions while optimizing data

Qualifications

  • 3-5+ years of hands-on experience designing and delivering enterprise Power BI solutions.
  • Proven ability to build performant star schemas from multi-source environments.
  • Advanced DAX and Power Query with security (RLS/OLS) and query folding awareness.
  • Understanding of transformation placement for scalability and cost efficiency.

Responsibilities

  • Lead discovery workshops with internal customers to define KPIs, logic, and dashboard UX.
  • Advise on data visualization best practices and user-centric analytical design.
  • Architect scalable semantic models and dashboards using star schemas.
  • Author complex DAX calculations including time-intelligence, dynamic metrics, and RLS.
  • Design executive-ready visualizations that drive actionable decisions.
  • Collaborate with Data Engineers to shape upstream Lakehouse tables and validate outputs.

Skills

Power BI
DAX
Power Query
Dimensional modeling
Star Schema
Semantic models
RLS
Dashboard design
DAX performance

Education

Bachelor's degree in a relevant field

Tools

SQL
Azure Databricks
Azure Data Lake
Snowflake
Delta Lake
Azure Data Factory

Job description

Job Description:

We are looking for a proactive, analytical, and customer-focused Senior Reporting Analyst to lead the design and delivery of high-impact BI solutions. In this role, you will combine deep technical expertise in Power BI and dimensional modeling with a keen interest in modern data engineering practices.

You will serve as a key bridge between internal customers and cloud data engineering teams—translating complex operational challenges and requirements into intuitive, high-performance executive dashboards while optimizing how data flows from the Lakehouse layer into semantic models.

Key Responsibilities
  • Lead Requirements Discovery & Advisory:
  • Facilitate discovery workshops with internal customers and cross-functional teams to define KPIs, reporting logic, and dashboard UX wireframes.
  • Confidently advise internal customers on data visualization best practices, cognitive ergonomics, and user-centric analytical design.
  • Architect Robust Semantic Models & Dashboards:
  • Build scalable, high-performance Star Schema models (Fact and Dimension structures) adhering to enterprise modeling standards.
  • Author sophisticated DAX calculations, including complex time-intelligence patterns, dynamic metrics, semi-additive calculations, and Row-Level Security (RLS).
  • Design clean, executive-ready dashboard visualizations that drive actionable decision-making for your internal customers.
  • Optimize Performance & Transformation Placement:
  • Evaluate transformation placement across the entire pipeline (Source vs. Lakehouse vs. Power Query/DAX) to preserve query folding and maximize refresh efficiency.
  • Diagnose and resolve report and visual latency using tools such as Power BI Performance Analyzer, DAX Studio, and VertiPaq Analyzer.
  • Collaborate with Data Engineering:
  • Partner with Data Engineers to shape upstream Lakehouse tables, validate pipeline outputs, and ensure semantic models consistently meet internal customer service-level expectations.
Qualifications & Experience
Essential Experience:
  • 3-5+ years of dedicated, hands-on experience designing and developing enterprise Power BI solutions, semantic data models, and executive dashboards.
  • Expert Dimensional Modeling: Proven ability to build performant Star Schemas from multi-source enterprise environments.
  • Advanced DAX & Power Query (M): Deep expertise writing maintainable DAX measures, implementing dynamic security (RLS/OLS), and leveraging Power Query with full query folding awareness.
  • Transformation Architecture: Clear understanding of where transformations belong across the stack to ensure scalability and cost-efficiency.
  • Customer Engagement & Advisory: Proven experience leading requirements discussions, managing expectations, and presenting analytical insights directly to internal customers and leadership.
Nice to Have (High Advantage):
  • 2+ years of practical experience working with SQL and modern cloud data architectures (e.g., Azure Databricks, Azure Data Lake / ADLS Gen2, Snowflake).
  • Databricks Integration: Hands-on experience connecting Power BI to Azure Databricks (Delta tables, Databricks SQL Warehouses) with a solid grasp of storage modes (Import, DirectQuery, and Composite Models).
  • Data Engineering Awareness: Familiarity with Delta Lake concepts/optimizations (e.g., Z-Ordering, Liquid Clustering) and cloud orchestration tools (e.g., Azure Data Factory).
Core Competencies & Mindset
  • Information Passion: Genuine enthusiasm for data storytelling, UI/UX clarity, and empowering internal customers through intuitive visual analytics.
  • Continuous Learner: Strong curiosity to explore upstream data engineering patterns, Lakehouse architectures, and emerging analytics tools.

#TBdigital

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Engineer
Business Intelligence Engineer

AgileEngine, LLC. • Brazil

Remote
BRL 180,000 - 300,000
Data Analyst
Data Analyst

Pride Global • Brazil

On-site
BRL 80,000 - 120,000
Senior Analytics Engineer Id90559
Senior Analytics Engineer Id90559

AgileEngine, LLC. • Florianópolis

Hybrid
BRL 495,000 - 660,000
Professional growth
Competitive USD-based compensation and
Exciting projects with Fortune 500/Top
+1
Senior Analytics Engineer Id90559
Senior Analytics Engineer Id90559

AgileEngine, LLC. • Curitiba

Hybrid
BRL 468,000 - 660,000
Professional growth
Competitive USD-based pay
Exciting projects
+1
Senior Analytics Engineer Id90559
Senior Analytics Engineer Id90559

AgileEngine, LLC. • Campinas

Hybrid
BRL 660,000 - 991,000
Professional growth
USD-based pay
Exciting projects
+1
Senior Analytics Engineer Id90559
Senior Analytics Engineer Id90559

AgileEngine, LLC. • São Bernardo do Campo

Hybrid
BRL 330,000 - 523,000
Professional growth
USD-based pay
Exciting projects
+1
Senior Analytics Engineer Id90559
Senior Analytics Engineer Id90559

AgileEngine, LLC. • Salvador

Hybrid
BRL 495,000 - 715,000
Professional growth
Competitive USD-based pay
Exciting projects
+1
Senior Analytics Engineer Id90559
Senior Analytics Engineer Id90559

AgileEngine, LLC. • Recife

Hybrid
BRL 495,000 - 715,000
Professional growth
Competitive USD pay
Exciting projects
+1
Senior Analytics Engineer Id90559
Senior Analytics Engineer Id90559

AgileEngine, LLC. • Rio de Janeiro

Hybrid
BRL 385,000 - 605,000
Professional growth
Competitive compensation
Exciting projects
+1
Senior Power Bi Id90559
Senior Power Bi Id90559

AgileEngine, LLC. • Brasília

Hybrid
BRL 495,000 - 826,000
Professional growth
Competitive pay
Exciting projects
+1