Data Engineer

CGI Group, Inc. offers a hybrid work arrangement in Fairfax, VA and a competitive annual compensation range of $113,400 to $223,200. This senior data and analytics engineering role focuses on designing, developing, testing, and deploying data solutions across enterprise environments, leading ETL and ELT pipelines, guiding cloud migration, and advancing CI/CD and DevSecOps practices.

Benefits

• Competitive compensation
• Comprehensive insurance options
• Matching contributions through the 401(k) plan and the 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

Technologies

• SQL Server
• AWS
• Snowflake
• Alteryx

Responsibilities

• Lead the design, development, testing, and deployment of data and analytics capabilities across enterprise data warehouses, analytic platforms, and cloud native services.
• Spearhead ETL/ELT pipeline development, data ingestion, and transformation logic to modernize from on prem SQL Server to cloud data warehouses.
• Create and maintain data architecture artifacts, source-to-target mappings, data flow diagrams, and related technical documentation.
• Write and optimize code to support monthly and ad hoc data refresh cycles, data validation, and performance requirements on large scale data platforms.
• Participate in multi framework Agile delivery by breaking down requirements into user stories, estimating effort, and contributing in sprints with full traceability.
• Collaborate with architects, cloud engineers, DBAs, data stewards, and platform operations to ensure solutions meet enterprise standards and security, audit, and governance needs.
• Design, implement, and maintain CI/CD pipeline components to enable continuous integration and deployment across cloud and on prem environments.
• Conduct unit, integration, regression, performance, and security testing; document results and remediate defects as needed.
• Support release management activities including packaging, code promotion, version control, and deployment in line with change management policies.
• Mentor junior developers, enforce development standards, and participate in code reviews to ensure quality, maintainability, and security.
• Troubleshoot production issues, perform root cause analysis, and contribute to reliability and performance improvements of EDM platforms.

Requirements

• Eight or more years of experience leading data and analytics projects with enterprise scope across on prem and cloud environments.
• Strong hands on development experience with SQL Server, ETL/ELT processes, stored procedures, data modeling, and performance tuning in enterprise data warehouses.
• Experience developing solutions for cloud based data platforms.
• Proven ability to design, document, and implement scalable data ingestion, transformation, and provisioning across complex enterprise ecosystems.
• Proficiency in DevSecOps practices including CI/CD pipelines, automation scripting, environment configuration, and testing frameworks.
• Experience writing, maintaining, and executing test plans, test scripts, automated test suites, and traceability artifacts in line with SDLC standards.
• Ability to work within multi team Agile environments, participating in sprint planning, daily standups, backlog refinement, and sprint reviews.
• Strong understanding of enterprise change management, release management, and configuration management processes.
• Bachelor's degree in Computer Science, Software Engineering, Information Systems, or a related technical discipline.