Data Engineer II

Iowa Ag

Johnston (IA)

Hybrid

USD 90,000 - 120,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health benefits
Paid time off
Parental leave
Retirement plan

Job summary

Vylor in Des Moines, IA seeks a Data Engineer II to design and maintain Lakehouse data pipelines, APIs, and data products supporting seed models, biotech research assets, dashboards, and analytics.

You will build scalable ETL/ELT pipelines using Python, SQL, dbt, Trino, and shell scripting to process diverse data from labs, geographic datasets, drones, and IoT devices. The role includes modernizing legacy data apps and implementing quality controls.

Qualifications

  • 5+ years in data engineering or related field.
  • Experience designing scalable data pipelines and data products.
  • Strong SQL and Python programming skills.

Responsibilities

  • Design, develop, and maintain Lakehouse data pipelines, APIs, and data products supporting seed models, biotech research assets, dashboards, and analytics.
  • Develop scalable ETL/ELT pipelines using Python, SQL, dbt, Trino, and shell scripting to process large data from multiple sources.
  • Create and maintain Bronze/Silver/Gold data layers by integrating Exasol, ClickHouse, MSSQL Server and other sources.
  • Design Lakehouse datasets and pipelines for seed, biotech, pathology, and disease analytics.
  • Enhance dbt models and complex Trino queries to improve performance and maintainability.
  • Modernize legacy data apps by documenting rules, migrating ETL logic, and deploying curated data products.
  • Develop reusable logging, testing, monitoring, and data-quality frameworks; troubleshoot integration issues.

Skills

Python
SQL
dbt
Trino
Shell scripting
Linux
Git
Kubernetes
Docker
ETL/ELT design

Education

Master’s degree in Computer Science, Statistics, or related field

Tools

Exasol
ClickHouse
MSSQL Server
Kubernetes
Docker

Job description

### Job Details#### Job Title:Data Engineer II #### Location:Des Moines, IA, Midwest United States,USA #### Company:Vylor #### Industry Sector:Agribusiness #### Industry Type:Plant & Soil Sciences, Seed & Biotechnology #### Career Type:Engineering #### Job Type:Full Time #### Minimum Years Experience Required:N/A #### Salary:Competitive ### Get Job Alerts**Career Type:** Engineering **Country:** USAI agree to receive alerts from AgCareers.com and to the Terms of Service.# Data Engineer IIBack to search resultsApply to this positionFollow CompanyMore Jobs from VylorSend to Friend**Join Vylor—Powering the Future of Agriculture**? At Vylor, we're advancing agriculture through breakthrough science—combining elite germplasm, cutting-edge biotech, and next-generation expertise in gene editing and molecular breeding. Our portfolio includes trusted industry brands like Pioneer , Brevant , and Hoegemeyer , delivering performance farmers rely on.? Join us to help scale innovation globally and shape what's next in crop science.Join Vylor—Powering the Future of Agriculture.At Vylor, we're advancing agriculture through breakthrough science—combining elite germplasm, cutting-edge biotech, and next-generation expertise in gene editing and molecular breeding. Our portfolio includes trusted industry brands like Pioneer , Brevant , and Hoegemeyer , delivering performance farmers rely on.Join us to help scale innovation globally and shape what's next in crop science.Pioneer Hi-Bred International, Inc. a subsidiary of Vylor Inc., seeks a full-time Engineer II based in Johnston, IA. The Engineer II partners with Analytics, Data Science, Research & Development (R&D), Data Engineering, and cross-functional teams to design and deliver scalable data solutions supporting Corteva's Seeds and Biotech domains and enterprise data platform. Specific duties include: (1) Design, develop, and maintain Lakehouse data pipelines, APIs, and data products supporting seed models, biotech research assets, enterprise applications, dashboards, and analytics; (2) Develop scalable ETL/ELT pipelines using Python, SQL, dbt, Trino, and shell scripting to process and integrate large-scale structured and unstructured agricultural data from enterprise systems, laboratory platforms, geographic datasets, drones, satellites, and IoT devices; (3) Develop and maintain Bronze, Silver, and Gold Layer data assets by integrating data from Exasol, ClickHouse, MSSQL Server, and other enterprise sources and applying transformation, validation, reconciliation, and quality-control processes; (4) Design Lakehouse datasets and transformation pipelines supporting seed, biotech, pathology, and disease analytics, including the integration of laboratory, geographic, and historical research data; (5) Develop and optimize incremental and full-refresh dbt models and complex Trino SQL queries to improve the performance, scalability, and maintainability of Seeds and Biotech data products; (6) Modernize legacy data applications by documenting business rules and source-to-target mappings, migrating ETL logic from legacy and Exasol-based environments to Trino and Lakehouse architectures, and deploying curated datasets to ClickHouse and Gold Layer data products; (7) Develop and enhance PRISM and FRIP data integrations by implementing Trino connectors and end-to-end comparison pipelines with reusable validation and reconciliation logic to ensure consistency between PRISM, FRIP, Lakehouse, Exasol, and downstream application datasets; and (8) Develop reusable frameworks for logging, error handling, scheduling, automated testing, monitoring, deployment, and data-quality validation; troubleshoot application and pipeline integration issues; and create analytics-ready datasets supporting statistical analysis, predictive modeling, regression, classification, clustering, dashboards, and business-intelligence reporting. Utilize Python, SQL, Linux, shell scripting, Git, dbt, Trino, Exasol, ClickHouse, MSSQL Server, Kubernetes, and, Docker. Position includes a telecommute benefit within commuting distance to Johnston, IA Pioneer Hi-Bred/Vylor office, as directed.This position requires a Master's degree or equivalent in Computer Science, Statistics, or a related field and 2 years related experience. Must also have 24 months of experience with each of the following: 1) Designing and developing scalable ETL/ELT pipelines using Python, SQL, and shell scripting to extract, transform, validate, reconcile, and integrate large-volume structured, semi-structured, and unstructured data used by enterprise R&D applications, analytical models, dashboards, and reporting systems. 2) Developing ETL design mappings, source-to-target transformation rules, data-reconciliation processes, data-quality controls, and complex SQL transformations to ensure data accuracy and consistency across source and target platforms. 3) Developing and optimizing complex Trino SQL queries and integrations among Lakehouse, Exasol, ClickHouse, MSSQL Server, and other database platforms to deliver curated datasets for analytics-ready datasets supporting R&D models, scienti?c analysis, enterprise applications such as phenomic pillar, dashboards, and reporting. 4) Developing reusable Python- and Linux shell-based pipeline reliability and observability frameworks for job scheduling, structured logging, exception handling, automated testing, monitoring, data-quality validation, cross-platform reconciliation, and application integration; and using version-control, containerization, and automated-deployment tools to deliver production data products. 5) Analyzing and modernizing legacy data applications by documenting business rules and data mappings, migrating ETL logic to cloud-based or Lakehouse architecture, deploying curated data products, and using Git and Docker for source control, automated deployment, and containerization. Will accept experience gained before, during or after Master's program. Employer will accept experience gained concurrently. Position includes a telecommute benefit within commuting distance to Johnston, IA Pioneer Hi-Bred/Vylor office, as directed. Please apply online at https://apply.vylor.com/careers/.**Benefits - How We'll Support You:*** Numerous development opportunities offered to build your skills* Be part of a company with a higher purpose and contribute to making the world a better place* Health benefits for you and your family on your first day of employment* Four weeks of paid time off and two weeks of well-being pay per year, plus paid holidays* Excellent parental leave which includes a minimum of 16 weeks for mother and father* Future planning with our competitive retirement savings plan and tuition reimbursement program* Learn more about our total rewards package here - Vylor Benefits* Check out life at Vylor! https://www.linkedin.com/company/vylorgenetics/Are you a good match? Apply today! We seek applicants from all backgrounds to ensure we get the best, most creative talent on our team. ### Vylor is an equal opportunity employer. We are committed to embracing our differences to enrich lives, advance innovation, and boost company performance. Qualified applicants will be considered without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, military or veteran status, pregnancy related conditions (including pregnancy, childbirth, or related medical conditions), disability or any other protected status in accordance with federal, state, or local laws.]]>To apply please click on APPLY TO THIS POSITIONApply to this positionSave this jobJob Post Date: 11/11/26
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer II
Data Engineer II

