Analytics Data Engineer

Philip Morris International; London; On-site; GBP 70,000 - 100,000; Full time

Job summary

Philip Morris International is seeking a Senior Data Engineer to play a crucial role in data transformation and architectural design. This role will develop and maintain scalable data solutions, ensuring data quality and governance while collaborating with various stakeholders. Join a company committed to smoke-free solutions and a diverse, inclusive workplace that values your contributions.

Benefits

Employee Assistance Program

Mental health support

Diversity and inclusion networks

Qualifications

• 8+ years of experience in data engineering.
• Strong skills in SQL and Python; experience with Power BI is a plus.
• Familiarity with ETL/ELT tools and data warehouse architecture.

Responsibilities

• Design, develop, and maintain scalable data models.
• Develop reliable data pipelines and integrate datasets using SQL and Python.
• Implement data quality checks and collaborate with stakeholders for tailored data solutions.

Skills

Data architecture

Pipeline development

SQL

Python

Power BI

Tools

ETL tools

Matillion

DBT

Job description

Be a part of a revolutionary change'

About us
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 stakeholders. 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 leverages 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 stakeholders 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.

Stakeholder Engagement

Engage with global stakeholders 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.

Skills, Experience and Competencies Required

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.