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
