Data Engineer – BI & Data Pipelines (US Citizen)

CGS Federal; Chicago (IL); On-site; USD 110,000 - 150,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 is seeking a Data Engineer to support our growing Data Analytics and BI platform for federal customers. This role blends data engineering, ETL, and analytics to turn raw data into actionable insights, within an Agile team and a compliance-focused environment. You will design scalable pipelines, collaborate with engineers, PMs, and UX researchers, and contribute to CI/CD, APIs, and data governance.

U.S. citizenship and ability to obtain a Public Trust are required.

Qualifications

• US citizenship required.
• Ability to obtain Public Trust Clearance.
• 7+ years IT experience designing and managing large data sets.
• Experience building data pipelines from diverse sources.
• Proficient in ETL development and validation.
• Strong SQL and data manipulation skills (Python, R, SAS).
• Experience with big data tools and storage technologies.
• Familiar with CI/CD and Agile practices.

Responsibilities

• Complete development efforts across data pipeline to store, manage, store, and provision to data consumers.
• Collaborate in Agile/Scrum teams and follow best practices.
• Write code to ensure performance and reliability of data extraction and processing.
• Support continuous process automation for data ingest.
• Advocate lean-agile engineering principles (API-first design, simple design, CI, version control, automated testing).
• Work with program management and engineers to implement and document complex requirements.
• Foster customer service excellence, innovation, collaboration, and teamwork.
• Collaborate with cross-functional teams including UX researchers, product managers, engineers.

Skills

Data pipeline development

Agile/Scrum

ETL design & validation

CI/CD practices

Cross-functional collaboration

Data governance & quality

Tools

Python

SQL

PostgreSQL

SAS

R

Git

APIs

Job description

CGS Federal is seeking a Data Engineer to support our growing Data Analytics and BI platform for federal customers. This role blends data engineering, ETL, and analytics to turn raw data into actionable insights, within an Agile team and a compliance-focused environment. You will design scalable pipelines, collaborate with engineers, PMs, and UX researchers, and contribute to CI/CD, APIs, and data governance.

U.S. citizenship and ability to obtain a Public Trust are required.