Data Engineer

Data Engineer

CGI Federal is seeking a Data Engineer to support a federal agency in modernizing its fraud control strategy. This senior technical role is part of a high impact team responsible for redesigning and optimizing fraud detection pipelines and workflows that safeguard federal benefits and adapt to evolving data sources. You will lead the design and implementation of scalable, secure, and flexible data engineering solutions while collaborating closely with data scientists, analysts, and federal stakeholders to ensure the iClaim model infrastructure is robust, adaptable, and future ready. This position is on site 5 days a week in Woodlawn, MD.

Your future duties and responsibilities:

• Engineer, transform, and manage large datasets from diverse sources while ensuring data integrity, reliability, and consistency.
• Design, optimize, and maintain complex SQL queries for ETL operations across distributed databases.
• Develop and automate ETL pipelines using platforms such as Apache Airflow, ensuring high availability and resilience.
• Write modular, well documented Python code for data processing, feature engineering, and workflow orchestration.
• Implement comprehensive data validation, cleansing, and quality checks throughout all pipeline stages.
• Apply software engineering best practices including version control, code reviews, logging, monitoring, and error handling.
• Collaborate with data scientists to optimize model pipelines for performance, maintainability, and scalability.
• Prepare and maintain technical documentation such as data dictionaries, model specs, workflow guides, and architectural artifacts.
• Support Agile development cycles and contribute to the documentation and refinement of model workflows and data processes.
• Participate in deployment activities and conduct rigorous testing, validation, and post implementation reviews.

Required qualifications to be successful in this role:

• Ability to obtain and maintain an Agency Public Trust clearance.
• Bachelor's degree and 7+ years of relevant experience.
• Expertise in SQL and ETL workflows with experience in distributed database technologies (Redshift, Snowflake, BigQuery).
• Experience with Apache Airflow or similar orchestration frameworks.
• Strong Python development skills, especially with pandas, NumPy, and automation libraries.
• Hands on experience building data quality checks and validation frameworks.
• Familiarity with GitHub, Bitbucket, or similar version control tools.
• Knowledge of logging, monitoring, and error handling.
• Experience supporting federal agencies, particularly in fraud or anomaly detection.
• Familiarity with cloud platforms (AWS, Azure, GCP) and containerization tools (Docker, Kubernetes).
• Exposure to CI/CD, DevOps practices, and infrastructure as code.
• Knowledge of data governance, PII handling, and federal security standards.
• Experience with model documentation, feature tracking, and model lifecycle management.

What you can expect from us:

Together, as owners, let's turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because… You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction. Your work creates value. You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise. You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons. Come join our team—one of the largest IT and business consulting services firms in the world.