> Markdown version of [/jobs/ext/4707607-data-engineer-ii](https://www.wearedevelopers.com/jobs/ext/4707607-data-engineer-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Engineer II

- **Company:** Vylor, Inc.
- **Location:** Johnston, IA, United States (Remote available)
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Data Analysis, Application Frameworks, Application Integration Architecture, Automation of Tests, Cloud Computing, Cluster Analysis, Databases, Data Architecture, Information Engineering, Data Integration, Extract Transform Load (ETL), Linux, Job Scheduling, Python (Programming Language), Unix Shell, Microsoft SQL Server, Operational Databases, Prism (Software), Shell Script, SQL Databases, Systems Integration, Unstructured Data, Enterprise Data Management, Data Logging, Enterprise Software Applications, Git, Containerization, Kubernetes, Information Technology, Deployment Automation, Enterprise Integration, Vertica, Software Version Control, Data Pipelines, Docker
- **Published:** November 13, 2026
- **Apply:** https://www.techcareers.com/job.asp?id=3517349778&tx=YT1818THD&pt=1&aff=0B19D771-A501-4A5E-8338-2A822B784D54&utm_source=Job%20Feed&utm_medium=textkernel&utm_campaign=DE&utm_term=0B19D771-A501-4A5E-8338-2A822B784D54

## About the Role

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.

## Description

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.