Overview
Client is seeking a Software Engineer I focused on data pipelines, ETL/ELT workflows, and workflow orchestration. This role supports application functionality, analytics, reporting, and scientific workflows within a cross-functional Agile team. The ideal candidate has hands-on data engineering experience, strong SQL skills, and experience working with relational databases and pipeline orchestration tools.
Core Responsibilities
Embed within a cross-functional Agile team and participate in sprint planning, stand-ups, backlog refinement, and technical discussions.
Design, build, troubleshoot, and maintain ETL/ELT workflows supporting applications, analytics, reporting, and scientific workflows.
Develop and manage data pipelines using Apache Airflow for orchestration, scheduling, monitoring, and recovery.
Work with software developers, scientists, and engineers to understand data sources, workflow requirements, and downstream data needs.
Extract, transform, validate, and load data across systems, including relational databases such as PostgreSQL and Oracle.
Write, optimize, and maintain complex SQL queries, scripts, and transformation logic.
Troubleshoot data quality issues, ETL failures, pipeline bottlenecks, and schema inconsistencies.
Use database tools such as DBeaver for query development, data exploration, validation, and troubleshooting.
Collaborate with engineering teams to support data pipeline integration with applications, APIs, and downstream consumers.
Assist with schema evolution, data modeling, migration planning, and data consistency across systems.
Document pipeline logic, dependencies, transformation rules, and operational procedures.
Support improvements to data engineering standards, observability, testing practices, and operational reliability.
Essential Qualifications, Skills, and Technologies
Bachelor's degree in computer science, information systems, data engineering, or related field, or equivalent practical experience.
2+ years of professional experience in data engineering, ETL development, or related hands-on work.
Experience designing, building, and troubleshooting ETL/ELT pipelines.
Hands-on experience with workflow orchestration tools, preferably Apache Airflow.
Strong SQL development and optimization skills.
Experience working with relational databases, especially PostgreSQL and Oracle.
Experience developing data transformations, validation steps, and pipeline logic across multiple systems.
Experience using database tools such as DBeaver or similar.
Understanding of data modeling, schema design, data integrity, and performance tuning.
Experience troubleshooting pipeline failures, performance issues, and inconsistent or incomplete datasets.
Familiarity with scripting or programming for pipeline development and automation; Python experience is strongly preferred.
Understanding of version control and collaborative development workflows.
Strong analytical, problem-solving, communication, and documentation skills.
Must be eligible to work in the U.S. for a minimum of 18 months.
Preferred Skills or Experience
Experience or interest in scientific software, materials science, research environments, or technically complex domains.
Experience working directly with scientists, engineers, analysts, developers, and product stakeholders.
Familiarity with DuckDB or interest in evaluating emerging data tools and technologies.
Experience improving data workflows, tooling, performance, observability, and operational stability.
Work Details
Location: Corning, NY
Work arrangement: 100% onsite
Schedule: 40 hours per week; may require weekends, holidays, or longer days to support projects
Duration: 12 months
Travel: Limited to no travel required
No on-call requirements
Nesco Resource offers a comprehensive benefits package for our associates, which includes a MEC (Minimum Essential Coverage) plan that encompasses Medical, Vision, Dental, 401K, and EAP (Employee Assistance Program) services.Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
