IT

Data Architect

Centurion Consulting Group

Data Architect Remote

Description

We are hiring a Data Architect to join a team of experienced Enterprise, Business, and Data Architects providing advisory support to a large federal agency as it continues the development and management of the agency’s Enterprise Architecture (EA) and related technologies. 

The Data Architect will use modern technologies to develop and maintain the EA-related database components and data analytical tools; perform quality control; transform and reorganize data via Extract-Transform-Load (ETL), indexing, and data cubes; and release those datasets in a curated, consistent format using established data standards. 

Responsibilities:

  • Develop conceptual, logical and physical models for applications/enterprise data repositories;
  • Support modeling and design of the client’s Enterprise Data Repository and related data storage strategies;
  • Provision enterprise data from various sources and provide standard data extracts for updating the Enterprise Data Repository tool;
  • Support the organization, definition, and cataloging of enterprise data;
  • Support the client’s data strategy and governance models;
  • Design and implement interfaces/data exchanges between client systems;
  • Provide development support for SQL Server databases in a cloud development environment including development of DB artifacts (Tables, Views, stored procedures, Scripts, etc.);
  • Develop, deploy, and maintain ETL scripts and schedules;
  • Leverage API’s to extract/load data from/to various applications;
  • Lead data QA efforts and establish data quality standards;
  • Participate in the refinement and development of user stories, assessing the impact of new development on current database implementation and providing level of effort estimates during Sprint planning;
  • Participate in daily Scrum, Sprint planning, and Sprint retrospective ceremonies;
  • Communicate with technical and product owner stakeholders to help them anticipate and mitigate configuration management issues.
  • Perform analysis and provide recommendations to grow and mature CMS EA’s data architecture information and activities.

Required Skills:

  • Bachelor’s degree in Computer Science, Information Systems, or equivalent work experience. Knowledge of transactional database and data warehouse architecture, design, and development.
  • Mastery in developing/instantiating conceptual, logical, and physical data models
  • Extensive data migration skills and working experience with ETL concepts and tools
  • Deep knowledge of relational database’s objects and their functions
  • Deep expertise in all aspects of management and development in MS SQL Server
  • Exposure to Cloud Database technologies, AWS
  • Strong ability to independently write complex SQL queries to answer multi-layered analytics questions from team members and clients.
  • Experience in developing interfaces for data exchange between application
  • Solid understanding and work experience with Schema-less data structures
  • Exposure to Graph Database technologies
  • Solid understanding and experience working in an Agile methodology environment
  • Ability to accurately estimate the level of effort needed to complete tasks and commitment to deliver
  • Excellent analytical, organizational and communication skills with a strong desire to collaborate to accomplish tasks and resolve issues
  • Naturally inquisitive and pro-actively seeks new knowledge and expertise

Desired Skills:

  • Master’s degree in Computer Science or Information Systems. 
  • Experience with database management in a commercial Cloud environment (AWS, Azure)
  • Working knowledge of Enterprise Repository tools like Alfabet or ARIS.

Position Details: 

Clearance: Ability to Obtain a Public Trust

US Citizenship or Authorization to work in US required

Travel: < 10% (CONUS)

Centurion Consulting Group, LLC is an Equal Opportunity Employer EOE M/F/D/V

No third parties or subcontractors

Tagged as: Data Architect