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
- 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
$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...Suggested- ...success. Credence has an immediate need for a Data Architect who will lead the design, integration,... ...as authoritative artifacts supporting migration and consolidation efforts. Documentation... ...warehousing and reporting architectures ETL/ELT processes and data pipelines...SuggestedTemporary workImmediate startWork from home
- ...We are seeking a Senior Data Architect to lead the design and evolution... ...oversee the build of automated ETL/ELT pipelines using Python,... ...Experience designing for both OLTP and OLAP workloads. Familiarity... ...). Project Experience: Migrating legacy data infrastructure to...SuggestedContract 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
- ...cluster implementation, index design, and data ingest. Demonstrated experience... ...experience with distributed data pipeline / ETL technologies, including designing data flows... ...Sponsor-specific experience as a Data Layer Architect focused on fusion of hybrid data sources...Work experience placement
- Overview The Database Architect Senior provides the data and technical expertise to support... ...in computer science or IT related degree with 7 years... ...enterprise architecture and ETL Seven (7) years of data modeling... ...Transaction Processing (OLTP), Online Analytical...Temporary workWork at officeImmediate startFlexible hours
- ...focused on building and integrating data solutions in Informatica IDMC.... ...solutions Develop ETL/ELT pipelines using Informatica... ...on-prem systems during cloud migration Must-Have Requirements... ...(NOT looking for managers or architects) Strong in integration-first...Flexible hours
- ...Data Solutions Architect We are seeking a Data Solutions Architect to join our team of qualified, diverse individuals supporting a Federal Government... ...should possess deep technical expertise in database design, ETL (OWB/ODI), reporting, and analytics and previous consulting...
- ...opportunity for a Senior Database Architect to join our team in... ...enterprise‑grade data platforms across Azure and... ...scalable data pipelines and ETL/ELT frameworks using... ...data models supporting OLTP and OLAP workloads, including... ...applications, Health IT and Portfolio and...Permanent employmentTemporary workWork at officeLocal areaRemote work
- ...Required Skills: 8+ Year experience Hands on Experience on IBM Manta and should have worked on data lineage responsible for developing and maintaining ETL jobs using IBM DataStage to load data into the data warehouse. Hands-on experience on Informatica Intelligent...
- Strategio Inc. is seeking a Senior Data Engineer in McLean, VA (Hybrid) to design and optimize... ...data pipelines and support cloud data migration initiatives. The ideal candidate brings... .... Responsibilities include building ETL pipelines and collaborating with cross-functional...
- Snowflake Data Architect with Cortex Choosing Capgemini means choosing a company where you will... ...(conceptual, logical, physical), ETL/ELT patterns, and cloud data platforms (... ...initiatives Provide technical leadership in migrations to Snowflake from legacy systems (e.g.,...Full timeLocal area
$144k - $329.1k
...a better working world. AI & Data - Data Architecture – Senior Manager... ...will include: As Data Architect – Senior Manager, you will have... ...Scientists, Business Analysts, and IT teams) to define data... ...Manage complex data analysis, migration, and integration of enterprise...Summer holidayFlexible hours- Guidehouse in McLean, Virginia is seeking a Junior Data Engineer to assist in building and operating automated metadata harvesting pipelines... ...to validate results, and supporting implementation/testing for ETL workflows. Candidates must have a Bachelor's degree and...
- ...Description Job Description Data Architect – Washington, DC About us... ...Inc (CITI) is an esteemed IT enterprise renowned for its... .... Architect and implement ETL/ELT workflows using modern data... ...Functions. Experience migrating workflows and data pipelines...Contract workWork experience placement
$99k - $225k
Mission System Data Architect For an organization to transform in today's digital world, it needs to properly collect, store, and organize... ...SQL and near real‑time data streaming to design data models, ETL pipelines, metrics collection and reporting, and leverage AI to...Local area- ...Position Overview SteerBridge is seeking a Data Architect (Mid-Level) to support operations and... ...and data models Develop and optimize ETL/ELT pipelines supporting analytics and... ...reliability Support modernization efforts and migration of legacy data environments Benefits...
$99k - $225k
## Mission System Data ArchitectApplylocations: McLean, VA: Chantilly, VAtime type: Full... ...id: R0239398Mission System Data Architect**The Opportunity:**For an organization to... ...streaming to design data models and standards, ETL pipelines, metrics collection and reporting...Full timeContract workPart timeWork at officeLocal areaRemote work- ...SOFTWARE ENGINEER SR PRINCIPAL GDIT is seeking a Principal Software Engineer to join our team... ...and operation of a high‑performance big data system, and join a longstanding, stable program... ...with database technologies, SQL, ETL, indexing and performance including contextual...PrincipalWork experience placementRemote work
- ...solutions that align with the organization's IT and business strategies. As the... ...and service operations workflows. Lead data migration activities to transform and migrate ITSM... ...aligned with business goals. Collaborate with architects and stakeholders for architectural...Principal
$80k - $128k
...Peraton is seeking a Data Engineer with AI experience... ...strategies for data migration, data cleansing, normalization... ...platform. Implement ETL/ELT solutions using... ...closely with architects, system developers, business... ...transformative enterprise IT provider, we deliver trusted...Contract workShift work$135k - $160k
...to join our team as a Senior Data Engineer to align data solutions... ...Experience designing for both OLTP and OLAP workloads.... ...Strong Python development for ETL – modular, testable, reusable,... ...movement. Project Experience: Led migration of legacy ETL workflows and data...Contract workWork at officeLocal area3 days per week- ...Cloud Data Architect Location: Reston, VA (Remote we need Local) Duration: 6-12+ Months Notes: Cloud Data Architect role... ...and architecture implementation experience with AWS Cloud Migrating on perm application to AWS cloud Must have exposure in Data...Permanent employmentLocal areaRemote work
$99k - $225k
Booz Allen Hamilton is looking for a Mission System Data Architect in McLean, VA. This role involves leading the design of data architecture... ...teams. Candidates should have experience in data modeling, ETL/ELT pipelines, knowledge of relational and non-relational databases...- ...Strategio - Senior Data Modeler - Hybrid, McLean, VA The Opportunity: We are looking for a Senior Data Modeler to help architect and optimize data structures that power complex financial... ...understanding of data integration and ETL processes. You communicate effectively...
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 Vienna, VA
- data analysis part time Vienna, VA
- data collection researcher Vienna, VA
- test data management Vienna, VA
- data network cabling Vienna, VA
- data tech Vienna, VA
- sap master data Vienna, VA
- data collection Vienna, VA
- clinical data coordinator remote Vienna, VA

