At a Glance
- Tasks: Transform data into robust solutions for analytical consumption and support data science teams.
- Company: Join PMI, a leader in smoke-free product innovation and transformation.
- Benefits: Enjoy competitive salary, mental health support, and inclusive workplace culture.
- Other info: Be part of a diverse team committed to inclusion and continuous improvement.
- Why this job: Make a life-changing impact while advancing your career in a dynamic environment.
- Qualifications: 8+ years of experience in data architecture, SQL, Python, and ETL tools.
The predicted salary is between 60000 - 80000 € per year.
Be a part of a revolutionary change! At PMI we’ve chosen to do something incredible. We’re totally transforming our business and building our future on smoke-free products. With huge change comes huge opportunity. So, wherever you join us, you’ll enjoy the freedom to dream up and deliver better, brighter solutions and the space to move your career forward in endlessly different directions. If you want to make a life-changing impact on Customers, there’s nowhere better to develop your career.
Main Purpose of Role
The role is crucial in transforming data by bridging data warehousing and business analysis into robust data solutions for analytical consumption for key partners. The role will be responsible for working to build out and improve the company's data ingestion, transformation, transactional and data warehousing needs directly supporting the data science and analyst teams. This role is essential to building and scaling new and existing local data streams to support PML’s growing data products and services. In addition to this, the role will review and redesign product to address resource heavy processes. Partnering with the Manager Data Capability and Head of Data and Analytics, the role will be working on varying, complex projects that leverage expertise in Power BI, to help the organisation harness the power of cloud technologies available to PMI such as Amazon Web Services (AWS), Matillion and Snowflake. The role will also work with market LT in order to understand the business strategy and therefore design data products to serve the strategy. The role is autonomous and therefore requires someone who can bring solutions to problem statements around data.
Responsibilities
- Data Modeling & Warehousing: Design, develop, and maintain scalable data models and ensure the data warehouse is consistent and future-proof.
- Data Pipelines: Develop reliable data pipelines to ensure seamless data flow, considering data lineage and optimization. Perform database tuning and optimization for improved query performance.
- Data Integration: Use ETL tools, SQL, and Python to integrate external datasets into the data warehouse.
- Data Quality & Security: Implement data quality checks and ensure compliance with data protection regulations.
- Performance Optimization: Enhance data storage and retrieval processes for better performance and scalability.
- Data Governance: Apply data governance principles, including metadata management and documentation. Drive best practices and ensure the data platform meets business needs.
- Collaboration: Collaborate with data scientists, analysts, and other partners to understand data requirements and design tailored data solutions. Collaborate with IT to align projects with infrastructure and policies.
- Documentation: Maintain comprehensive documentation of data models and processes.
- Business Translation: Convert business logic into data products and actionable insights.
- Partner Engagement: Engage with global partners to understand the impact of global changes on local data. Partner with market LT to align data design to market strategy.
- Enterprise Data Analytics: Engage and adhere to enterprise data analytics guidelines and utilize appropriate tooling.
Who We're Looking For
- 8 years+ SME experience
- Strong skills in data architecture and pipeline development, with extensive experience in SQL and Python; PowerBI knowledge is a plus.
- Experience with ETL/ELT tools (e.g., Matillion, DBT).
- Strong understanding of data warehouse engineering and architecture principles.
Additional Role Requirements
Stay updated with industry trends to improve data engineering practices.
Our Commitment to Inclusion
PMI is on a continuous journey to ensure that all of our employees feel welcome and feel that they belong. We have a number of internal networks that are inclusive and open for anyone to join, including networks covering employees from ethnic minority backgrounds, LGBTQ+ and gender. We’re also extremely proud to be the first global company to be awarded Equal Salary Certification. We take wellbeing seriously, so we have trained mental health First Aiders to help support our employees, as well as support in the form of our LifeWorks app and Employee Assistance Program. PMI is an equal opportunities employer, hiring solely on merit and business need. We encourage applications regardless of sex, gender identity, ethnicity, age, sexual orientation, gender reassignment, religion or belief, marital status, pregnancy, parenthood and disability. If you require reasonable adjustments in any recruitment process with us, please make us aware.
Data Engineer employer: Philip Morris International
At PMI, we are committed to fostering a dynamic and inclusive work environment where innovation thrives. As a Data Engineer, you will have the opportunity to work on transformative projects that leverage cutting-edge cloud technologies, while enjoying comprehensive support for your professional growth and wellbeing. Our culture prioritises collaboration and diversity, ensuring that every employee feels valued and empowered to make a meaningful impact in their career.
Contact Detail:
Philip Morris International Recruiting Team
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Network like a pro! Reach out to current employees at PMI on LinkedIn or through mutual connections. A friendly chat can give you insider info and might just get your foot in the door.
✨Tip Number 2
Show off your skills! Prepare a portfolio or a project that highlights your data engineering expertise, especially with SQL, Python, and Power BI. This will help you stand out during interviews.
✨Tip Number 3
Be ready to discuss real-world problems! Think of examples where you've solved complex data issues. PMI loves candidates who can bring solutions to the table, so be prepared to showcase your problem-solving skills.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're genuinely interested in being part of the PMI transformation journey.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Show Off Your Skills:When you're writing your application, make sure to highlight your experience with data architecture and pipeline development. We want to see how your skills in SQL, Python, and any ETL tools you've used can bring value to our team!
Tailor Your Application:Don’t just send a generic application! Take the time to tailor your CV and cover letter to reflect the specific requirements of the Data Engineer role. Mention how your past experiences align with our mission to transform data solutions.
Be Clear and Concise:Keep your application clear and to the point. Use bullet points where possible to make it easy for us to read through your qualifications and achievements. We appreciate straightforward communication!
Apply Through Our Website:Make sure to apply through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at Philip Morris International
✨Know Your Data Inside Out
Before the interview, brush up on your knowledge of data architecture and pipeline development. Be ready to discuss your experience with SQL, Python, and any ETL tools you've used, like Matillion or DBT. This will show that you’re not just familiar with the concepts but can also apply them in real-world scenarios.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled complex data challenges in the past. Think about specific projects where you designed data models or optimised data pipelines. Highlighting your ability to bring solutions to problem statements will resonate well with the interviewers.
✨Understand PMI's Vision
Familiarise yourself with PMI’s transformation towards smoke-free products and how data plays a role in this shift. Being able to articulate how your skills can contribute to their mission will demonstrate your genuine interest in the company and its goals.
✨Collaborate and Communicate
Since the role involves working closely with data scientists and analysts, be prepared to discuss how you’ve collaborated in the past. Share examples of how you’ve translated business logic into actionable data insights, as this will showcase your ability to work within a team and understand broader business strategies.