IT Principal Data Architect - Data Migration, OLTP, ETL
$156.64kMAXIMUS
Maximus is currently seeking an IT Principal Data Architect. The IT Principal Data Architect - (Data Migration) is a senior technical leader responsible for the architecture, engineering, and delivery of large-scale, complex data migration programs, transforming data from legacy platforms into modern, cloud-based application systems and data platforms. This role combines hands-on technical leadership, data architecture excellence, and delivery accountability to ensure migrations are accurate, scalable, secure, and production ready.
The IT Principal Data Architect provides technical direction for data architecture, migration design, and pipeline engineering while coordinating end-to-end delivery across matrixed data engineering, platform, application, testing, and operations teams. This role is accountable for data migration strategy, technical design decisions, execution quality, performance, data integrity, and long-term platform sustainability.
Why This Role Matters
Modernization initiatives succeed or fail based on data. Legacy data landscapes are often fragmented, inconsistent, poorly documented, and tightly coupled to aging systems. Migrating this data to modern systems and data platforms introduces significant technical, operational, and regulatory risk.
The IT Principal Data Architect ensures that data migrations are:
Architected correctly to support scalability, performance, and future-state analytics
Engineered using robust, automated, and testable pipelines
Executed with strong data validation, reconciliation, and lineage controls
Secure, compliant, and operationally stable at scale
Designed to enable downstream analytics, reporting, and AI/ML use cases
This role is critical to reducing migration risk, avoiding data-related production failures, and enabling long-term data platform modernization.
This is a remote position.
Essential Duties and Responsibilities:
Determine optimal architecture to support business requirements and solve highly complex technical challenges.
Stay current with industry trends/development and contribute to ongoing research and development.
Guide and mentor architects and engineers establishing and maintaining architecture of highly complex solutions.
Produce solution architecture and estimates to support initiative proposals and business development.
Contribute to standards and approaches for architecture of enterprise data solutions.
Optimize overall data/information flow by reducing redundancy and enabling accessibility within security boundaries.
Identify data-related business requirements and service standards, and translate these into actionable architecture design.
Frequently responsible for providing guidance, coaching, and training to other employees across the organization within area of expertise.
Job-Specific Essential Duties and Responsibilities:
Data Architecture & Migration Strategy
Own the end-to-end technical architecture for complex data migration initiatives from legacy systems to modern data platforms.
Define target-state data architectures including modern applications, data lakes, warehouses, lakehouse patterns, and real-time/streaming integrations.
Design migration strategies (phased, domain-based, parallel run, cutover) based on data criticality, volume, and business risk.
Ensure alignment with enterprise data architecture, integration standards, and cloud platform strategies.
Data Engineering & Technical Delivery
Lead hands-on technical design and delivery of data ingestion, transformation, and persistence layers.
Establish standards for ETL/ELT pipelines, orchestration, schema management, metadata, and error handling.
Coordinate implementation across matrixed data engineers, application teams, platform engineers, QE, and operations.
Ensure pipelines meet non-functional requirements for performance, scalability, resiliency, availability, and cost efficiency.
Data Quality, Validation & Governance
Architect and govern data validation, reconciliation, and control frameworks for all migrations.
Ensure data completeness, accuracy, consistency, and referential integrity across source and target systems.
Implement data lineage, auditability, and traceability to support regulatory, financial, and operational needs.
Partner with Security, Privacy, and Compliance teams to enforce data protection, encryption, masking, and access controls.
Program Execution & Delivery Accountability
Manage technically complex, multi-stream data programs spanning multiple source systems and consumer platforms.
Build and maintain detailed technical migration roadmaps, dependency maps, and milestone plans.
Identify and mitigate risks related to data integrity, performance bottlenecks, schema drift, and operational readiness.
Lead cutover execution, rollback planning, and post-migration stabilization.
Testing, Readiness & Production Operations
Define and enforce test strategies for data migrations, including unit testing, data reconciliation testing, performance testing, and business validation.
Partner with QE and UAT teams to ensure business data correctness and outcome validation.
Own technical production readiness reviews and go-live criteria.
Ensure operational monitoring, alerting, and incident response mechanisms are implemented prior to go-live.
Platform Enablement & Modern Data Capabilities
Partner with Cloud and Platform teams to optimize infrastructure performance, reliability, and cost.
Enable consumption-ready data models for analytics, reporting, APIs, and AI/ML workloads.
Drive adoption of automation, Infrastructure-as-Code, and CI/CD for data pipelines.
Stakeholder & Cross-Functional Leadership
Serve as the primary technical authority for data migration and data platform delivery.
Communicate complex technical risks, tradeoffs, and architecture decisions in business-relevant terms.
Coordinate closely with Business, Product, Architecture, Analytics, PMO, and Operations leaders.
Team Leadership & Engineering Excellence
Lead and mentor data engineering engineers, and technical leads.
Establish engineering standards, design review practices, and technical governance.
Build a culture of engineering rigor, automation, quality, and continuous improvement.
Minimum Requirements
'- Bachelor's degree in relevant field of study and 10+ years of relevant professional experience required.
Job-Specific Minimum Requirements:
Additional years of relevant experience will be considered in lieu of degree. Master's degree preferred.
10+ years of experience in data engineering, data architecture, or large-scale platform modernization.
5+ years leading technically complex enterprise data migration programs.
Deep experience migrating data from legacy systems (mainframe, on‑prem relational/NoSQL databases, proprietary platforms).
Proven success delivering data platforms in cloud environments at enterprise scale.
Experience leading delivery across matrixed engineering, application, testing, and operations organizations.
Technical & Architecture Expertise
Data migration architecture and execution.
Experience with CRM, ERP, Healthcare Insurance and Benefits systems and data models.
Modern data architectures (data lakes, warehouses, lakehouse, streaming)
ETL/ELT design patterns and orchestration frameworks.
Schema evolution, data modeling, and domain-oriented data design.
Data quality, reconciliation, and lineage frameworks.
Performance tuning and large-scale data processing.
Security, privacy, and regulatory data controls.
DevOps and CI/CD pipelines for data engineering.
Leadership & Collaboration
Recognized technical leader capable of influencing architecture and engineering decisions.
Strong ability to lead senior engineers and architects in matrixed environments.
Clear communicator able to translate technical complexity into business impact.
Success Measures
Successful delivery of complex data migrations with high data accuracy and integrity.
Stable, scalable, and secure modern data platforms in production.
Minimal post-migration defects and data issues.
Improved trust in enterprise data for analytics and operations.
High-performing data engineering teams delivering with technical rigor.
Preferred Skills and Qualifications:
Domain Experience
Healthcare, Insurance, Medicare, Medicaid, or State & Local Government.
Experience with regulated, high-volume, or mission-critical data platforms.
Certifications:
Cloud certifications (AWS, Azure, or GCP)
Data engineering or analytics certifications
Architecture or platform certifications
#techjobs #Veteranspage #LI-Remote
Maximus is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, age, national origin, disability, veteran status, genetic information and other legally protected characteristics.
Minimum Salary
$156,640
Maximum Salary
$234,960
- ...Ad Hoc in McLean, Virginia, is looking for a Senior Data Architect to support federal clients by developing data architecture strategies and leading data migrations. You will manage data pipelines, mentor junior analysts, and drive data governance initiatives. The ideal...SuggestedRemote workFlexible hours
- IMAGINEEER LLC is seeking an experienced Data Architect / Data Analyst to assist in migrating core HR IT functions for the Department of Health and Human Services.... ...candidate has experience with federal HRIT systems and proficiency in ETL tools. #J-18808-Ljbffr IMAGINEEER LLCSuggestedRemote job
- A consulting firm in McLean, VA is looking for a skilled Data Engineer/ETL expert to join their team. This role requires expertise in data flow development and ETL processes, along with a strong background in software engineering and 10+ years of experience. Candidates...Suggested
- Oasys is seeking a Data Engineer in Fairfax, Virginia, responsible for designing, developing, and maintaining ETL processes to ensure seamless data flow across sources. The ideal candidate will have a Bachelor’s degree, 10+ years in data integration and ETL, and strong...Suggested
$165k - $210k
Steampunk is seeking a Principal Data Solution Architect to lead the design of enterprise data platforms and architectures. This role requires over 10 years of experience with significant architectural leadership and expertise in modern data ecosystems like Databricks....Principal$99k - $225k
Phase2 Technology is seeking a Mission System Data Architect in McLean, Virginia. As a critical member of our national security team, you will... ...The ideal candidate will have experience with data modeling, ETL pipelines, and strong proficiency in SQL, along with a TS/SCI...$165k - $210k
...Overview We are seeking a Principal Data Solution Architect to serve as the senior-most technical authority for end-to-end data architectures, cloud data platforms, integration strategies, and enterprise-scale modernization initiatives. This role operates at the intersection...Principal- ...something special. Halvik is seeking a Senior Data Architect with strong data integration and data migration expertise to join Team 4 (Integration, Data, DevOps... ...-level mappings to Salesforce objects, developing ETL jobs, and executing phased migration sprints with...Permanent employmentContract workWork at officeImmediate startFlexible hours
- ...Data Architect We are seeking a highly skilled and experienced Data Architect to join our team... ...data from multiple sources. Develop ETL (Extract, Transform, Load) processes to... ...architect and is well versed with Data migration architecture to cloud. ~ Technical...Work at office3 days per week
- ...A technology firm is seeking an experienced Data Architect / Data Analyst to assist a federal client in migrating HR IT functions to a new platform. The ideal candidate should have a Bachelor's degree in Computer Science and proven experience in data migration, particularly...Remote work
- ...Job Title: Data Architect Location: Vienna, VA Position Type: Full-time Work... ...and structure production-grade code for ETL/ELT pipelines, data transformations, and... ...systems or experience with legacy system migrations Strong communication and stakeholder...Full timeRelocation package
- ...Data Architect ID 2026-3567 Job Locations US Category Information... ...lineage tracking. ~ Support data migration and transformation from legacy systems,... ...familiarity with data warehousing and ETL design. ~ Understanding of data...Full timeFor contractorsLocal areaRemote work
- ...,700+ team members, 1,500+ AI/data experts, and 100+ prime contracts... ...an immediate need for a Data Architect to lead the design,... ...authoritative artifacts supporting migration and consolidation efforts.... ...and reporting architectures ETL/ELT processes and data pipelines...Temporary workImmediate startWorldwide
$81.5k - $138.55k
...The Work: The Data Architect will design, implement, and govern enterprise... ...controls) Support data migrations and modernization efforts from... ...Ensure compliance with federal IT and security frameworks (e.g.... ...of data modeling techniques, ETL/ELT processes, and data...Full timeContract workWork experience placementWork at officeRemote work- ...Data Architect - Washington, DC About us Creative Information Technology... ...Inc (CITI) is an esteemed IT enterprise renowned for its... .... Architect and implement ETL/ELT workflows using modern... ...Step Functions. Experience migrating workflows and data pipelines...Contract workWork experience placement
- ...Job Description: Data Architect Location: Hybrid - Reston, VA (1-2 days onsite per month)... ...Key Responsibilities Data Migration & Architecture Lead the end-to... ...architectural oversight for database design, ETL workflows, and cloud integration. Troubleshoot...Contract workLocal area
- ...Data Architect With Salesforce.com Experience Acumen Solutions drives... ...Lead data management and migration projects Develop, maintain... ...level knowledge of enterprise IT organizational, business, and... ...with complex coding through ETL tools such as Informatica, SSIS...For contractorsLocal area
- ...Database Architect Location Remote # of openings... ...We are a federal IT company on a... ...expertise in modern data architecture, cloud... ...strategy for cloud migration and modernization initiatives... ...~ Data modeling (OLTP / OLAP) ~... ...Snowflake, Redshift) ETL/ELT tools (...Full timeRemote work
$157k - $235k
...Freddie Mac Enterprise Data Office architecture team is seeking a Data Architect Technical Lead to provide... ...consultation to partners and IT management on technology... ...& AWS Cloud migration hands on experience with... ...platform, security products, ETL products, Data Management...Work at office- Cognito Cyber Groups is seeking a skilled data engineer for their McLean, Virginia office. The ideal candidate will have demonstrated experience with Elasticsearch 7.x, identity resolution capabilities, and distributed data pipeline technologies. In this role, you'll support...Work at office
- The Data Environments and Engineering Department (L176) in the Data and Human Centered... ...concepts in relatable terms Strong knowledge of ETL/ELT processes, tools, and frameworks... ..., or information systems Experience migrating legacy data systems to new/modernized platforms...
- ...ecosystems, leveraging proprietary data and advanced AI to surface... ...government. Cloud Data Architect Role Summary: We are... ...data integration processes using ETL/ELT frameworks for structured,... ...- while planning for gradual migration of workloads to open table...Full timeWork at officeWork from homeFlexible hours2 days per week
- ...Job Title: Sr. Data Architect Location: Reston, VA (Hybrid - 1-2 Days Onsite per Month)... ...Architect to lead the modernization and migration of large-scale data environments from Cloudera... ...architecture aligns with business and IT goals. Troubleshoot performance bottlenecks...Contract workLocal area
$150k - $160k
...Senior Data Architect This is a remote position. Ad Hoc is a technology company that empowers organizations to deliver scalable... ...Senior Data Architect include: Lead complex legacy data migrations end-to-end, including schema mapping, data profiling, phased...Temporary workFor contractorsWork at officeRemote workFlexible hours- ...operations while modernizing IT, optimizing data architectures, and ensuring... ...LLM-based architectures. The architect partners with sales,... ...integration patterns using modern ETL/ELT and cloud-native services... ...on data modernization, cloud migration, AI adoption, platform...Work at officeRemote work2 days per week
- ...Data Architect TLA is seeking an experienced and visionary Data Architect to design, optimize, and oversee our organization's enterprise... ...Optimization: Monitor and optimize data systems, queries, and ETL/ELT processes to ensure high performance, scalability, and cost...
$165k
...We are seeking a highly experienced Data Architect with deep healthcare and Medicaid domain expertise to design, modernize, and govern our... ...relational and NoSQL databases ~ Experience building and supporting ETL/ELT pipelines for high-volume healthcare data ~ Solid...Remote work- ...Stealth Solutions is seeking an experienced Data Architect to lead data modeling, API strategy, and... ...data governance, complex integrations, ETL patterns, and API-led connectivity using... ...compliance frameworks Support data migration strategies, data quality, and...Contract workWork from homeFlexible hours
- ...performance optimization, and data management. In this role, you... ...Responsibilities Design & Implementation: Architect and manage database systems... ...dictionaries; support data migration and transformation activities.... ...Engage in mission-critical IT programs that support national...Immediate start
- ...(including OS & Application virtualization), platform migration, server consolidation, utility computing, and grid computing... ..., Chef, Puppet, or similar) Experience applying data engineering concepts (e.g., ETL, SQL, distributed data processing) in production environments...PrincipalInternshipLocal area
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to IT Principal Data Architect - Data Migration, OLTP, ETL. Be the first to apply!
- senior principal cloud computing engineer Vienna, VA
- principal cloud computing engineer Vienna, VA
- principal Vienna, VA
- test data management Vienna, VA
- data cabling Vienna, VA
- data internship Vienna, VA
- clinical data Vienna, VA
- data intern Vienna, VA
- data recovery Vienna, VA
- data collection researcher Vienna, VA

