Database Engineer

Clover Sonoma; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Clover Sonoma is seeking a Database Engineer to design, build, and optimize enterprise data platforms bridging SAP S/4HANA (RISE) and AWS Data Lake. You will implement a Medallion Architecture (Bronze/Silver/Gold) and create curated data models for Power BI-driven insights.

Responsibilities include securing data, ensuring reliability, and collaborating with cross-functional teams on master data governance and data migrations. 5+ years in database engineering with SAP/AWS experience desired.

Qualifications

• Bachelor's degree or equivalent in CS/IS/engineering or data field.
• 5+ years in database engineering or related role for business-critical systems.
• Hands-on SAP S/4HANA, SAP HANA, and RISE with SAP experience.
• Experience building AWS data lake with S3 and data services (Glue, Lake Formation, Athena/Redshift).
• Advanced SQL skills, data modeling, performance tuning, and production troubleshooting.
• Experience designing/maintaining ETL/ELT integrations and APIs.

Responsibilities

• Design, implement, administer, monitor, and optimize databases for SAP and business apps.
• Build secure data pipelines from SAP S/4HANA in RISE to SAP HANA Cloud and AWS.
• Extract SAP data via CDS Views, OData, ODP/ODQ, SLT, SDI/SDA, APIs, or SAP Datasphere.
• Design SAP HANA Cloud schemas, calculation views, SQLScript, and data models.
• Create Bronze/Silver/Gold data layers in AWS Data Lake.
• Develop data models for Power BI reports and semantic models.
• Ensure data governance, backup, DR, retention, and security practices.

Skills

Advanced SQL

Data modeling

Relational DB design

Production troubleshooting

Education

Bachelor's degree in computer science, information systems, engineering, data management, or related field

Tools

SAP S/4HANA

SAP HANA

RISE with SAP

AWS S3

AWS Glue

Amazon Athena

Amazon Redshift

Job description

As a purpose-driven, certified B corporation, Clover is leading the way for conscious businesses by demonstrating care for all stakeholders and moving the world forward. We are committed to lowering our environmental impact and meeting our sustainability targets, by providing kids and adults with healthy, nutritious, and delicious products that are made with care for animals, people, and the planet.

About the Role

The Database Engineer designs, builds, administers, and improves the data platforms that support Clover Sonoma's dairy manufacturing, warehousing, distribution, finance, sales, and reporting operations. The role is responsible to design, build and support enterprise data pipelines from SAP S/4HANA in SAP RISE through SAP HANA Cloud and into an AWS Data Lake. This role will implement a Medallion Architecture-Bronze, Silver, and Gold layers-to deliver governed, reliable, and Power BI-ready datasets.

Essential Duties and Responsibilities

• Design, implement, administer, monitor, and optimize relational databases and related data services supporting SAP and other business-critical applications.
• Design and build secure data pipelines from SAP S/4HANA in RISE to SAP HANA Cloud and AWS.
• Extract SAP data using approved technologies such as CDS Views, OData, ODP/ODQ, SLT, SDI/SDA, APIs, or SAP Datasphere.
• Design SAP HANA Cloud schemas, calculation views, SQLScript procedures, data models, and replication processes.
• Implement Bronze, Silver, and Gold data layers within the AWS Data Lake.
• Build curated data models for Power BI reports, dashboards, and semantic models.
• Develop and maintain reliable data pipelines, interfaces, and integrations between SAP and business systems such as warehouse, manufacturing, quality, payroll, CRM, sales, and business intelligence platforms.
• Monitor database health, availability, job execution, storage, replication, and query performance; identify root causes and implement sustainable corrective actions.
• Establish and maintain database backup, recovery, high-availability, disaster-recovery, retention, and archival practices consistent with business continuity requirements.
• Apply role-based access, encryption, logging, change control, and other security practices to protect company, customer, employee, supplier, and operational data.
• Partner with business and functional teams to improve the accuracy, completeness, consistency, and governance of item, material, vendor, customer, pricing, inventory, and other master data.
• Support data migration, cleansing, validation, reconciliation, and cutover activities for SAP enhancements, acquisitions, system implementations, and process changes.
• Create and maintain technical documentation, including database architecture, data flows, interfaces, data dictionaries, operating procedures, recovery procedures, and support runbooks.
• Provide responsive production support for database and integration incidents that may affect plant operations, warehousing, order fulfillment, transportation, financial processing, or customer service, including occasional after-hours support for critical events.
• Evaluate database technologies, tools, and automation opportunities and recommend improvements that increase reliability, scalability, security, data quality, and team efficiency.
• Follow company cybersecurity, data privacy, food safety, quality, change-management, and record-retention requirements while performing work in office, warehouse, and manufacturing environments.
• Perform other duties and participate in cross-functional projects as assigned.

Required Qualifications

• Bachelor's degree in computer science, information systems, engineering, data management, or a related field, or an equivalent combination of education and relevant experience.
• Five or more years of experience in database engineering, database administration, data engineering, or a closely related role supporting business-critical systems.
• Hands‑on production experience supporting SAP S/4HANA, SAP HANA, and RISE with SAP environments.
• Hands‑on experience designing, building, or administering an AWS cloud data lake, including practical experience with Amazon S3 and relevant AWS data services such as AWS Glue, AWS Lake Formation, Amazon Athena, Amazon Redshift, or comparable services.
• Advanced SQL skills and experience with relational database design, performance tuning, indexing, query optimization, backup and recovery, and production troubleshooting.
• Experience building or supporting integrations, ETL or ELT processes, APIs, batch jobs, and data exchanges across enterprise appl