Data Engineer

Chenega Services & Federal Solutions•Town of Gates, NY

4d•$95,000 - $105,000•Remote

About The Position

Chenega Services & Federal Solutions, LLC is hiring a Data Engineer to provide specialized support building, optimizing, and maintaining cloud-based data pipelines, platforms, and data stores for analytics across large, diverse datasets. The position is contingent on contract award, and details may change based on the final award. The Data Engineer will design scalable ETL/ELT workflows and data storage architectures, ensure reliable ingestion from structured and unstructured sources, and transform raw data into analysis-ready formats. The role includes backend SQL/NoSQL testing and data-quality validation throughout the pipeline lifecycle. The engineer will collaborate with analysts, product teams, developers, and other stakeholders to define technical specifications and deliver end-to-end solutions for reporting, modeling, and visualization. The position is listed as remote within the United States. Final salary depends on skill set, qualifications, and approved funding; the estimated range is $95,000 to $105,000 per year. The employer describes a benefits program, with some offerings dependent on role, schedule, or location.

Requirements

At least 3 years of experience in data warehouse development.
At least 3 years of experience analyzing aggregated data from multiple sources in cloud-based environments.
At least 2 years of experience developing and maintaining scalable data stores that supply big data in forms needed for business analysis.
Experience with SQL and Python for retrieving, parsing, and processing structured and unstructured data.
Experience developing scalable ETL or ELT workflows for reporting and analytics using cloud-based technologies.
Experience using Cloudera or Hadoop technologies to ingest, transform, and process data.
Experience leveraging generative AI coding tools to assist in development.
Ability to perform backend SQL and NoSQL database testing, including post-deployment and data validation testing.
Ability to obtain and maintain a Public Trust or Suitability/Fitness determination based on client requirements.
Bachelor's degree.

Nice To Haves

Experience creating solutions in a collaborative, cross-functional team environment.
Experience with AWS Glue, AWS Athena, and Postgres.
Experience with distributed data and computing tools such as Spark, Databricks, Hive, AWS EMR, or Kafka.
Experience working on real-time data and streaming applications.
Experience implementing NoSQL with MongoDB or Cassandra.
Experience with data warehousing, including AWS Redshift, MySQL, or Snowflake.
Experience with UNIX and Linux, including basic commands and shell scripting.
Experience with Agile engineering practices.

Responsibilities

Design, develop, and maintain scalable ETL/ELT pipelines to ingest, transform, and deliver structured and unstructured data from multiple cloud-based sources.
Build and optimize data storage solutions, including data warehouses, data lakes, or lakehouses, for large-scale analytics, reporting, and business intelligence.
Perform backend SQL and NoSQL testing, including data validation, post-deployment checks, and troubleshooting ingestion or schema issues.
Collaborate with analysts, engineers, and stakeholders to translate requirements into technical data models, workflows, and pipeline specifications.
Develop scripts and automation to convert diverse data types into usable formats, while scaling, monitoring, and operating cloud-based data platforms.

Benefits

Paid time off, including vacation accrual of 5.67 hours per pay period (136 hours annually).
11 paid holidays.
California residents receive an additional 24 hours of sick leave per year.
Medical, dental, vision, and prescription coverage.
Employee Assistance Program.
Short- and long-term disability insurance.
Life and AD&D insurance.
Flexible Spending Account, Health Savings Account, Health Reimbursement Account, and Dependent Care Spending Account.
Commuter benefits.
401(k) / 401(a) retirement plans.
Hospital indemnity, critical illness, accident, pet, and legal insurance.
Identity theft protection.