Vylor • Johnston (IA)

Hybrid
USD 110,000 - 150,000
Development opportunities
Higher purpose
Health benefits
+4
Software and Data Pipeline Strategy Lead
Software and Data Pipeline Strategy Lead

Iowa Ag • Johnston (IA)

On-site
USD 120,000 - 180,000
Health benefits
Paid time off
Parental leave
+1
Data Engineer II
Data Engineer II

Vylor • Des Moines (IA)

On-site
USD 100,000 - 140,000
Health benefits
Paid time off
Parental leave
+4
Genomics Data Analyst
Genomics Data Analyst

Iowa Ag • Des Moines (IA)

On-site
USD 85,000 - 120,000
Health benefits
Paid time off
Parental leave
+2
Software and Data Pipeline Strategy Lead
Software and Data Pipeline Strategy Lead

Vylor • Des Moines (IA)

On-site
USD 140,000 - 190,000
Health benefits
Paid time off
Parental leave
+2
Software and Data Pipeline Strategy Lead
Software and Data Pipeline Strategy Lead

Vylor Inc. • Johnston (IA)

On-site
USD 150,000 - 190,000
Health benefits
Paid time off
Parental leave
+1
Area Team Lead
Area Team Lead

Illinois Ag • Illinois

On-site
USD 52,000 - 73,000
Health benefits
Paid time off
Parental leave
+2
Production Associate
Production Associate

Illinois Ag • Illinois

On-site
USD 41,000 - 57,000
Health benefits on day one
Paid time off
Paid holidays
+4
Manufacturing Technician
Manufacturing Technician

Illinois Ag • Illinois

On-site
USD 41,000 - 57,000
Health benefits
Paid time off
Parental leave
Production Technician
Production Technician

Iowa Ag • Iowa

On-site
USD 22,000 - 33,000
Health benefits
4 weeks PTO
Parental leave
+1