Job Details

Requisition Number 19-0076
Post Date 4/29/2019
Title Data Architect
City Washington
State DC

Capgemini Government Solutions (CGGS) LLC is seeking highly motivated and experienced Data architect to join our team in the DC Metro Area to support our government clients. 


The successful applicant will have the opportunity to apply and grow their skillset, work with a motivated and entrepreneurial team, engage with a wide range of stakeholders, and build CGGS’ capabilities to serve our clients.


Job Responsibilities


As a Data architect, you will:

  • Develop a highly scalable, reliable, and real-time data processing pipeline
  • Work with business to identify strategic data requirements of the enterprise.
  • Determine how the enterprise’s data will be stored and utilized to best provide actionable data to the end user.
  • Assess the enterprise’s internal and external data and design blueprint to manage the available data.
  • Create an inventory of enterprise’s data and store data in easily accessible format.
  • Design and develop complex database management systems.
  • Collaborate with enterprise’s management to create data models in line with the organization’s needs.
  • Work with internal and external resources to develop robust Extract/Transform/Load (ETL) processes for disparate data sources.
  • Establish and monitor connections to all data sources for stability and reliability.
  • Diligently maintain version control through change management process.
  • Create and maintain objects inside all repositories which accurately store and reflect the data acquired, such as: Tables, Indices, Stored Procedures and Views.
  • Stand up new data sources as required
  • Monitor performance
  • Work to ensure the quality of the data
  • Conforms to standards/governance defined by the business
  • Notify appropriate business partners when quality issues arise, monitors to resolution


Basic Qualifications

  • U.S. Citizenship is required
  • Active Secret Security Clearance
  • Bachelor s degree in a quantitative field such as Engineering Computer Science Statistics Econometrics and a minimum of 2 years of experience
  • 3-5 years building and maintaining a Data Warehouse or other repository designed to be used as a data source for business reporting.
  • Database Administration: 3 years (Required)
  • Data Warehouse: 3 years (Required)
  • Understanding of database administration, construction and data acquisition.
  • Proficiency in multiple database dialects.
  • Proficiency in working with data dictionaries to discover data structures and relationships in varying types of data sources, such as complex systems where knowledgeable resources are difficult to find.
  • Thorough understanding of ETL (Mapping, Cleaning, Transforming).
  • Proven ability to deliver a thoroughly documented ETL strategy that conforms to company’s standards, using only company-approved tools and formats.
  • Working knowledge of Changed Data Capture techniques.
  • Ability to generate forms for data manipulation where necessary, such as developing and maintaining hierarchies or data mapping for harmonization.



Company Overview


A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of client’s opportunities in the evolving world of cloud and digital platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize their business ambitions through an array of services from strategy to operations. Capgemini is driven by the conviction that the business value of technology comes from and through people. It is a multicultural company of 200,000 team members in over 40 countries. The Group reported 2017 global revenues of EUR 12.8 billion. Capgemini Government Solutions, LLC (Capgemini GS) is a subsidiary of Capgemini focused on providing high quality services to the U.S. Federal Government. Learn more about us at

Capgemini has an entrepreneurial environment that embodies the following values: Honesty, Boldness, Trust, Freedom, Team Spirit, Modesty, and Fun. We offer a competitive benefits package to our employees.


Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

#cggsjobs #ondice

Apply On-line
Send This Job to a Friend