Senior Data Engineer - Federal BI & Data Pipelines

CGS Federal (Contact Government Services); City of Albany (NY); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (FSA)

Paid Time Off & Holidays

Job summary

CGS is seeking a data engineer to support a growing Data Analytics and BI platform for federal customers. You will contribute across data pipelines, ETL, and data modeling to turn diverse data into actionable insights.

The role emphasizes agile collaboration, API-first development, and continuous improvement, with a strong focus on data quality and automation. Public Trust clearance and US citizenship required.

Qualifications

• 7+ years of IT experience including design, management, and solutioning of large data sets and models.
• Experience developing data pipelines from diverse sources and formats.
• Proficiency in ETL development, testing, and validation.
• Strong data manipulation skills using Python, SQL, R, SAS.

Responsibilities

• Complete development across data pipelines for storage, management, and provisioning to data consumers.
• Collaborate within an Agile/Scrum team to implement and document evolving requirements.
• Write code to ensure performance and reliability of data extraction and processing.
• Support automation for data ingest and CI/CD pipelines.

Skills

Agile/Scrum

API-first design

CI/CD

Data pipelines

Python

SQL

Data modeling

Data quality

Tools

PostgreSQL

Git

Tableau

PowerBI

Job description

CGS is seeking a data engineer to support a growing Data Analytics and BI platform for federal customers. You will contribute across data pipelines, ETL, and data modeling to turn diverse data into actionable insights.

The role emphasizes agile collaboration, API-first development, and continuous improvement, with a strong focus on data quality and automation. Public Trust clearance and US citizenship required.