Loading, Please wait..!!
Data Architect
-
Posted on: Oct 30, 2026
-
Richmond, Virginia
-
Onsite
-
CTC
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Data Architect roles in Virginia.
View Salary Guide →Find your match !
Job Title :
Data Architect
Job Type :
Contract
Job Location :
Richmond Virginia United States
Remote :
No
Job Description :
We are seeking an experienced Data Architect to lead data architecture, Oracle-to-SQL Server migration, ETL, transformation, reconciliation, and XML-related activities for the client BMP Warehouse modernization project.
Key Responsibilities
- Lead Oracle to SQL Server 2022 migration and database modernization.
- Design target data models, schemas, mappings, and migration approach.
- Develop ETL/data conversion, cleansing, validation, and reconciliation processes.
- Perform data profiling, source-to-target mapping, mock migrations, and production migration support.
- Support BMP transformation logic and EPA/NEIEN XML/XSD generation and validation.
- Support integrations with CEDS/TMDL IP, CGP, GIS/ArcGIS, VACS, and APIs.
- Perform SQL/database performance tuning and data-quality validation.
- Prepare database design, migration, ETL, reconciliation, and as-built documentation.
- Support testing, UAT, deployment, and knowledge transfer.
Required Qualifications
- 10+ years of experience in data architecture, migration, ETL, or data engineering.
- Strong experience with SQL Server, Oracle, PL/SQL, and T-SQL.
- Experience with Oracle-to-SQL Server or similar legacy data migrations.
- Strong skills in data modeling, ETL, data mapping, cleansing, reconciliation, and data quality.
- Experience with XML, XSD, XML parsing/generation, and schema validation.
- Experience with REST APIs and data-intensive enterprise applications.
- Strong technical documentation and communication skills.
Preferred Qualifications
- State or federal government modernization experience.
- Environmental/regulatory data experience.
- Experience with NEIEN, GIS/ArcGIS, GitLab/CI/CD, and public-sector reporting.
- Experience with SSIS, Azure Data Factory, Informatica, Databricks, or similar ETL tools.
Key Skills
SQL Server 2022 | Oracle | PL/SQL | T-SQL | ETL | Data Migration | Data Modeling | Data Quality | Reconciliation | XML | XSD | NEIEN | REST APIs | GIS/ArcGIS
Similar Jobs You May Be Interested In
Salesforce Data Migration Architect
Data Architect
Data Engineer Lead/Data Warehouse Architect (Onsite interviews - Hybrid)
Salesforce Lead or Data Lead/Architect
Data Warehouse Architect (Remote)
Principal AI & Data Architect (Snowflake, Semantic Modeling, Agentic AI)
Principal Enterprise Architect, Data & Analytics
Data Architect with (Payers) - Remote
Senior Enterprise Data Architect (remote)
IT - Technology Architect | Big Data | Graph Databases
Senior Data Architect Usa
Enterprise Data Architect (Data-Mesh)
Position Details
Posted:
Oct 30, 2026
Reference Number:
30879-13017
Employment:
CTC
City:
Richmond
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

