Data Architect - active TS/SCI FSP required

Location: Chantilly, VA

Clearance: TS/SCI Full Scope Polygraph (active)

Remote/Hybrid/Onsite: 100% Onsite work (non-negotiable)

Type: Full-Time/Direct-Hire

Skill Level Desired Years Exp Senior5-10Expert11-15Subject Matter Expert16+
In Bid/Vacant: Vacant

Note: Available Immediately & Benefits posted below

Introduction:

Seeking a Data Architect for a long-term program supporting an IC customer in Chantilly, VA. This position requires an active TS/SCI full-scope polygraph clearance.

The Data Architect will be responsible for defining the structure of data for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) repositories, preparing documentation for database concepts, and working with data modelers to design and develop data models for structured, unstructured, and Data Lake/Lakehouse data. The candidate will also be involved in the design of data engineering and cloud engineering across repositories, working with Data Governance to optimize data structure and collaborating with technical disciplines to ensure a single source of truth and avoid data duplication and movement.

Define the data structure for OLTP and OLAP repositories in relational database management systems (RDBMS) and future Data Lake platforms.
Prepare documentation for database concepts, data design patterns, and preliminary data modeling.
Design and develop data models for structured, unstructured, and Data Lake/Lakehouse data.
Work with Data Governance to optimize data structure and retire or decommission stale data.
Ensure a single source of truth and avoid data duplication and movement.
Manage the logical and physical designs for data.
Work with business analysts to understand the Data flow, CRUD, ETL, and API.
Implement Zero Trust Architecture for data layers.
Provide data architecture support for the full life cycle of data management.
Define data tagging for structured databases, Data Lakes, and data quarantine.

Role:

Demonstrated experience understanding data management and data governance, data catalog, data dictionary, and dataset characteristics.
Demonstrated experience in Data Warehousing, ETL tools, Data Governance, and Analytics.
Demonstrated experience with BI reporting tools like Cognos, Power BI, and Tableau.
Demonstrated experience with logical data model (entity and relationship - ER diagram), and Data Dictionary (attributes and entities and relationship).
Demonstrated experience with relational database design, documentation, building and implementing databases.
Demonstrated experience with data life cycle - data security, data quality, data cleansing, landing zone, backup, restore, retire or archive, and data audits.

Nice to Have:

Demonstrated experience with structure, unstructured databases, and other data pipeline services.
Demonstrated experience collaborating with data producers and consumers (upstream/downstream).
Demonstrated experience understanding other data pipelines or data analytic providers via cloud marketplace or proprietary providers.
Demonstrated experience with deep-dive data analysis and ability to identify data patterns and behavior of the data.

Salary:

You know the salary range you are looking for, so let's talk after you fill out the application.

Benefits:

Our client is always looking for TS/SCI FSP Information Technology talent. The standard compensation package includes a competitive salary, 100% company-paid health/dental/vision care benefits, 100% company-paid LTD/STD/Life Insurance benefits, a 401(k) with company match, and a generous holiday/vacation/sick leave policy.
Note:

• No 3rd party vendors or candidates
• US Citizenship Required
• Active TS/SCI - FSP is Required