Position Title: Senior BI & Analytics Specialist
Auckland, AUK, NZ, 1010
-
At Philip Morris International (PMI), we’re transforming our business to deliver a smoke-free future.
As part of this transformation, we’re looking for a Senior BI & Analytics Specialist to join our Data, Insights & Analytics team in our Auckland office.
Internally, this role is known as Business Intelligence Senior Specialist.
This is a hands-on technical role at the intersection of BI development, data modelling and commercial analytics. You’ll build the data foundations behind our reporting and analytics, developing scalable solutions that turn complex business questions into meaningful insights.
This isn’t just about building dashboards. We’re looking for someone who enjoys getting into the data, developing robust models and creating solutions that enable better business decisions.
What You’ll Be Doing
Own, Deliver & Improve BI Solutions
- Own dashboards and reporting solutions, ensuring they are accurate, reliable and delivered on time
- Design, develop and continuously improve Power BI solutions
- Use DAX, Power Query and SQL to solve analytical and reporting requirements
- Build and maintain robust data models and reusable datasets
- Integrate and transform data from multiple sources
- Optimise BI solutions for performance, reliability and usability
- Own solutions from understanding business requirements through to delivery and ongoing support
Turn Data into Commercial Insights
- Translate business questions into analytical and technical solutions
- Analyse customer, sales, product, channel and market data
- Turn complex information into clear, actionable insights
- Partner with commercial teams to understand performance drivers and opportunities
- Communicate findings clearly to technical and non-technical stakeholders
Strengthen Data Quality & Simplify How We Work
- Maintain high standards of data accuracy through validation, reconciliation and quality controls
- Support consistent KPI definitions and strong data governance
- Identify and resolve recurring data and reporting issues
- Automate and simplify manual reporting processes
- Explore technologies such as Microsoft Fabric, Azure, Python, Power Automate and AI where they add value
We’re Looking For Someone Who Has
- Strong Power BI capability, including DAX and Power Query
- Good SQL capability and experience working with multiple data sources
- Experience developing data models and reusable reporting datasets
- Strong understanding of data quality, validation and reconciliation
- Ownership and accountability for accurate and timely BI delivery
- Ability to translate business problems into effective data and analytics solutions
- Strong communication and stakeholder management skills
- A curious, practical and hands-on approach to problem solving
It Would Be Great If You Also Have
- Semantic or dimensional data modelling experience
- Microsoft Fabric, Azure or Snowflake experience
- Python, automation, API or data integration experience
- Exposure to forecasting, segmentation or predictive analytics
- Experience in FMCG, retail or another commercially focused environment
What We Offer
- Competitive salary package, including private health insurance
- Opportunity to work across data, technology and commercial analytics
- A dynamic, diverse and inclusive team culture
- Career development opportunities locally and internationally