Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

IT Principal Data Architect - Data Migration, OLTP, ETL

$156.64k

MAXIMUS

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

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the IT Principal Data Architect - Data Migration, OLTP, ETL in Richmond, VA vacancy
  • $142k

     ...Job Description : JOB SUMMARY We are seeking a hands-on Principal Data Architect to serve as a leader in our ongoing data and digital...  ...practices and emerging technologies (ie lakehouse, iceberg, ELT vs ETL, and open source trends and tradeoffs), driving innovation... 
    Principal
    Temporary work
    For contractors
    Work at office
    Local area
    Remote work

    Highmark Health

    Richmond, VA
    3 days ago
  •  ...databases. The ideal candidate must have over 7 years of hands-on experience with Oracle, along with significant expertise in data architecture and ETL tools. Excellent communication skills and the ability to collaborate effectively in a fast-paced environment are essential... 
    Suggested

    NN Tech, LLC

    Richmond, VA
    3 days ago
  •  ...~5+ years serving in a data architecture position is...  ...building data flows using ETL tools is required. Azure...  .... ~ Ability to architect and model mission critical RDMS, BI, OLTP, OLAP and solutions leveraging...  ...Intelligence, Cloud Migration, Custom Software Development... 
    Suggested

    InterSources

    Richmond, VA
    4 days ago
  •  ...: 7+ years experience in data architecture, data engineering...  ...Strong SQL and ELT/ETL framework experience Cloud...  ...-CD frameworks Experience migrating from on-prem (Oracle) to cloud...  ...Insight Global is seeking an IT Architect – Data & Snowflake for a leading... 
    Suggested
    Local area
    Remote work

    Insight Global

    Richmond, VA
    19 hours ago
  • ## Data ArchitectApplylocations: Richmondtime type: Full timeposted...  ...requisition id: R014701**Data Architect**The Data Architect is...  .... This includes defining data migration scope, ensuring data quality frameworks...  ...platforms (data warehouse, ETL/ELT, integration layers)* Ability... 
    Suggested
    Permanent employment
    Temporary work
    Immediate start

    Mecca Brands

    Richmond, VA
    19 hours ago
  •  ...Job Description Job Description Solutions Architect – Data & Snowflake Hybrid: Richmond, VA  23219 $80.00 /hr W2 Required Skills...  ...schemas, data vault, semantic layers). Proficiency in SQL, ELT/ETL frameworks, and cloud data services (Azure/AWS). Experience... 
    Full time

    CEI

    Richmond, VA
    15 hours ago
  • $3,600 per month

     ...Are you an experienced data leader ready to architect the future of enterprise-scale data platforms? Join...  ...dimensional, star/snowflake, data vault) and OLTP (normalized, ERD-driven) workloads....  ...Collaborate with IT, Security, Compliance, and Audit teams... 
    Immediate start

    Kinsale Insurance Company

    Richmond, VA
    4 days ago
  • $114.5k - $154.58k

     ...We're looking for a Principal Sales Engineer who is not...  .... This role centers on migrating mainframe workloads to...  ...clients to understand their data integration challenges,...  ...technologies (ETL, CDC) expertise is advantageous...  ...information and IT Resources over which they... 
    Principal
    Remote work
    Worldwide

    Rocket Software

    Richmond, VA
    4 days ago
  •  ...experience in architecture, design or development of enterprise data solutions, applications, and integrations ~ Experience creating...  ...and unstructured data principles ~ Good knowledge in various ETL tools and data sanitization ~ Proven analytical skills... 
    Work from home

    Apex Informatics

    Richmond, VA
    3 days ago
  • $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

    MAXIMUS

    Richmond, VA
    1 day ago
  •  ...Data Architect (Permanent /Full Time) Tech Tammina LLC Job Description Relevant Experience (Yrs): 8+ years Technical/Functional...  ...active role in the cross-functional design and coordinate with ETL and reporting teams Work closely and foster strong... 
    Permanent employment
    Full time

    Tech Tammina

    Richmond, VA
    4 days ago
  •  ...Lead Data Architect This position supports Revolutional's federal customer as part of an application transformation and modernization initiative...  ...requirements Design and manage large-scale data ingestion, ETL/ELT pipelines, transformation workflows, analytics, and... 
    For contractors

    Harmonia | Revolutional

    Richmond, VA
    4 days ago
  • $144k - $329.1k

     ...better working world. AI & Data - Data Architecture – Senior Manager...  ...will include: As Data Architect – Senior Manager, you will...  ...Scientists, Business Analysts, and IT teams) to define data...  ...Manage complex data analysis, migration, and integration of enterprise... 
    Summer holiday
    Flexible hours

    EY

    Richmond, VA
    4 days ago
  •  ...Job Title: Data Architect / SQL Database Administrator ONSITE Downtown, Richmond, VA (1 day remote)  Location: Richmond, VA (On-site...  ...plans, index optimizations, and performance-tuning strategies. ETL & Reporting Support Design, develop, and maintain ETL... 
    Full time
    Remote work

    Triumph

    Richmond, VA
    1 day ago
  •  ...databases along with building out new databases and data integrations as per project requirements....  ...years experience building data flows using ETL tools is required. Ability to architect and model mission critical RDMS, BI, OLTP, OLAP and solutions leveraging multiple DBMS... 

    NN Tech, LLC

    Richmond, VA
    3 days ago
  •  ...Senior Data Engineer/Architect Our client, a forward thinking insurance company, is seeking a talented Senior Data Engineer/Architect to join...  ...glossary Develop and optimize Extract, Transform, Load (ETL) processes to extract data from various sources, transform... 
    Permanent employment
    Casual work
    Flexible hours

    Key Choice Group

    Richmond, VA
    1 day ago
  •  ...Principal Data Engineer As a Principal Data Engineer, you will design, build, and maintain...  ...platforms Build and maintain robust ETL/ELT pipelines using Azure Data Factory and...  ...analytics and reporting. Collaborate with architects to define data lakehouse architecture... 
    Principal
    Work experience placement
    Local area

    BHE Renewables

    Richmond, VA
    19 hours ago
  •  ...the future of how work gets done. We are looking for a Principal Solution Engineer who is accustomed to solving customer's...  ...range of experience within large-scale Database and/or Data Warehouse technology, ETL, analytics and cloud technologies. For example, Data Lake... 
    Principal

    Snowflake Computing

    Richmond, VA
    4 days ago
  •  ...candidate to join our talented Team. Job Title: Associate Manager Data Architect Location: Richmond, VA (Hybrid) Key Responsibilities:...  ..., database design, and data warehousing. Skilled in ETL tools, data integration, and pipeline design; proficient in... 

    Ampcus

    Richmond, VA
    3 days ago
  • $99.6k - $223.4k

     ...technologies and OCI’s cloud-native AI/ML and data infrastructure. This platform introduces...  ...for both patients and clinicians. As Principal Member of Technical Staff, you will play...  ...Orchestration, including experience with ETL/ELT tools, data processing frameworks... 
    Principal
    Temporary work
    Worldwide
    Flexible hours

    Oracle

    Richmond, VA
    1 day ago
  •  ...Role: Business Data Management Architect Location: Richmond, VA Duration: 7+ months (extendable) Interview: In Person Only Hybrid Schedule - Long-Term position requires 3 days a week Job Description: The VDOT Program Manager - Business Data Management... 
    3 days per week

    Apollo ITS

    Richmond, VA
    1 day ago
  •  ...Data Architect The Virginia Department of Transportation's Information Technology Division is seeking a team member to function as a Data...  ...implementation methodologies ~ Ability to work with business as well as IT stakeholders ~ Minimum of 5+ years of experience designing... 

    My3Tech Inc

    Richmond, VA
    4 days ago
  •  ...High degree of influence of data product direction and has ownership...  ...Purpose of the role Senior Principal Engineers partner with Engineers and Solution Architects to develop solutions and implement...  ...technologies. These should include [ETL/ELT, data replication/CDC,... 
    Principal
    Full time
    Work experience placement
    Work at office
    2 days per week

    CarMax

    Richmond, VA
    2 days ago
  • $109.2k - $223.4k

     ...Job Description Oracle Health Data Intelligence (HDI) is seeking a highly technical Senior Principal Technical Program Manager (IC5) to lead large-scale cloud transformation and migration initiatives supporting critical federal healthcare programs. This role is focused... 
    Principal
    Temporary work
    Flexible hours

    Oracle

    Richmond, VA
    3 days ago
  • $115.3k - $264.1k

     ...outcomes at scale. The successful candidate will demonstrate a strong data-driven mindset, using metrics and insights to guide decisions,...  .... • Demonstrated experience driving cloud transformation, migration, modernization, or platform initiatives. • Experience... 
    Principal
    Temporary work
    Flexible hours

    Oracle

    Richmond, VA
    2 days ago
  •  ...Data Architect This position requires experience in data strategy, data and analytics governance, data modeling, data architecture, data...  ...consumed, integrated and managed by different data entities and IT systems, as well as any applications using or processing that data... 
    Contract work

    Orbis Corporation

    Richmond, VA
    7 days ago
  •  ...Technology Division is seeking a senior Data modeler to develop Data models for Data...  ...systems and working with a business and data architect to create conceptual data models , data...  ...Artificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics... 

    InterSources

    Richmond, VA
    4 days ago
  • $144k - $329.1k

    A global consulting firm is seeking a Senior Manager in Data Architecture, focused on the automotive and aerospace sector. This role involves designing and implementing data solutions, leading teams, and engaging with clients to solve complex challenges. Candidates should... 

    Ernst & Young Oman

    Richmond, VA
    4 days ago
  • A global consulting firm is seeking a Senior Manager in Data Architecture to lead transformative projects in the utilities sector. Key responsibilities include managing complex data architecture initiatives, mentoring data teams, and crafting innovative data solutions... 
    Flexible hours

    Ernst & Young Oman

    Richmond, VA
    3 days ago
  •  ...Data Architect Dominion Energy is seeking an experienced Data Architect to help design and evolve an enterprise level data platform that supports current business needs and future solutions. The platform already exists, but this role will focus on architecting enhancements... 

    Saxon Global

    Richmond, VA
    1 day ago

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!