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 6 days ago
Similar jobs that could be interesting for youBased on the IT Principal Data Architect - Data Migration, OLTP, ETL in Richmond, VA vacancy
  •  ...~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
  •  ...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... 
    Suggested
    Full time
    Work at office
    Work from home
    Flexible hours
    2 days per week

    Exiger

    Richmond, VA
    1 day 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... 
    Suggested
    Immediate start

    Kinsale Insurance Company

    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... 
    Suggested
    Work from home

    Apex Informatics

    Richmond, VA
    3 days ago
  • $130k - $160k

     ...Data Architect Ascendion is an AI-native software engineering disruptor helping businesses innovate faster, smarter, and with greater impact...  ...We are seeking a hands-on Data Architect with a strong ETL and Data Engineering background to design, build, and optimize... 
    Suggested
    Temporary work

    Ascendion

    Richmond, VA
    1 day 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... 

    CEI

    Richmond, VA
    27 days ago
  • $125.5k - $230.2k

     ...possesses a robust background in Data Architecture, Data...  ...responsibilities will include: As Data Architect – Manager, you will have an...  ..., Business Analysts, and IT teams) to define data requirements...  ...Manage complex data analysis, migration, and integration of enterprise... 
    Summer holiday
    Flexible hours

    EY

    Richmond, VA
    3 days ago
  • $150k - $190k

     ...A leading IT solutions provider in Virginia is seeking a Senior Data Engineer to join their Advanced Solutions Group. The role involves designing ETL workflows, collaborating with teams, and developing data engineering practices. Candidates should have at least 10 years... 
    Full time

    SHI GmbH

    Richmond, VA
    2 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
  •  ...Hybrid Richmond, V Long term contract Design enterprise data models (conceptual, logical, and physical) that enable trusted,...  ...Lucid Chart primary or ER/Studio/ERwin secondary • Databases (OLTP/OLAP): SQL Server, Oracle, PostgreSQL, Snowflake, Azure Synapse,... 
    Long term contract
    Work at office

    PLANIT Group

    Richmond, VA
    23 hours ago
  •  ...Data Architect The Data Architect is responsible for defining the structure, standards, and architectural guardrails that govern service and configuration data within the Service-Aware Operating Model. This role establishes how data should be modeled, related, controlled... 

    Kasmo Global

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

     ...Job Description As a Principal Site Reliability Engineer, you will play a pivotal role in...  ...focus on automation-first operations Data Technologies • Proficiency in Data Warehousing...  ..., Vertica, Snowflake) • Experience with ETL frameworks and large-scale data... 
    Principal
    Temporary work
    Flexible hours

    Oracle

    Richmond, VA
    23 hours ago
  •  ...Data Engineer Strong understanding of Data warehousing (Dimensional Modeling, ETL etc.) and RDBMS concepts Minimum 5 years working experience...  ...and best practices before migration into the production...  ...teams, application teams, and architects to generate process designs... 
    Work experience placement

    Software Technology Inc

    Richmond, VA
    4 days ago
  •  ...believe that when we realize our potential, we can help others reach theirs.Join us and play your part in something special!The Lead Data Architect provides strategic and hands-on leadership across divisional data initiatives, guiding delivery teams in building scalable data... 
    Full time
    Local area
    Work from home

    Markel

    Richmond, VA
    1 day ago
  • $131.3k - $149.8k

     ...Principal Data Analyst - Enterprise Services At Capital One, data is at the center of everything we do. When we launched as a startup we disrupted the credit card industry by individually personalizing every credit card offer using statistical modeling and the relational... 
    Principal
    Full time
    Part time
    Local area

    Capital One

    Richmond, VA
    24 days ago
  • $131.3k - $149.8k

     ...Principal Data Analyst - Card At Capital One, data is at the center of everything we do. When we launched as a startup we disrupted the credit card industry by individually personalizing every credit card offer using statistical modeling and the relational database... 
    Principal
    Full time
    Part time
    Local area

    Capital One

    Richmond, VA
    4 days ago
  •  ...under the direction of Delivery Architects Create proof of concept /...  ...pressure ~ Experience in complex IT project implementations,...  ...tools and methodologies used to migrate mainframe workloads via...  ...Delivery (CD), DevOps, and Test Data Management, etc. Experience... 
    Principal
    Local area
    Remote work
    Worldwide

    Rocket Software

    Richmond, VA
    4 days ago
  •  ...Client is seeking a PL/SQL Developer Cum ETL Developer to join Oracle Development and Enterprise...  ...Integration teams in EDM (Enterprise Data Management). The selected candidate will:...  ...process chains. Develop procedures to migrate these changes or notify business users... 

    My3Tech Inc

    Richmond, VA
    4 days ago
  • $114.6k - $234.6k

     ...GPU clusters. We are working at the forefront of Generative AI (GenAI) landscape working with teams across Oracle on multi-modal data generation and leading the framework across Oracle. Responsibilities Key Responsibilities: Design and develop AI software in... 
    Principal
    Temporary work
    Flexible hours

    Oracle

    Richmond, VA
    1 day ago
  • $115.3k - $264.1k

     ...days from the posting date or as long as the job remains posted. Career Level - IC5 About Us Only Oracle brings together the data, infrastructure, applications, and expertise to power everything from industry innovations to life-saving care. And with AI embedded... 
    Principal
    Temporary work
    Flexible hours

    Oracle

    Richmond, VA
    23 hours ago
  •  ...Development support to include creation of stored procedures or raw SQL Code Data Movement - Provide support in the design, development, and implementation of ETL packages with SSIS. VBA Migration - Take VBA from existing spreadsheets and convert SQL logic to stored... 
    Remote work
    Monday to Friday

    Software Technology Inc

    Richmond, VA
    4 days ago
  •  ...Data Warehouse Developer Seeking a Data Warehouse Developer who can self manage, partner with BSAs and PMs, and translate business...  ...Kimball methodologies, and hands-on development of data marts, SSIS ETL pipelines, and data flow design documentation. The developer must... 

    Accylerate, LLC

    Richmond, VA
    11 hours ago
  • $115.3k - $264.1k

     ...is building the national narrative and local engagement model for one of Oracle's most visible growth areas: data center and AI infrastructure. The Sr Principal Program Manager - Data Center Campaigns will own the operating rhythm for a national campaign that connects campaign... 
    Principal
    Temporary work
    Local area
    Flexible hours

    Oracle

    Richmond, VA
    2 days ago
  • $96.8k - $306.4k

     ...Job Description The Senior Principal AI Agent / ML Software Engineer is a Senior Staff...  ...evaluation, and observability. Design, architect, and deliver scalable agentic AI systems...  .... Define service boundaries, APIs, data models, state management, consistency tradeoffs... 
    Principal
    Temporary work
    Flexible hours

    Oracle

    Richmond, VA
    23 hours ago
  • $109.2k - $223.4k

     ...Senior TPM, you will lead large-scale, cross-functional programs that support billions of dollars in infrastructure investments and data center expansion initiatives. You will help define and operationalize the tooling, governance models, processes, and execution frameworks... 
    Principal
    Temporary work
    Flexible hours

    Oracle

    Richmond, VA
    1 day ago
  • $120.1k - $251.6k

     ...Job Description As Principal Program Manager, Network Infrastructure Deployment & Delivery, you will own the end-to-end execution of OCI's data center network deployment programs, translating capacity demand and engineering designs into delivered, tested, production... 
    Principal
    Temporary work
    Flexible hours
    Night shift

    Oracle

    Richmond, VA
    3 days ago
  •  ...Principal Data Analyst Location: Richmond, VA (hybrid/in-office) YOUR ROLE The Principal Data Analyst will serve as a trusted analytical partner to Long Term Care Claims Operations leadership, translating complex data into clear, compelling insights that shape strategy... 
    Principal
    Work at office

    Genworth

    Richmond, VA
    1 day ago
  •  ...Job Title: Data Modeler Location: Richmond, VA (Hybrid. 3 day onsite) Fulltime only For non-locals there will be relocation assistance: 2k relocation assistance+ one side flight ticket with family+15 days hotel accommodation. *In case, if you are not comfortable... 
    Full time
    Local area
    Relocation package

    Syntricate Technologies

    Richmond, VA
    4 days ago
  •  ...Job ID-ACSXMWN32 Enterprise Data Modeler Location - Richmond, VA (look for nearby candidates only) Interview Type - Both Phone and In Person Work Arrangement- Hybrid (3 days onsite 2 days remote) US Citizen,Greencard Holder,EAD,H4-EAD($75/hr. on... 
    Remote work

    Keylent Inc

    Richmond, VA
    1 day ago
  • $75 per hour

     ...Data Analyst/Cloud ETL Developer (#752580) Client: VA Dept of Transportation Max rate...  ...cloud architecture and will extend or migrate our existing data pipelines to this architecture...  ...partners with Data modeler and Data architect in an attempt to refine the business's... 
    Contract work
    For contractors
    3 days per week

    3B Staffing LLC

    Richmond, VA
    4 days 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!