Data Engineer, Federal BI & Data Pipelines

CGS Federal; Detroit (MI); On-site; USD 100,000 - 140,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 passionate Data Engineer to support a growing Data Analytics and Business Intelligence platform focused on empowering federal customers with data-driven insights. The role involves building scalable data pipelines, optimizing data flows, and delivering actionable information in an Agile environment.

Ideal candidates have 7+ years of IT experience, strong ETL, Python, SQL, and big data skills, and can work with PostgreSQL, Tableau/PowerBI.

Qualifications

• 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 in various formats (structured and unstructured).
• 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 agile principles and CI/CD pipelines.
• Experience with PostgreSQL and Git repositories.

Responsibilities

• Complete development efforts across data pipeline to store, manage, store, and provision to data consumers.
• Collaborate in an Agile/Scrum team 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 and practices such as API-first design, simple design, CI, version control, and automated testing.
• Work with program management and engineers to implement complex evolving requirements.
• Collaborate with cross-functional teams including UX researchers, product managers, engineers, and others.

Skills

ETL development

Python

SQL

R

SAS

Big data

CI/CD

Git

Agile/Scrum

Tools

PostgreSQL

Tableau

PowerBI

Linux shell scripting

Job description

CGS Federal is seeking a passionate Data Engineer to support a growing Data Analytics and Business Intelligence platform focused on empowering federal customers with data-driven insights. The role involves building scalable data pipelines, optimizing data flows, and delivering actionable information in an Agile environment.

Ideal candidates have 7+ years of IT experience, strong ETL, Python, SQL, and big data skills, and can work with PostgreSQL, Tableau/PowerBI.