Data Engineer — Federal BI & Data Pipelines

CGS Federal; City of Albany (NY); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (Health, Dep

Paid Time Off and Holidays

Job summary

CGS Federal, based in Albany, NY, seeks a Data Engineer to support a growing Data Analytics and BI platform for federal customers. You will design and implement data pipelines, ETL processes, and data models while collaborating in an Agile environment to turn complex data into actionable insights.

The role emphasizes lean-agile engineering practices, API-first design, CI/CD, and strong cross-functional teamwork with researchers, product managers, and engineers to deliver robust data solutions.

Qualifications

• 7+ years IT experience with large, complex data sets and models.
• Experience building data pipelines from diverse sources.
• Proficiency in ETL development and data validation.
• Fluent data manipulation with Python/SQL/SAS.

Responsibilities

• Develop and maintain data pipelines to store, manage, and provision data to consumers.
• Collaborate in an Agile/Scrum team and follow best practices.
• Write code to ensure performance and reliability of data processing.
• Support automation for data ingestion.
• Translate requirements into data strategies and analytic solutions.
• Work with cross-functional teams including researchers, product managers, and engineers.

Skills

Python

SQL

R

SAS

Agile/Scrum

CI/CD

Tools

PostgreSQL

Git

Tableau

PowerBI

Linux shell scripting

Job description

CGS Federal, based in Albany, NY, seeks a Data Engineer to support a growing Data Analytics and BI platform for federal customers. You will design and implement data pipelines, ETL processes, and data models while collaborating in an Agile environment to turn complex data into actionable insights.

The role emphasizes lean-agile engineering practices, API-first design, CI/CD, and strong cross-functional teamwork with researchers, product managers, and engineers to deliver robust data solutions.