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
Skills Required
- 3-5+ years of hands-on experience designing and developing enterprise Power BI solutions, semantic data models, and executive dashboards
- Expertise building performant star schema models from multi-source enterprise environments
- Advanced DAX expertise, including maintainable measures, time intelligence, dynamic metrics, semi-additive calculations, and dynamic RLS or OLS
- Advanced Power Query M expertise with query folding awareness
- Understanding of transformation placement across source, Lakehouse, Power Query, and DAX layers
- Experience leading requirements discussions, managing expectations, and presenting analytical insights to internal customers and leadership
- 2+ years of practical experience with SQL and modern cloud data architectures
- Experience with Azure Databricks, Azure Data Lake Storage Gen2, or Snowflake
- Hands-on experience connecting Power BI to Azure Databricks, including Delta tables, Databricks SQL Warehouses, Import, DirectQuery, and Composite Models
- Familiarity with Delta Lake optimizations such as Z-Ordering and Liquid Clustering
- Familiarity with Azure Data Factory and cloud orchestration tools
Mars Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Mars and has not been reviewed or approved by Mars.
-
Healthcare Strength — The benefits package is positioned as comprehensive, with broad medical coverage and additional protections like life insurance and short- and long-term disability. Mental health support is emphasized, including free mental health services and wellbeing programming under initiatives such as Mars Be Well.
-
Parental & Family Support — Paid parental leave is highlighted as market-leading in the U.S., with an example of 18 weeks fully paid for both parents. Additional family-related leave types such as sick time for caregiving and bereavement leave are also described as part of the overall package.
-
Retirement Support — Retirement offerings are described as strong, including 401(k) matching (with a 6% match cited) and pension plans in some cases. The broader package also references retirement savings options and contributions aligned to local market practice, supporting long-term financial security.
Mars Insights
What We Do
For more than a century, Mars, Incorporated has been driven by the belief that the world we want tomorrow starts with how we do business today. This idea is at the center of who we have always been as a global, family-owned business. Today, Mars is transforming, innovating and evolving in ways that affirm our commitment to making a positive impact on the world around us. Across our diverse and expanding portfolio of confectionery, food, and petcare products and services, we employ 133,000 dedicated Associates who are all moving in the same direction: forward. With $40 billion in annual sales, we produce some of the world’s best-loved brands including DOVE®, EXTRA®, M&M’s®, MILKY WAY®, SNICKERS®, TWIX®, ORBIT®, PEDIGREE®, ROYAL CANIN®, SKITTLES®, WHISKAS®, COCOAVIA®, and 5™; and take care of half of the world’s pets through our pet health services AniCura, Banfield Pet Hospitals™, BluePearl®, Linnaeus, Pet Partners™, and VCA™. We know we can only be truly successful if our partners and the communities in which we operate prosper as well. The Mars Five Principles – Quality, Responsibility, Mutuality, Efficiency and Freedom – inspire our Associates to take action every day to help create a world tomorrow in which the planet, its people and pets can thrive.
