Data Architect

Full-time

My3Tech

Richmond, VA

Hello Associates,

Position: Data Architect

Location: Richmond, VA (Hybrid)

Duration: 8 Months

Job Description:

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.

P referred 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

Apply

Vacancy posted 23 hours ago

Similar jobs that could be interesting for youBased on the Data Architect in Richmond, VA vacancy

Data Architect
$120.8k - $181.2k
OverviewMcGuireWoods LLP is seeking a Data Architect to join our IT team. The Data Architect is responsible for the design and technical architecture of the Firm’s Data Lakehouse environment and ensures that data is appropriately structured, integrated, and available to...
Suggested
Remote work
McGuireWoods
Richmond, VA
3 days ago
Data Observability Architect
...We are looking for an experienced Data Observability Architect with 10–15 years of experience in Data Engineering/Data Architecture and strong hands-on expertise in Monte Carlo Data Observability. The role involves designing and implementing data observability solutions...
Suggested
Contract work
Techvilla Solutions
Richmond, VA
17 days ago
Lead Data Architect
$120.9k - $187k
...together. • Make it better. We create fulfilling purpose-driven careers by learning from the world and each other.POSITION TITLELead Data ArchitectThis role is not eligible for employment visa sponsorship.LOCATIONThis role is open to remote candidates residing in the...
Suggested
Full time
Work at office
Local area
Remote work
Genworth Financial
Richmond, VA
4 days ago
Principal Data and AI Architect
$173.46k - $231.98k
...era? You’re in the right place! Agentforce is the future of AI, and you are the future of Salesforce.About the TeamWe are a Data & AI Architects team focused on helping Global Public Sector customers, spanning Defense, Federal/Civilian, State and Local Government, Higher...
Suggested
Full time
Work experience placement
Local area
Immediate start
Remote work
Salesforce
Richmond, VA
3 days ago
Snowflake Finance Data & AI Architect Manager
...Recruiting for this role ends on 09/30/2026Work you'll doAs a Finance Data & AI Manager specializing in Microsoft Azure and Fabric, you’ll... ...for planning, close, profitability, treasury, and reporting• Architect production ML and generative and agentic AI with Fabric Data...
Suggested
Local area
Visa sponsorship
Deloitte
Richmond, VA
2 days ago
Senior Data Architect (AWS, Azure, GCP)
$120k - $200k
...Fortune 100 companies, mid-sized enterprises, and government agencies, a list that spans across the country.Job DescriptionCapTech Data Architects match our clients’ business goals with available technologies when developing a strategy for a successful data delivery...
Work at office
Remote work
Visa sponsorship
Work visa
Flexible hours
CapTech
Richmond, VA
4 days ago
Data Architect (AWS, Azure, GCP)
$120k - $200k
...businesses. We unite diverse skills and perspectives to transform how data, systems, and ingenuity enable each client to advance what’s... .... 500/5000 list for over a decade. Job DescriptionCapTech Data Architects match our clients’ business goals with available technologies...
Work at office
Remote work
Visa sponsorship
Work visa
Flexible hours
CapTech
Richmond, VA
4 days ago
Data Analyst
$60.02k - $66.69k
...Job Posting ID: KT_253_JOB Position: Data Analyst FT/PT Status: Full-Time Location: Remote Education: Bachelor's degree in Information Technology or a related field preferred; equivalent experience will be considered. Overview: Kreative Technologies...
Full time
Work at office
Remote work
Kreative Technologies
Richmond, VA
10 hours ago
Data Analyst
$42 per hour
*No C2C will be allowed* Title: Sr. Data Analyst Pay: $42 per hour Type: Hybrid – Richmond VA Duration: 12 months with potential to extend Position Overview: We are seeking a skilled Data Analyst with strong experience in SQL, Python, data analysis...
Hourly pay
Swoon
Richmond, VA
1 day ago
Data Reporting & UAT Analyst
...Dear Applicant, Greetings. This is Sneha from InfoSmart Technologies Inc. We have an immediate opening for Data Reporting & UAT Analyst for Remote AND at 600 E Broad St Richmond, VA 23219 . If you are looking for new opportunities, please reach me at ****@*****.***...
Immediate start
Remote work
InfoSmart Technologies, Inc
Richmond, VA
4 days ago
Data Analyst
...Akkodis is seeking a Data Analyst for a Contract job with a client in Richmond VA . Ideally looking for applicants with a solid background in the financial services industry . Data Analyst Location: Richmond VA-Hybrid Rate Range: $55- $ 58/hr on w2 ;...
Contract work
Temporary work
Local area
Akkodis
Richmond, VA
2 days ago
Data Analyst
...Job Title: Data Analyst Location : Richmond VA. – Hybrid Duration:: 6+ Months (Contract) Interview: Video Must Have Skills: Languages: SQL Python Data table/architecture Tools Snowflake Data Bricks AWS (One lake/S3) Nice to have...
Contract work
Holistic Partners, Inc
Richmond, VA
18 hours ago
Data Analyst
...Job Title: Data Analyst Duration: 12 Months (Contract) Location: Richmond, VA Job Summary: We are seeking an experienced Data Analyst to collect, analyze, interpret, and visualize data to support business decisions. The ideal candidate will have strong SQL...
Contract work
Matlen Silver
Richmond, VA
1 day ago
Data Analyst (Hybrid Remote)
$40 - $45 per hour
1 Year Contract Hybrid Remote (2 -3 days per week remote / work from home) Compensation: $40-45/hr Senior Data Analyst We are seeking a detail-oriented and technically proficient Data Analyst to join our team. This role is pivotal in analyzing, modeling...
Contract work
Remote work
Work from home
2 days per week
3 days per week
TECHEAD
Richmond, VA
1 day ago
Senior Data Science Analyst
...Position: Senior Data Science Analyst Location: Richmond, Virginia Duration: Contract Job ID: 179944 Job Overview: The Senior Data Science Analyst will play a critical role in designing, building, and optimizing scalable, reliable data pipelines at...
Full time
Contract work
PTR Global
Richmond, VA
18 hours ago
Data Analyst
$97.7k - $162.8k
...help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.Work you'll doAs a Data Engineer II on the AI & Data team, you will be responsible for:Design, develop, and deliver data-driven insights for Deloitte and client...
Local area
Deloitte
Richmond, VA
2 days ago
Lead Cybersecurity Architect
$122k - $203.4k
...health today, we want to hear from you.The Senior Cyber Security Architect is a advanced-skill role responsible for establishing and... ...guardrails across cloud, network, identity, endpoint, application, and data protection; ensure designs are secure-by-design and compliant-...
Full time
McKesson
Richmond, VA
3 days ago
Lead Adobe Commerce Architect
$134.5k - $265.1k
...drive sustained growth through customer and commercial strategy, data and analytics, Generative AI, digital products, marketing, commerce, sales, and service. As a Lead Business Transformation Architect specializing in Adobe Commerce, you will help clients define scalable...
Local area
Visa sponsorship
Deloitte
Richmond, VA
3 days ago
Lead Platform Architect, Cloud
$120.9k - $187k
...Make it better. We create fulfilling purpose-driven careers by learning from the world and each other.POSITION TITLELead Platform Architect, CloudPOSITION LOCATIONThis position is available to Virginia residents as Richmond, Virginia in-office applicants*A Hybrid schedule...
Full time
Work at office
Local area
Remote work
Genworth Financial
Richmond, VA
2 days ago
Lead Architect with Anthropic Experience
$141.2k - $278.3k
Position Summary Lead Architect with Agentic AI Experience, AI & Engineering/Engineering as a ServiceAgentic AI is moving from experimentation... ...operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These solutions...
Work at office
Local area
Visa sponsorship
Flexible hours
Shift work
Deloitte
Richmond, VA
1 day ago
Data Reporting & UAT Analyst (Richmond)
...Dear Applicant, Greetings. This is Sneha from InfoSmart Technologies Inc. We have an immediate opening for Data Reporting & UAT Analyst for Remote AND at 600 E Broad St Richmond, VA 23219 . If you are looking for new opportunities, please reach me at ****@*****.***...
Part time
Immediate start
Remote work
InfoSmart Technologies, Inc
Richmond, VA
4 days ago
Senior Data Analyst
...and delivering patient-centered services supported by a comprehensive medical management corporation. Role Description The Senior Data Analyst is a full-time, on-site role based in Gate City, VA. The individual in this role will collect, clean, and analyze healthcare...
Full time
Local area
Balad Health
Richmond, VA
18 hours ago
Microsoft Purview and Data Governance Senior Consultant
$105.4k - $207.8k
...helps organizations address evolving cyber threats with solutions that strengthen resilience, support compliance, and protect critical data. As part of this team, you will help clients design and implement Microsoft Purview capabilities that advance data governance,...
Local area
Visa sponsorship
Deloitte
Richmond, VA
2 days ago
Data Analyst
...Data AnalystClient: State of VALocation: Richmond, VA. Once in two weeks onsiteType of Hire: Contract - 6 month contract with extension of next 6 monthsInterview: One and done next weekResumes Review: Monday at 10:00 AM ESTSubvending: YesCandidate will need to give presentations...
Contract work
Software Technology Inc
Richmond, VA
1 day ago
Data Analyst
...Engagement Type Contract Key Responsibilities Analyze and interpret IT financial data across Azure and VITA environments, including consumption, billing, and chargeback models. Develop and maintain Power BI dashboards and reports to visualize cost trends...
Contract work
Oorwin AI
Richmond, VA
4 days ago
Data Analyst 4
...Data Analyst 4Location: Atmore Road, Richmond VA 23225 Note: This is an onsite position. Candidate must be able to work on site. Local candidates are strongly preferred.Job Description: The role supports workflow improvement, clinical data analysis, and validation work...
Local area
Tri-Force Consulting Services Inc. | IT Recruitment & Staffi...
Richmond, VA
2 days ago
Data Analyst - Sr
$52 - $56 per hour
THIS JOB DESCRIPTION WAS CREATED BY AI, REVIEW BEFORE POSTING Position: Data Analyst - Sr - W2 Only Location: Mclean VA - onsite Hybrid Duration: Contract Job ID: 180485 Job Overview: A Senior Data Analyst is responsible for transforming complex data into...
Full time
Contract work
Pinnacle Group
Richmond, VA
4 days ago
Data Analyst - Sr
...Job PostingPerforming analytics on AWS, involved with Cloud TestingExtract the Data & perform Analytics.Automation (Create EC2 Scripts)Extract the data from trail logs, manages the DataOptimization of Script (Manipulation & Transformation)The team is involved with Terraform...
Samprasoft
Richmond, VA
2 days ago
Sr. Data Analyst
...About the Role: As a CBRE Sr. Data Analyst, you will perform a variety of analyses to ensure that recommendations and business conclusions are backed by sound data findings and thorough data research. This job is part of the Data Science & Analytics job function. They...
Hourly pay
Work at office
Visa sponsorship
Flexible hours
CBRE
Richmond, VA
4 days ago
Data Product and Integration Analyst
$84.4k - $127k
...In office days are Tuesday, Wednesday and Thursday with working hours targeting our core business hours of 9am-5pm EST.YOUR ROLEThe Data Product & Integration Analyst serves as a key connector between business stakeholders, analytics teams, data engineering, and technology...
Full time
Work experience placement
Work at office
Local area
Remote work
Genworth Financial
Richmond, VA
1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Architect. Be the first to apply!