Senior Data Engineer; Secret Cleared

Job order - J - Permanent Full Time

Title: Senior Data Engineer (Secret Cleared)

Category: Database Administration

City: Arlington, Virginia, United States

CGI Federal is seeking a Senior Data Engineer to architect, build, and optimize scalable data pipelines and enterprise data models. In this role, you will support the design and implementation of data solutions using medallion architecture principles, ensuring structured, high quality data across bronze, silver, and gold layers. You will work in a fast paced, agile environment that values innovation, collaboration, and the use of emerging technologies to advance our clients' data capabilities.

This position is located in Arlington, VA.

• Pipeline Development:
  Design, build, and maintain scalable, production grade data pipelines using modern frameworks and cloud based processing technologies, aligned with medallion/lakehouse architecture best practices.
• Data Modeling:
  Architect, implement, and maintain conceptual, logical, and physical data models, ensuring clear relationships and optimized structures across bronze, silver, and gold data layers.
• Data Transformation:
  Develop robust transformation workflows that produce curated, high quality datasets and a well structured semantic layer supporting analytics, data science, and operational use cases.
• Optimization:
  Continuously optimize and tune data workflows for performance, cost efficiency, reliability, and scalability across distributed data processing environments.
• Data Quality & Governance:
  Implement and enforce data quality checks, validation rules, metadata standards, and lineage tracking to ensure accuracy and integrity throughout the data lifecycle.
• Reporting Support:
  Assist in enabling data visualizations and BI reporting by ensuring curated data is readily accessible to downstream analytics tools.
• Collaboration:
  
  Collaborate with stakeholders, including data scientists and business analysts, to define data requirements and deliver scalable, well documented solutions.

• Education:
  
  Bachelor's degree in Computer Science, Engineering, or a related field.
• 4 8 years of experience in data engineering, ETL/ELT development, and production pipeline support.
• Technical
  
  Skills:
  • Strong expertise in designing and building scalable ETL/ELT pipelines and data integration solutions.
  • Proficiency in SQL and Python for data processing, transformation, and automation.
  • Experience with distributed processing engines and scalable compute frameworks (e.g., Apache Spark).
  • Hands on experience with modern enterprise data platforms such as Databricks or Azure Synapse.
  • Deep proficiency in data modeling, schema design, and implementing medallion/lakehouse architectures.
  • Experience with cloud native data services and storage technologies across major cloud platforms.
  • Familiarity with orchestration tools and CI/CD pipelines for automated deployments.
• Soft Skills:
  • Strong communication and collaboration skills; ability to articulate technical concepts to varied audiences.
  • Ability to lead design discussions, mentor junior engineers, and contribute to architectural decision making.
• Desired qualifications/non essential skills required:
  • Knowledge of data visualization tools (e.g., Tableau, Power BI).
  • Strong problem solving and debugging skills.
  • Experience with workflow orchestration tools or job scheduling frameworks.
  • Understanding of data governance concepts, including metadata management, lineage, access control, and data stewardship.
  • Exposure to CI/CD practices, version control workflows, and automated testing in a data engineering context.

CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit based performance, CGI typically does not hire individuals at or near the top of the range for their role.

Compensation decisions are dependent on the facts and circumstances of each case. A reasonable…