Data Architect

Job Title: Data Architect

Location: Washington, DC (%50% On-site)

Duration: Long Term Contract

Technical Skills: Years/Level of Experience

Dimensional Modeling (3-5 yrs experience)

Data Warehouse Tools (3-5 yrs experience)

Data Modeling (3-5 yrs experience)

Oracle Data Warehouse Solution Architecture (3-5 yrs experience)

ERwin (3-5 yrs experience)

Role Description:

50% onsite-Washington DC.

Bachelor’s degree, or higher (in a related discipline) Three to Five years’ experience

Substitute additional four (4) years of experience for a bachelor’s degree.

Role Summary

The Data Architect is responsible for designing and maintaining enterprise data warehouse solutions that support reporting, analytics, and business intelligence initiatives. This role develops data models, integration strategies, and architecture standards to ensure data quality, security, scalability, and performance.

Key Responsibilities

• Design and maintain data warehouse architecture, data models, and data integration solutions.
• Define data standards, governance practices, and data quality controls.
• Collaborate with business and technical teams to translate requirements into scalable data solutions.
• Support ETL/ELT processes, data migrations, and performance optimization efforts.
• Participate in architecture reviews, Agile ceremonies, and technical design sessions.
• Create and maintain architecture diagrams, data dictionaries, SOPs, and technical documentation.

Required Skills

• Data warehouse architecture and dimensional modeling
• Design diagrams using ERWIN
• SQL and database design
• ETL/ELT and data integration
• Data governance and data quality management
• Agile/Scrum methodologies
• Strong analytical, communication, and documentation skills

Preferred Experience

• Experience with enterprise data warehouse platforms and business intelligence tools.
• Knowledge of data migration, and performance tuning.

Education Level: Bachelor’s Degree, or higher (in a related discipline) Three to Five years of experience

Work Location On-site (Government / AFS Site): Washington, D.C.

On-site %: 50%

Special Requirements

Work Authorization: s & US Persons ()

Clearance Required: Public Trust