Senior Data Engineer
Job Description
Procter & Gamble is hiring a Senior Data Engineer in Cincinnati, OH (onsite). This role combines technical ownership with data platform strategy, responsible AI integration, and the opportunity to influence architecture across teams. Compensation includes a competitive salary range of USD 132,200 - 165,300 per year, with P&G total rewards covering salary + bonus (if applicable) + benefits. The schedule is full time, and the position is designated for Experienced Professionals (JOB NUMBER: R000155516).
What you’ll do
- Lead the architectural design and implementation of complex, large-scale data solutions with a focus on scalability, performance, security, and cost-efficiency.
- Partner with senior business stakeholders and product owners to convert strategic objectives into architectural blueprints and technical roadmaps for data platforms.
- Drive data strategy and technology choices across multiple teams or domains, influencing architecture and engineering standards.
- Architect, build, and optimize resilient, high-performance, secure ETL/ELT pipelines on modern cloud platforms, including petabyte-scale processing and real-time requirements.
- Design advanced data integration patterns for complex enterprise systems, including third-party services, streaming sources, and APIs, ensuring high availability and reliability.
- Advance modern data processing approaches such as stream processing, graph databases, and data mesh principles.
- Serve as a primary technical mentor and subject matter expert, guiding engineers through complex challenges, architectural decisions, and career development.
- Lead code reviews, design discussions, and technical workshops to promote continuous improvement and engineering excellence.
- Evolve enterprise-wide data engineering standards and governance, including data quality frameworks, testing automation, CI/CD, security protocols, documentation standards, and data observability.
- Take end-to-end ownership for critical data solutions, spanning inception, implementation, deployment, monitoring, performance tuning, and incident response for production systems.
- Implement robust data quality, observability, and anomaly detection to protect data integrity and reliability.
- Prototype and integrate cutting-edge technologies, including Generative AI models and agentic systems, to improve developer productivity, automate tasks, and build novel data solutions.
- Lead thought leadership for responsible and ethical AI in data engineering, focusing on security, privacy, and bias mitigation.
- Drive continuous learning and knowledge sharing across the broader engineering organization.
- Apply modern development practices and tools, including advanced IDE usage, Git strategies (such as monorepos and gitflow), infrastructure as code (IaC), and CI/CD pipelines tailored for data platforms.
What you bring
- Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a closely related quantitative field.
- 5+ years of progressive data engineering experience with a strong track record delivering large-scale, complex platforms and pipelines.
- Proven experience leading technical projects, mentoring engineers, and influencing architectural decisions across teams.
- Expert proficiency in Python and SQL for advanced data manipulation, optimization, performance tuning, and analytics.
- Deep, hands-on experience with at least one major cloud platform (with Azure preferred, and/or GCP), including knowledge of relevant data services such as Azure Synapse, Databricks, Azure Data Factory, Event Hubs, and Azure Data Lake Storage or GCP BigQuery, Dataflow, Pub/Sub, and Cloud Storage.
- Extensive experience with distributed data processing technologies including Spark, PySpark, and Dask, including performance optimization and cluster/resource management at petabyte scale.
- Advanced knowledge of data modeling approaches (such as dimensional, Kimball, Inmon, data vault, and data mesh), plus warehousing and lake architecture principles to design flexible, optimized schemas.
- Ability to architect complex data integrations across APIs, message queues (including Kafka and Azure Event Hubs), and enterprise-grade data transfer protocols.
- Experience with modern engineering tools and production practices, including CI/CD, infrastructure as code using Terraform and ARM templates, and monitoring and management of data and machine learning pipelines.
- Practical experience leveraging Generative AI tools and agentic systems, with strong grounding in responsible AI principles around privacy, security, and ethical considerations.
- Exceptional communication and interpersonal skills, including the ability to explain complex topics to both technical and non-technical senior stakeholders.
- Ability to drive initiatives end-to-end with full architectural and operational responsibility for critical data assets.
- A strong curiosity and passion for continuous learning, staying current with emerging data technologies.
Technologies you’ll work with
- Python, SQL, Azure, GCP, ETL/ELT, ETL/ELT pipelines
- Azure Synapse, Databricks, Azure Data Factory, Event Hubs, Azure Data Lake Storage, BigQuery, Dataflow, Pub/Sub, Cloud Storage
- Spark, PySpark, Dask
- Data modeling: dimensional, Kimball, Inmon, data vault, data mesh
- Streaming and systems: Kafka, Graph databases, stream processing
- Engineering practices: CI/CD, Infrastructure as code (IaC), Terraform, ARM templates, Git, monorepos, gitflow
- AI: Generative AI, agentic systems, data observability
Preferred
- Deep expertise and certifications in Azure data services (example: Azure Databricks, Azure Synapse Analytics, Azure Data Factory, Azure Stream Analytics).
- Experience implementing data governance, master data management (MDM), and data lineage solutions.
- Hands-on experience with real-time streaming frameworks (example: Kafka, Spark Streaming, Flink).
- Strong software engineering fundamentals applied to data platforms (design patterns, clean code, microservices architecture).
- Experience with NoSQL databases (example: Cosmos DB, MongoDB) or graph databases (example: Neo4j).
- Professional or Expert-level certifications (example: Azure Data Engineer Expert, Databricks Certified Data Engineer Professional, Google Cloud Professional Data Engineer).
- Experience supporting MLOps initiatives and integrating data pipelines with ML models.
Job location: Cincinnati General Offices.