Mars
Senior Reporting Analyst / BI Solutions Specialist
BRA-Sao Paulo-Guararema
hirly Pro
Get in front of the people hiring at Mars
- Reach the hiring manager at Mars on LinkedIn, from your own account
- hirly applies to this job for you, with unlimited applications
- A resume and cover letter written for this job, unlimited
- The hiring manager and recruiter at Mars, with contact details
$49 a month · ₹1,999 for 30 days in India · cancel any time
Get past the screening software and onto a recruiter's desk
hirly rewrites your resume for this job — matching the keywords and skills in the posting, moving your most relevant experience to the top, and writing a cover letter to fit. About 30 seconds.
- Keywords matched to this posting
- Fit score before you apply
- Cover letter included
Matched against 2.8M live jobs from 220,000+ employers in 200+ countries.
Tailor my resume for this job →Apply from your AI assistant
Connect hirly to Claude or ChatGPT and ask it to apply to this job. hirly tailors your resume, fills the employer’s form and asks before sending.
Some employer sites stop an application at a CAPTCHA or sign-in and hand it back with a link. Applying needs a paid plan. Works with any assistant that supports MCP.
hirly's read of this role
- Seniority
- Senior
- Country
- BR
- Work mode
- On-site / unstated
- First seen by hirly
- 23 Sept 2026
Derived automatically from the posting. Upload your resume above to see how the role scores against it.
the posting
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
Listed on hirly, a job board. hirly is not the employer: Mars is hiring for this role.
Similar jobs
- People Analytics & Workday Reporting AnalystLivenation · Work from Home - BrazilFirst seen 44d agoremote
- People Analytics & Workday Reporting AnalystLivenation · Work from Home - BrazilFirst seen 51d agoremote
- Senior Product Reporting AnalystWellington · 2 LocationsFirst seen 6d ago
- Senior Product Reporting AnalystWellington · 2 LocationsFirst seen 6d ago
- Senior Commercial Analytics & Reporting AnalystLatitudefinancial · AUS VIC MelbourneFirst seen 7d ago
Browse similar roles
Want this one?
Upload your resume and hirly rewrites it for this job and writes the cover letter — in about thirty seconds, before you sign up.
Tailor my resume for this job