> Markdown version of [/jobs/ext/3750992-data-architect](https://www.wearedevelopers.com/jobs/ext/3750992-data-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 Architect

- **Company:** MY3TECH INC
- **Location:** Richmond, VA, United States
- **Experience:** Expert
- **Contract:** Temporary to permanent
- **Skills:** XML Schema, Application Programming Interfaces (APIs), ArcGIS (Software), Databases, Data Architecture, Data Conversion, Information Engineering, Extract Transform Load (ETL), Data Mapping, Data Migration, Data Profiling, Database Design, Microsoft SQL Server, Oracle (Applications), PL-SQL, SQL Databases, SQL Server Integration Services, Systems Integration, Transact-SQL, Extensible Markup Language (XML), Enterprise Software Applications, Azure Data Factory, Informatica Powercenter, Database Optimization, Gitlab-ci, Restful APIs, Databricks
- **Published:** October 15, 2026
- **Apply:** https://www.careerjet.com/jobad/usd17c533824bb94d368d07d025f8f4523

## About the Role

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

## Description

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.