Data Engineer (Databricks)
Procter & Gamble10 days ago
Warsaw, PolandSenior
Responsibilities
- Design, build, test, and deploy automated data pipelines and ETL/ELT processes on Azure and Databricks.
- Develop production-ready Python and PySpark code for data transformations, integrations, and aggregations.
- Write, tune, and optimize complex SQL queries across database systems.
- Ensure end-to-end data quality, consistency, reliability, and performance across production data flows.
- Design and implement harmonized relational and analytical data models, including data warehouse structures.
- Analyze multi-source schemas, data flows, entity relationships, constraints, and business logic.
- Translate analytical requirements into scalable data structures in collaboration with analysts and business stakeholders.
- Serve as the technical SME, point of contact, and quality gatekeeper for external vendor engineers.
- Conduct code reviews and pull request approvals against coding, testing, and security standards.
- Partner with the Product Owner on delivery milestones, technical trade-offs, and technical debt mitigation.
- Promote engineering best practices, continuous integration and continuous deployment, and shared team standards.
Requirements
- Demonstrated experience conducting code reviews, establishing best practices, and providing technical guidance to junior peers or external vendor developers.
- Expert-level understanding and hands-on experience with relational data modeling, data warehousing concepts, star and snowflake schemas, 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 experience with Pandas.
- Hands-on experience developing PySpark solutions in a distributed computing environment.
- Strong practical experience with the Azure data stack, including Azure Data Lake Storage, Azure Data Factory, and Synapse Analytics.
- Strong practical experience with the Databricks platform.
- Exceptional analytical, problem-solving, critical-thinking, and communication skills, including the ability to explain technical trade-offs to stakeholders.
Benefits
- P&G-sized projects and access to global IT partners and technologies from the first day.
- Training and certification development opportunities.
- Competitive benefits including private health care, P&G stock, saving plans, and sport cards.
- Regular salary reviews and potential promotions based on results and performance.
- Opportunities to change roles every few years within P&G.
- Hybrid work model with the option to work from home two days per week.
- Full-time employment contract (Umowa o Pracę) in Warsaw.
About Procter & Gamble
Procter & Gamble is a global consumer packaged goods company that makes and sells household, personal care, and hygiene products through retailers and e-commerce. Its portfolio includes brands such as Pampers, Tide, Gillette, Oral-B, and Pantene, serving consumers worldwide. Founded in 1837 and headquartered in Cincinnati, Ohio, P&G is a public company listed on the NYSE under the ticker PG.