> Markdown version of [/jobs/ext/1279093-data-edw-architect](https://www.wearedevelopers.com/jobs/ext/1279093-data-edw-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data / EDW Architect

- **Company:** Procentrix, Inc.
- **Location:** Washington, DC, United States (Remote available)
- **Experience:** Expert
- **Salary:** $170,000.0 - $200,000.0
- **Contract:** Permanent contract
- **Skills:** Business Analytics Applications, Data Analysis, Cloud Computing, Databases, Data as a Services, Data Architecture, Data Dictionary, Data Integration, Extract Transform Load (ETL), Data Migration, Data Transformation Services, Data Warehousing, Database Design, Python (Programming Language), Performance Tuning, SAS (Software), SQL Server Integration Services, Enterprise Search, Data Storage Technologies, Data Strategy, SC Clearance, Data Lakes, Information Technology, Data Management, Cloud Optimization
- **Published:** July 15, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=68d02e8dec72556a

## About the Role

10+ years' experience with data analysis, data migration tools, data modeling, data integration, data warehousing and database design.
5+ years' experience in addressing issues of data migration/validation, clean-up and mapping, and shall produce and maintain the data dictionaries.
5+ years' experience with providing technical support in the research, experimentation, business analysis, and use of systems technology, including architecture, integration capabilities, and database management.
5+ years' experience with providing technical and data leadership for the application developers and the IT infrastructure, being conversant with and cognizant of the future direction of systems, how that direction will impact enterprise, and how future and current systems can be exploited for the benefit of the enterprise.
5+ years' experience working closely with other IT groups to coordinate current and future IT plans and activities, including coordination and technical assistance to facilitate specific development projects that involve the computing environment, the coordination of software upgrades, and the installation of new products.
5+ years' experience with recognizing and identifying potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding future business expansion.
Candidate must be U.S. citizen and local to the Washington DC Metro area. Must be able to work on-site at customer locations in Northern VA. Telework options may be identified as the Government deems appropriate.
Active DoD or DEA Secret clearance is required.

Desirable Skills

Experienced with Microsoft based data services
Experienced implementating SAS based analytics solutions
Microsoft certifications

## Description

Seeking a Data Architect to support and modernize an existing Enterprise Data Warehouse, Reporting, and Enterprise Search environment for a federal agency. The Architect will serve as a SME on all aspects of data management; make recommendations for improvements; research solutions; and lead using data management and Cloud best practices. Responsibilites include:

Design data architectures, including DW and Data Lakes, to support enterprise analytics and search
Develop scripts to load and retrieve data content
Perform database support and maintenance activities
Conduct performance tuning and database design
Dimensional analysis, modeling
Develop and support SQL Server Integration Service (SSIS) packages, Python packages, and/or emerging technologies for ETL processing
Provide support and assist in establishing database standards and best practices
Design / modernize data management strategy using Cloud technologies
Develop roadmaps for enhanced data architectures which ensure optimal data storage and enhanced analysis capabilities aligning with customer priorities.

The projected compensation range for this position is $170K - $200K annualized (USD). The final salary offered will generally fall within this range and is determined by various factors, including but not limited to the individual's particular combination of education, knowledge, skills, competencies, and experience, as well as internal pay equity, location, contract-specific affordability and other organizational requirements.


## Related Videos

- [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [The Data Mesh as the end of the Datalake as we know it](https://www.wearedevelopers.com/videos/156-the-data-mesh-as-the-end-of-the-datalake-as-we-know-it)
- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)