Senior Data Engineer - Government BI & Pipelines

CGS Federal (Contact Government Services); Philadelphia (Philadelphia County); 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 a growing Data Analytics and BI platform for federal clients. You will design and implement data pipelines, ensure data quality, and collaborate with agile teams to deliver reliable ETL solutions.

The ideal candidate has 7+ years IT experience, hands-on experience with Python, SQL, and big data tools, and the ability to translate complex requirements into scalable data architectures. This role is full-time and on-site in Philadelphia.

Qualifications

• Must be a US Citizen.
• Must be able to obtain a Public Trust Clearance.
• 7+ years of IT experience including 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.

Skills

ETL development

Python

SQL

Big data tools

CI/CD pipelines

API development

Git

Tableau

PowerBI

Linux shell scripting

Tools

PostgreSQL

Git Repositories

Tableau

PowerBI

Linux

Job description

CGS Federal is seeking a Data Engineer to support a growing Data Analytics and BI platform for federal clients. You will design and implement data pipelines, ensure data quality, and collaborate with agile teams to deliver reliable ETL solutions.

The ideal candidate has 7+ years IT experience, hands-on experience with Python, SQL, and big data tools, and the ability to translate complex requirements into scalable data architectures. This role is full-time and on-site in Philadelphia.