Job Description

The Trade Promotion & Analytics (TP&A) organization is embarking on a mission-critical initiative to consolidate our diverse enterprise data landscape into a single, unified data foundation. To achieve this, we are seeking a skilled, hands-on Data Engineer (Databricks) to join our team in Warsaw.

In this role, you will be at the core of designing and implementing a cohesive relational and analytical data model by integrating data across multiple systems. You will combine hands-on engineering—building robust, scalable pipelines in Databricks and Azure—with technical stewardship, serving as the subject matter expert and reviewer for external vendor developers. Your work will directly empower global teams with faster, more reliable insights and establish the data backbone for future analytics. If you have strong technical depth in Python, SQL, Databricks, and data modeling, and enjoy driving high-quality engineering standards, we would love to connect with you.

Key Responsibilities

1. Hands-On Development & Implementation (40%)

• Design, build, test, and deploy automated data pipelines and ETL/ELT processes on our Azure and Databricks platform.
• Write clean, maintainable, production-ready code in Python and PySpark for data transformations, integrations, and aggregations.
• Develop, tune, and optimize complex SQL queries to ensure high performance and efficient pipeline execution.
• Ensure end-to-end data quality, consistency, and reliability across all production data flows.

2. Data Modeling & Engineering Design (30%)

• Actively contribute to designing and implementing a harmonized relational and analytical data model that serves as the single source of truth for downstream analytics.
• Analyze existing multi-source data models and schemas to understand data flows, entity relationships, constraints, and business logic.
• Collaborate closely with Data Analysts and business stakeholders to translate analytical requirements into robust, scalable data structures.
• Ensure data modeling consistency, best practices, and thorough architectural documentation across data assets.

3. Technical Delivery & Vendor Oversight (30%)

• Act as the technical point of contact, SME, and quality gatekeeper for deliverables developed by external vendor engineers.
• Perform structured code reviews and pull request (PR) approvals to ensure compliance with P&G coding, testing, and security standards.
• Partner with the Product Owner to track delivery milestones, technical trade-offs, and early mitigation of technical debt.
• Promote best engineering practices, continuous integration/continuous deployment (CI/CD), and shared team standards.

Job Qualifications

• Technical Ownership & Guidance: Demonstrated experience conducting code reviews, establishing best practices, and providing technical guidance to junior peers or external vendor developers. Strong communication skills with the ability to articulate technical trade-offs to project stakeholders.
• Data Modeling: Expert-level understanding and hands-on experience with relational data modeling, data warehousing concepts (e.g., star/snowflake schemas), and database design.
• SQL Mastery: Expert-level proficiency in SQL, including writing complex queries, performance tuning, and working with advanced functions across different database systems.
• Python & PySpark: Advanced programming skills in Python for data manipulation (e.g., Pandas) and proven, hands-on experience developing solutions with PySpark in a distributed computing environment.
• Cloud & Big Data: Strong, practical experience with the Azure data stack (e.g., Azure Data Lake Storage, Azure Data Factory, Synapse Analytics) and the Databricks platform.
• Analytical Mindset: Exceptional analytical, problem-solving, and critical-thinking skills with a demonstrated ability to deconstruct complex business and data problems.

We offer

• P&G-sized projects and access to world leading IT partners and technologies from Day 1.
• Wide range of self-development possibilities (training and certifications paths).
• Competitive starting salary and benefits program (private health care, P&G stock, saving plans, sport cards).
• Regular salary increases and possible promotions - in line with your results and performance.
• Opportunity to change role every few years to be in the best place for you and best for P&G.

Kindly be advised that at P&G, employment is exclusively extended on the basis of an "Umowa o Pracę" (Full-time Employment Contract). Apply only if you agree to these conditions.