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
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 www.pg.com for the latest news and information about P&G and its brands.
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
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
Ability to work collaboratively across functions
- 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.