DataJobs.io
← Back to all jobs

Job Description

Senior Data Engineering at Procter & Gamble in Cincinnati focuses on building scalable cloud data and analytics platforms that support real business outcomes. You will architect and deliver complex ETL/ELT pipelines, set engineering standards, and provide technical leadership, while advancing responsible AI practices across data engineering. Total rewards include salary + bonus (if applicable) + benefits.

This role is onsite in Cincinnati, OH and is full-time. The salary range is USD 132,200 to 165,300 per year. Job number: R000155516. Job segmentation: Experienced Professionals.

Responsibilities

  • Lead the architectural design and implementation of complex, large-scale data solutions, ensuring scalability, performance, security, and cost-efficiency.
  • Partner with senior business stakeholders and product owners to translate strategic objectives into architectural blueprints and technical roadmaps.
  • Influence data strategy, architecture, and technology choices across multiple teams or domains.
  • Architect, build, and optimize highly resilient, performant, and secure ETL/ELT pipelines on modern cloud platforms, supporting petabyte-scale data volumes and real-time processing.
  • Design advanced data integration patterns connecting enterprise systems, third-party services, streaming sources, and APIs to maintain high availability and reliability.
  • Drive adoption of advanced approaches such as stream processing, graph databases, and data mesh principles.
  • Mentor data engineers as a primary technical resource, guiding architectural decisions, complex technical issues, and career development.
  • Lead code reviews, design discussions, and technical workshops to promote continuous improvement.
  • Evolve enterprise engineering standards and governance for data, including data quality frameworks, testing automation, CI/CD, security protocols, documentation standards, and data observability.
  • Own critical data solutions end to end, from strategic inception and architecture to deployment, monitoring, performance tuning, and incident response.
  • Implement data quality frameworks, observability, and anomaly detection to protect data integrity and reliability.
  • Evaluate and prototype cutting-edge technologies, including advanced Generative AI models and agentic systems, to improve productivity and enable novel data solutions.
  • Act as a thought leader for responsible and ethical AI in data engineering, emphasizing security, privacy, and bias mitigation.
  • Lead initiatives for continuous learning and knowledge sharing across the engineering organization.
  • Use modern development tools and practices, including advanced IDE capabilities, Git strategies (e.g., monorepos, gitflow), infrastructure as code (IaC), and advanced CI/CD pipelines tailored for data platforms.

Requirements

  • Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a closely related quantitative field.
  • 5+ years of progressive data engineering experience, including designing and delivering large-scale, complex data platforms and pipelines.
  • Proven ability to lead technical projects, mentor engineers, and influence architectural decisions across multiple teams.
  • Expert proficiency in Python and SQL for complex data manipulation, optimization, performance tuning, and advanced analytics.
  • Hands-on expertise with at least one major modern cloud platform, with Azure preferred, including deep knowledge of relevant data services (Azure Synapse, Databricks, Data Factory, Event Hubs, Data Lake Storage, or the equivalent offerings on GCP such as BigQuery, Dataflow, Pub/Sub, Cloud Storage).
  • Deep distributed data processing experience including Spark, PySpark, and Dask, with performance optimization and cluster/resource allocation for petabyte-scale data.
  • Advanced data modeling expertise (dimensional, Kimball, Inmon, data vault, data mesh) and strong warehousing and lake architecture skills for designing optimized, flexible schemas.
  • Experience architecting complex integrations across systems including advanced API integrations, Kafka/Azure Event Hubs, and enterprise-grade data transfer protocols.
  • Experience with modern development practices including CI/CD, infrastructure as code (Terraform, ARM templates), and production deployment, monitoring, and management of data and machine learning pipelines.
  • Practical leadership in leveraging Generative AI tools and agentic systems, with understanding of responsible AI principles such as data privacy, security, and ethical considerations.
  • Exceptional communication and stakeholder management skills across technical and non-technical senior audiences.
  • Ability to drive initiatives from conception through completion with full architectural and operational responsibility for critical data assets.
  • Strong curiosity for continuous learning and adoption of emerging data technologies.

Technologies

Python, SQL, Azure, GCP, Azure Synapse, Databricks, Azure Data Factory, Event Hubs, Azure Data Lake Storage, BigQuery, Dataflow, Pub/Sub, Cloud Storage, ETL, ELT, Spark, PySpark, Dask, dimensional, Kimball, Inmon, data vault, data mesh, ETL/ELT pipelines, Kafka, CI/CD, Infrastructure as code (IaC), Terraform, ARM templates, Generative AI, agentic systems, Git, monorepos, gitflow, Graph databases, stream processing, data observability

Preferred

  • Deep expertise and certifications in Azure data services (e.g., Azure Databricks, Azure Synapse Analytics, Azure Data Factory, Azure Stream Analytics).
  • Experience with data governance, master data management (MDM), and data lineage solutions.
  • Hands-on experience with real-time streaming and processing frameworks such as Kafka, Spark Streaming, or Flink.
  • Strong software engineering fundamentals applied to data platforms (design patterns, clean code, microservices architecture).
  • Experience with NoSQL databases (e.g., Cosmos DB, MongoDB) or graph databases (e.g., Neo4j) for specialized use cases.
  • Professional or Expert-level certifications (e.g., 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.

Similar Jobs