IT Manager - Data & Analytics Data Engineer

About IT in Procter & Gamble:
This is where business, innovation and technology come together to create competitive advantage. Our mission is to deliver IT to help P&G win with consumers all over the world.
We are part of a global organization with Warsaw being the second biggest P&Gs IT office (~250 people). We apply IT mastery to deliver game-changing, technology-driven business models and capabilities. If you want to work at a place where newest technologies like machine learning, artificial intelligence or big data meet real world problems – this is the place for you. Whether your role is to create an IT innovation strategy for a business, protect our critical information systems and assets, or manage a strategic supplier in our cutting-edge Shared Services organization, your passion for technology and its business application will be recognized and rewarded.
Our IT Managers team is leading the transformation of P&G's Supply Chain to digitize and transform P&G through industry best practice capabilities, systems and work processes. We are managing one of the biggest SAP installations within our industry, augmented by applications from smaller companies and startups in the area of forecasting, operational planning and detailed scheduling as well as transportation and warehouse management
About P&G
P&G serves consumers around the world with one of the strongest portfolios of trusted, quality, leadership brands, including Always®, Ambi Pur®, Ariel®, Bonux®, Braun®, Blend-a-Med®, Fairy®, Gillette®, Head & Shoulders®, Lenor®, Naturella®, Olay®, Oral-B®, Pampers®, Pantene®, Vizir®, Vicks® The P&G community includes operations in approximately 70 countries and more than 100 thousand employees worldwide. Please visit for the latest news and information about P&G and its brands.

Location: Warsaw

Role Description:
Data Wranglers and Data Engineers at P&G are technical masters: at P&G they need to be effective technologists, self-motivated, and able to source and develop data models to fuel the analytics, developed by the analysts and data scientists, which improve P&G’s business results. Data Engineering is an acceleration factor behind the productivity and effectiveness of Data Science. Technical mastery and interpersonal /communication skills are therefore a must to thrive in a team. Your job is to onboard complex data or optimize data models and code into scale pipes and jobs that will drive the analytics into insights you. Data and Analytics roles include:
Data Wrangler - Delivers data acquisition, transformations, cleansing, conversion, compression, and loading of data into data and analytics models. Work in partnership with data science and analysts to understand use cases, data needs, and outcome objectives. As a partner, you will have project work and ad hoc requests that require agility and often fast paced response to business needs.

Technically Capable: Perform data discoveries to understand data formats, source systems, file sizes, etc. Additionally, may collect data delivered in various formats or from various systems (relational databases, FTP sites, file sharing sites (e.g. Box), external hard drives, etc.), load data in numerous different compressed and uncompressed formats (gzip, zip, tar, json, csv, Excel, etc.), perform data transformations using Hive and Impala to optimize data retrieval process and performance, create workflows for loading data on a scheduled basis using Oozie, shell scripting, sql, etc., basic working knowledge of database design and admin, and ability to create technical design documents.

Data Engineer - Practitioner of advanced data modeling and optimization of data and analytics solutions at scale. Expert in data management (any sources of data like POS, Consumer profile, ...) , data access (Big Data, traditional Data Marts, ...), advanced in programming (Python, Shell scripting, Java, and SQL), advanced data base modeling, familiarity with analytic algorithms and applications (like Machine learning) . Be a leader in P&G data capability building. Potential to expand into DevOps and Solution Management, focused on automation and scale up of solutions.

Technically Capable: As a P&G Data Engineer, you will “get your hands dirty”, leveraging data types and various data models to enable a range of analytic solutions. You should be adept at leveraging such technologies for managing and manipulating data, scaling data models and solutions to support the analytics for business insights.
As a P&G data wrangler or Engineer you will be a part of an award winning Business Intelligence and IT community that is Global in scope, and operates across all of P&G’s core disciplines to drive business value.

We are looking for leaders who have graduated with a BS or MS in Business/Management Information Systems and/or Computer Science/Engineering, Programming/Software Development or Operations Research or Statistics who have the following skills:
Data Wrangler & Engineer
  • Demonstrated mastery in applied big data data technologies such as:
  • SQL
  • Linux
  • Shell Scripting
  • Relational databases, ER models/diagrams
  • AWS and/or Azure framework
  • Understanding of Data Mining, Data Modeling, and Data Provisioning (acquisition, transformation and sharing).
  • Strong written and verbal communication skills to influence others
  • Demonstrated use of data and BI tools
  • Demonstrated ability to handle multiple priorities
Ability to work collaboratively across functions
Data Engineering
  • Have working knowledge in programming languages such as Python, Java and R and packaging/build tools such as sbt, Apache Maven or Ant
  • Demonstrated skills or are familiar with Big Data technologies (Hive, Impala) and NoSQL databases
  • Proficiency of data modeling and solution scaling.

We offer
- P&G-sized projects and access to world leading IT partners and technologies from day one
- Development of technical and business expertise in the Supply Chain area
- Work in international team with global responsibilities
- Coaching programs, trainings and relevant certifications
- Opportunity to change role every few years to be in the best place for you and best for P&G
- Flexible work arrangements (working less than full time, work from home)
- P&G Vibrant Living programs (sport cards, in-office fitness center)
- Competitive starting salary and benefits program (private health care, PG stock, saving plans).
- Regular salary increases and possible promotions - all in line with your results and performance.

Read Full DescriptionHide Full Description
Confirmed 12 hours ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles