Data Engineer SME (Data Collection Engines) - U.S. Citizenship Required

Category: Software Development/ Engineering
Main location: United States, Virginia, Fairfax
Position ID: J0324-2158
Employment Type: Full Time
jobimage

Position Description:

CGI is one of the top 5 largest global IT companies spread across 40 countries with endless opportunities to expand and grow. As a CGI Federal Member, you have the opportunity to be a shareholder at CGI and join a family of 90,000 members strong.

CGI Federal is hiring a Data Engineer SME (Data Collection Engines) to work with a skilled and motivated team of professionals on a high-visibility Department of Homeland Security (DHS) Cybersecurity and Infrastructure Security Agency (CISA) cyber security program. You will support a dynamic, fast-paced project focused on improving the cyber security posture of civilian government agencies through the implementation and enhancement of a cybersecurity platform, providing integration services, and developing, securing and maintaining cybersecurity dashboards. You will work closely with a variety of agency stakeholders, supporting their mission, priorities, organization and unique challenges. You will also support the development of additional cyber security offerings focused on next generation security solutions and technologies.

The successful candidate for this position is a motivated individual, a self-starter who works effectively in a dynamic environment. This is a great opportunity with room to grow both on the program and within CGI Federal!

This position is located in our Fairfax, VA office; however, a hybrid working model is acceptable.
You will be required to be in our Fairfax, VA office two days per week.

Your future duties and responsibilities:

• Develop scripts using Python, Java or Scala to extract data from published vendor APIs to be consumed from upstream processes
• Understand data lakehouse technologies like Iceberg, Databricks, Redshift Spectrum, Athena and Snowflake
• Build secure containerized images that can run extraction code as a microservice
• Integrate solutions using an event driven architecture leveraging AWS GovCloud technologies
• Provide detailed specifications for proposed solutions including materials, effort, and time necessary
• Perform performance analysis to identify bottle necks in processes and recommend improvements
• Assist Solution Architects to refine and improve extraction processes
• Perform root cause analysis and remediation of production errors
• Other duties as assigned based on competencies and personal goals

Required qualifications to be successful in this role:

• Due to the nature of the contract requirements, US citizenship and successful passing of CGI background check is required prior to beginning work. In addition, candidates must have the ability to obtain and maintain a DHS CISA EOD/Public Trust clearance
• Bachelor's degree in Computer Science or data related field required and 8+ years experience
• Experience developing applications/utilities using Python, Java, or Scala leveraging tools like Presto, AWS Athena, Spark or AWS Glue
• Design and develop utilities to transform, enhance, and clean-up data in preparation for loading to target data-lake such a Redshift, Iceberg or Elasticsearch
• Design and develop stored procedures for data validation
• Parse disparate data sources including XLS, XML, JSON and CSV files and load/output to similar formats
• Build logic to clean-up data, ensure compliance to defined data-dictionary
• Research on published APIs for identified tools with an intent to extract the data using right APIs and access points
• Test and debug custom data extraction utilities and validate the data-feed requirements that are part of the data-pipe line
• Update and maintain the data extraction utilities to comply with the changes in data sources
• Prior experience in information technology, contracting or other related fields
• Experience with Agile development concepts or an interest to learn
• Experience in cybersecurity
• Experience with testing/or requirements development
• An aspiration to be a perpetual learner is highly desirable
• Experience with project coordination and administration
• Experience with Jira and/or Confluence
• Experience on complex work assignments in matrixed organizations
• Exposure to or general knowledge of CISA’s Continuous Diagnostics and Mitigation Program (CDM)

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 license 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 estimate of the current range for this role in the U.S. is $108,600.00 - $235,200.00.

#CGIFederalJob
#LI-MC3
#DHSCareers

Skills:

  • Data Visualisation
  • Python
  • SQL
  • XML

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.

Qualified applicants will receive consideration for employment without regard to their race, ethnicity, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, pregnancy, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity, and gender expression, familial status, political affiliation, genetic information, height, weight, or any other legally protected status or characteristics.

CGI provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a job in the U.S., please email the CGI U.S. Employment Compliance mailbox at US_Employment_Compliance@cgi.com. You will need to reference the Position ID of the position in which you are interested. Your message will be routed to the appropriate recruiter who will assist you. Please note, this email address is only to be used for those individuals who need an accommodation to apply for a job. Emails for any other reason or those that do not include a Position ID will not be returned.

We make it easy to translate military experience and skills! Click here to be directed to our site that is dedicated to veterans and transitioning service members.

All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary dependent upon specific assignment and/or level of US government security clearance held. CGI will consider for employment qualified applicants with arrests and conviction records in accordance with all local regulations and ordinances.

CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGI’s legal duty to furnish information.

CGI is committed to the principles of equal employment opportunity and to compliance with US laws and regulations. Click here to access an overview of our U.S. Equal Employment Opportunity and Anti-Harassment Policy.

Applicants have rights under Federal Employment Laws:

  1. EPPA
  2. FMLA
  3. Know Your Rights: Workplace Discrimination is Illegal
  4. Pay Transparency Statement Policy

CGI provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a job in the U.S., please email the CGI U.S. Employment Compliance mailbox at US_Employment_Compliance@cgi.com. You will need to reference the Position ID of the position in which you are interested. Your message will be routed to the appropriate recruiter who will assist you. Please note, this email address is only to be used for those individuals who need an accommodation to apply for a job. Emails for any other reason or those that do not include a Position ID will not be returned.

We make it easy to translate military experience and skills! Click here to be directed to our site that is dedicated to veterans and transitioning service members.