HireFT
Browse JobsHow it worksPricingSuccess Stories
    Back to jobs
    MA

    Mars Brasil

    Food & Beverage

    Senior Reporting Analyst / BI Solutions Specialist

    GUA-Mars Brasil, BrazilHybridFull-time3–5 yrs experiencePosted 3w ago
    All Mars Brasil jobs

    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

    Job details are sourced from the employer's original posting.

    Open job posting
    MA

    About the company

    Mars Brasil

    Mars Brasil is the Brazilian subsidiary of Mars, Incorporated, a global manufacturer of confectionery, pet food, and other food products.

    View all Mars Brasil jobs
    Industry
    Food & Beverage
    Open roles
    85

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.