Role Description & Responsibilities
Data Analytics
About P&G
P&G is a high-growth technology leader building scalable solutions for global users. Millions of companies and teams rely on their infrastructure and services to execute high-value workflows, analyze massive datasets, and scale modern operations.
CadetX Candidate Advantage: As an applicant for this Data Analytics role, you are evaluated on practical proficiency with real-world query execution, data pipelines, and clear stakeholder communication.
CadetX Role Brief & Company Specifications
Role Mission & Impact
As a Site Data Activation Leader at P&G, you will join an innovative team focused on building scalable, data-driven solutions. Analyze commercial data streams, uncover operational trends, and deliver executive dashboards that empower leadership to make data-driven decisions.
This opening provides direct commercial exposure, structured technical mentorship, and the opportunity to contribute to production workflows across P&G's core business domains.
Key Responsibilities & Day-to-Day Scope
- ✓ Write optimized SQL queries against relational and data lake systems to extract key business metrics.
- ✓ Build and maintain interactive dashboards in Power BI, Tableau, or Looker for departmental stakeholders.
- ✓ Perform exploratory data analysis and root cause evaluations on metric anomalies using Python (pandas, numpy).
- ✓ Collaborate with product and operations teams to establish key performance indicators (KPIs) and automated reporting suites.
- ✓ Present quantitative findings and commercial insights to both technical and executive stakeholders.
Official Qualifications & Technical Requirements
- • Pursuing or completed a Bachelor's or Master's degree in Data Analytics, Computer Science, Economics, Statistics, Mathematics, or a related quantitative discipline.
- • Demonstrated proficiency in SQL (joins, window functions, aggregations) and relational database concepts.
- • Hands-on experience with Python for data manipulation (pandas, numpy) or modern BI visualization platforms (Power BI, Tableau).
- • Solid grasp of foundational statistics, data visualization principles, and business metric interpretation.
- • Strong problem-solving curiosity, attention to detail, and effective written and verbal communication skills.
Preferred Skills & Technology Stack
- + Experience working with cloud data warehouses (Snowflake, BigQuery, or Amazon Redshift).
- + Familiarity with Git version control and collaborative code review workflows.
- + Demonstrated portfolio or capstone projects exhibiting practical end-to-end analytics problem solving.
Tech Stack & Tools in this role
Expected technical competencies for Day 1 productivity:
★ Life & Culture at P&G
Verified EmployerP&G champions rigorous analytical discipline, continuous learning, and low-ego teamwork. Team members enjoy flexible hybrid allowances, learning stipends, and structured mentorship to fast-track career mobility.