Data Engineer with Public Trust Clearance

CGS Federal; Chicago (IL); On-site; USD 113,000 - 153,000; Full time

Job summary

CGS Federal is seeking a Data Engineer to support a growing Data Analytics and BI platform for federal customers. You will design and implement data pipelines, collaborate in an Agile/Scrum environment, and ensure reliable data extraction and processing across diverse data sources.

The role requires strong SQL, Python, ETL development, and experience with tools like PostgreSQL, Tableau, and PowerBI. A US citizenship and ability to obtain a Public Trust are required, with opportunities for

Qualifications

• Must be a US Citizen.
• Must be able to obtain a Public Trust Clearance.
• 7+ years of IT experience including experience in design, management, and solutioning of large, complex data sets and models.
• Experience with developing data pipelines from many sources from structured and unstructured data sets in a variety of formats.
• Proficiency in developing ETL processes, and performing test and validation steps.
• Proficiency to manipulate data (Python, R, SQL, SAS).
• Strong knowledge of big data analysis and storage tools and technologies.
• Strong understanding of the agile principles and ability to apply them.
• Strong understanding of the CI/CD pipelines and ability to apply them.
• Experience with relational database, such as, PostgreSQL.
• Work comfortably in version control systems, such as, Git Repositories.

Responsibilities

• Complete development efforts across data pipeline to store, manage, store, and provision to data consumers.
• Being an active and collaborating member of an Agile/Scrum team and following all Agile/Scrum best practices.
• Write code to ensure the performance and reliability of data extraction and processing.
• Support continuous process automation for data ingest.
• Achieve technical excellence by advocating for and adhering to lean-agile engineering principles and practices such as API-first design, simple design, continuous integration, version control, and automated testing.
• Work with program management and engineers to implement and document complex and evolving requirements.
• Help cultivate an environment that promotes customer service excellence, innovation, collaboration, and teamwork.
• Collaborate with others as part of a cross-functional team that includes user experience researchers and designers, product managers, engineers, and other functional specialists.

Skills

Python

SQL

R

SAS

PostgreSQL

Git

CI/CD

API development

Tableau

PowerBI

Tools

Tableau

PowerBI

Linux Shell

Job description

CGS Federal is seeking a Data Engineer to support a growing Data Analytics and BI platform for federal customers. You will design and implement data pipelines, collaborate in an Agile/Scrum environment, and ensure reliable data extraction and processing across diverse data sources.

The role requires strong SQL, Python, ETL development, and experience with tools like PostgreSQL, Tableau, and PowerBI. A US citizenship and ability to obtain a Public Trust are required, with opportunities for