Job Location
WARSAW PLANT & GO
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.
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.
About us
We produce globally recognized brands and we grow the best business leaders in the industry. With a portfolio of trusted brands as diverse as ours, it is paramount our leaders can lead with courage the vast array of brands, categories and functions. We serve consumers around the world with one of the strongest portfolios of trusted, quality, leadership brands, including Always®, Ariel®, Gillette®, Head & Shoulders®, Herbal Essences®, Oral-B®, Pampers®, Pantene®, Tampax® and more. Our community includes operations in approximately 70 countries worldwide. Visit http://www.pg.com to know more.
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.
- At Procter & Gamble we embrace a hybrid work model that combines the flexibility of remote work with the collaborative benefits of in-office engagement. Employees can enjoy the option to work from home two days a week while also spending time in the office to foster teamwork and enhance communication.
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.
