Business Intelligence Analyst

Welcome to our Philip Morris vacancy. Did you know that Philip Morris International is undergoing a revolutionary business transformation? We will be far more than a leading cigarette company. We want to change society and deliver a smoke-free future. Thanks to the imagination and perseverance of thousands of people at PMI, we have developed smoke-free alternatives to cigarettes. And it does not stop there. We are investing in a portfolio of innovative products beyond nicotine. So, whether in new product development, commercialization, operations, science, you name it, we are putting our vision into reality every day and make the change happen, right now. Do you want to be part of this transformation? Do you want to join our team of optimistic people to build a new future? As we are fully embarking on our transformation, we are looking for a Business Intelligence Analyst passionate for insights, data and modelling to foster data-driven decision-making and support our transition to smoke-free products in the Benelux. Do you feel thrilled when we say you can help us building and reinforcing our commitment to replacing cigarettes by better alternatives? Are you an energetic professional that can collaborate within a team of young potentials, can grasp the essence out of numbers and loves collaborating with others to substantiate strategic initiatives with data analytics and business insights? If so, then please continue reading. Responsibilities of the role: • Ensuring data quality assurance and governance across reports; • Contributing to the Benelux strategy through scenario and predictive modelling, data mining and insights. • Working with data analytics to get actionable insights out of big data sets; • Collaborating with cross-functional colleagues in a challenging environment, which means participating and collaborating with various stakeholders and project groups to gather and prioritize the information required; • Ensuring data quality assurance and governance across reports; You’ll be our ideal candidate if you: 1. Advanced Microsoft Power BI experience is required: • Experience in data modelling with adherence to best practices of building relationships and different types of storage modes. • Good understanding of enterprise-wide data models, composite models and golden datasets. • Experience in creating complex Power Query transformations. • Advanced knowledge and experience of DAX – Filter context, context transition, DAX queries and optimization methods. • Basic knowledge of using DAX Studio and DAX Queries. • Strong experience in building Power BI visualizations. 2. SQL Experience is required: • Ability to write advanced SQL queries i.e. containing CTEs and Subqueries to explore and analyse data available in the data warehouse. • Knowledge of using SQL queries in Power Query to create Power BI datasets and dataflows. 3. Basic understanding of ETL processes is preferred. 4. A Master’s degree and 3- 5 years of relevant experience (business intelligence, science and / or data analytics) would be consider a pre; How does this sound? If you are interested, then please apply via the ‘apply now’ button What will the selection process look like? Talent Acquisition (TA) will perform an initial screening to assess whether candidates match with the defined vacancy requirements. If this is the case, the candidate will be invited for 2 competency-based (virtual) interviews. In parallel, you will be asked to complete online assessment tests*. At the end of the process, each candidate will receive the assessment results, as well as actionable feedback for their further development.