Antwerp, Belgium





Job ID


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 better, smoke-free future. Thanks to the imagination and perseverance of thousands of people at PMI, we have developed smoke-free products that are better 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. As we are fully embarking on our transformation, we are looking for a Business Intelligence Analyst who can bring data-driven decision-making and consumer-centricity to the table to support our transition to smoke-free products in the Benelux. As Business Intelligence Analyst Benelux you will step into a dynamic and multi-cultural department. One that is pivotal to ensure Philip Morris achieves its ambition of creating a smoke-free future. In this role you will never stop leading and learning. You will have clear, impactful responsibilities from day one. 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. 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; Profile we are looking for: • A Master’s degree and 3- 5 years of relevant experience (business intelligence, science and / or data analytics) would be consider a pre; • Advanced Microsoft Power BI experience is required: o Experience in data modelling with adherence to best practices of building relationships and different types of storage modes. o Good understanding of enterprise-wide data models, composite models and golden datasets. o Experience in creating complex Power Query transformations. o Advanced knowledge and experience of DAX – Filter context, context transition, DAX queries and optimization methods. o Basic knowledge of using DAX Studio and DAX Queries. o Strong experience in building Power BI visualizations. • SQL Experience is required: o Ability to write advanced SQL queries i.e. containing CTEs and Subqueries to explore and analyse data available in the data warehouse. o Knowledge of using SQL queries in Power Query to create Power BI datasets and dataflows. • Basic understanding of ETL processes is preferred. 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. *Assessment Tests The tests are integrated in the selection process to increase objectivity of the final decision making. The assessment tests for this role is a cognitive ability test. The results will not be saved in the employee’s file, and will only be used in the context of the vacancy for which the employee is applying. Results are therefore not used for purposes of performance evaluation. • Cognitive Ability Test: Report links under three headings: 1. Deductive reasoning (measuring the ability drawing logical conclusions) 2. Inductive reasoning (measuring conceptual and analytical thinking) 3. Numerical reasoning (measuring capacity to understand numerical data and interpret mathematical information correctly)