Data Engineer for trade promotion analytics

Procter & Gamble; Warszawa; Hybrid; PLN 180,000 - 260,000; Full time

Benefits offered by this job

Private health care

P&G stock

Saving plans

Sport cards

Hybrid work model

Job summary

Procter & Gamble ищет опытного Data Engineer для разработки и поддержки конвейеров данных на Azure и Databricks. Ваша роль включает проектирование, построение и тестирование ETL/ELT- пайплайнов, а также написание чистого Python и PySpark кода и оптимизацию запросов.

Ключевые задачи — обеспечить качество данных, спроектировать единую модель данных и сотрудничать с аналитиками и бизнес-стейкхолдерами. Гибридная работа, возможность работать удаленно 2 дня в неделю.

Qualifications

• Опыт разработки ETL/ELT конвейеров и пайплайнов в облаке.
• Глубокое знание SQL и оптимизация запросов.
• Экспертное владение Python; опыт с PySpark.

Responsibilities

• Проектирование и развёртывание ETL/ELT пайплайнов на Azure и Databricks.
• Написание чистого Python и PySpark кода.
• Оптимизация сложных SQL запросов для высокой производительности.
• Обеспечение качества данных на протяжении всех конвейеров.
• Сотрудничество с аналитиками и стейкхолдерами для трансляции требований.
• Разработка единой концепции моделей данных.
• Документирование архитектуры и руководство внешними поставщиками.

Skills

Relational data modeling

Data warehousing concepts

SQL proficiency

Python programming

PySpark

Azure data stack

Schema design

Technical guidance

Stakeholder communication

Tools

Databricks

Azure Data Factory

Azure Data Lake Storage

Azure Synapse Analytics

SQL databases

Job description

Описание:

Procter & Gamble produces globally recognized consumer brands and serves consumers worldwide. Its portfolio includes brands such as Always, Ariel, Gillette, Head & Shoulders, Oral-B, and Pampers, with operations in approximately 70 countries.

Задачи:

• Design, build, test, and deploy automated data pipelines and ETL/ELT processes on Azure and Databricks
• Write clean, maintainable, production-ready Python and PySpark code for data transformations, integrations, and aggregations
• Develop, tune, and optimize complex SQL queries for high performance and efficient pipeline execution
• Ensure end-to-end data quality, consistency, and reliability across production data flows
• Design and implement a harmonized relational and analytical data model as a single source of truth for downstream analytics
• Analyze multi‑source data models and schemas, including data flows, entity relationships, constraints, and business logic
• Collaborate with Data Analysts and business stakeholders to translate analytical requirements into scalable data structures
• Ensure consistent data modeling practices and maintain architectural documentation across data assets
• Act as the technical point of contact, subject matter expert, and quality gatekeeper for external vendor deliverables
• Review code and approve pull requests to ensure compliance with coding, testing, and security standards
• Partner with the Product Owner to track delivery milestones, technical trade‑offs, and early mitigation of technical debt
• Promote engineering best practices, CI/CD, and shared team standards

Требования:

• Experience conducting code reviews, establishing best practices, and providing technical guidance to junior peers or external vendor developers
• Strong communication skills and ability to explain technical trade‑offs to project stakeholders
• Expert-level understanding and hands‑on experience with relational data modeling, data warehousing concepts, and database design
• Expert-level SQL proficiency, including complex queries, performance tuning, and advanced functions across database systems
• Advanced Python programming skills for data manipulation, including Pandas
• Hands‑on experience developing PySpark solutions in distributed computing environments
• Practical experience with the Azure data stack, including Azure Data Lake Storage, Azure Data Factory, or Synapse Analytics, and Databricks
• Strong analytical, problem‑solving, and critical‑thinking skills, including the ability to break down complex business and data problems

Условия:

• Competitive starting salary and benefits, including private health care, P&G stock, saving plans, and sport cards
• Regular salary increases and possible promotions based on results and performance
• Training and certification opportunities
• Role-change opportunities every few years
• Hybrid work model with the option to work from home two days a week
• Employment exclusively under an “Umowa o Pracę” full‑time employment contract; apply only if you agree to these conditions