Data Architect

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.

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