Lead Data Engineer

CGI Group, Inc. offers a hybrid Lead Data Engineer role in Fairfax, VA with a competitive salary range of USD 113,400 to 223,200 per year. This position centers on designing and maintaining enterprise-grade data pipelines on Google Cloud Platform, guiding a data engineering team, and ensuring data quality, governance, and both real-time and batch processing capabilities.

Life at CGI emphasizes ownership, teamwork, respect, and belonging. You can contribute from day one as an owner, collaborate with a broad range of stakeholders, and benefit from a global IT and business consulting environment that supports growth, skill development, and opportunities to shape the company’s direction. CGI also offers competitive compensation and benefits, including comprehensive insurance options, 401(k) with matching contributions and a share purchase plan, paid time off, parental leave, tuition assistance, and wellness programs.

Responsibilities

• Lead the design, development, and maintenance of robust data pipelines using Dataflow and Cloud Run Functions to extract data from multiple sources, transform it into the required formats, and load it into landing zones such as Pub/Sub, Google Storage, or AlloyDB for PostgreSQL.
• Collaborate with FAA customers, the chief architect, senior engineers, information analysts, and business and technology stakeholders to deploy enterprise-grade platforms that enable data-driven solutions.
• Develop and manage ETL processes with GCP Dataflow using flex templates in Java to support transformations into XML and JSON documents, enriching them for downstream consumers.
• Implement and manage advanced data models including relational and non-relational databases, master data management, Data Plex, and data governance.
• Integrate data from legacy sources such as databases, data warehouses, APIs, and external systems using Dataflow and Cloud Run Functions.
• Ensure data consistency and integrity through validation and cleaning, and oversee data quality across the data integrations.
• Transform raw data into usable formats by applying cleansing, aggregation, filtering, and enrichment using Dataflow, Cloud Run Functions, and other GCP services.
• Design and optimize data pipelines and processing workflows for performance, scalability, and efficiency.
• Monitor and tune data systems, identify performance bottlenecks, and implement improvements such as indexing strategies to enhance query performance.
• Incorporate data quality checks and validations within pipelines to ensure accuracy and completeness of data.
• Optimize and administer data environments and related GCP services to maintain high performance and reliability.
• Collaborate with cross-functional teams to deliver data products and support data-driven initiatives.

Requirements

• Minimum of 12 years of data engineering experience, with at least 2 years hands-on experience with Google Cloud-based services.
• At least 8 years of work in data solutions design, management disciplines including data integration, modeling, optimization, and data quality.
• Project management ability to understand business needs and help prioritize and manage workload effectively.
• Data architect capabilities to provide high-level guidance and oversight to the team, ensuring operational stability and long-term maintainability, plus operational support for a 24/7 data operation.
• Strong knowledge of SQL, Python, and Java. Dataflow flex templates are used with Java for data transformations.
• Experience with cloud platforms such as GCP, GKE, IAM, Terraform, and CI/CD to deliver automated solutions.
• Excellent problem-solving and debugging skills, with the ability to identify issue sources in unfamiliar code or systems and address repetitive problems.
• Strong communication skills and a proactive, results-oriented mindset.
• Experience working in Agile teams and familiarity with SCRUM and 2-week sprints.
• Ability to design, build, and deploy data solutions that capture, explore, transform, and utilize data to support mission applications, insights, and reporting.
• Experience with database technologies such as SQL, NoSQL, AlloyDB PostgreSQL.
• Ability to collaborate across teams with varying technical knowledge to deliver data products.
• Strong knowledge of data architecture in application development or reporting.
• Excellent organizational and analytical abilities, with good written and verbal communication skills.

Technologies

• GCP, Dataflow, Cloud Run Functions, Pub/Sub, Pub/Sub streams, Google Storage
• AlloyDB, PostgreSQL, BigQuery, Data Plex
• XML, JSON, Dataflow flex templates, Java, Python, SQL
• NoSQL, GKE, IAM, Terraform, CI/CD, IAC

Benefits

• Competitive compensation
• Comprehensive insurance options
• 401(k) with matching contributions and share purchase plan
• Paid time off for vacation, holidays, and sick time
• Paid parental leave
• Learning opportunities and tuition assistance
• Wellness and well-being programs

Position overview

As a Lead Data Engineer, you will head a team of data engineers and collaborate with architects, engineers, information analysts, and business and technology stakeholders to develop and deploy enterprise-grade platforms that enable data-driven solutions. You will refine design parameters and implementation details of robust data pipelines, optimize data processes, and ensure data quality, security, and governance. The role requires familiarity with Google Cloud Platform services including Dataflow, Cloud Run Functions, AlloyDB, Pub/Sub streams, infrastructure as code, BigQuery, and Data Plex. This is an event-driven environment handling real-time and batch data from legacy external systems. The position can be based at any CGI office in the U.S., with Fairfax, VA as the preferred location and a hybrid work model supported.

What you can expect from us

CGI promotes ownership, teamwork, respect and belonging. You will be empowered to shape your career and contribute to the company’s strategy as a CGI Partner. You will work with a global network of experts, access diverse capabilities to scale your ideas, and benefit from leadership that supports your health and growth. This is a chance to join one of the world’s largest IT and business consulting firms, where your work creates value and opportunities to advance.