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
- ...~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
- ...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...SuggestedFull timeWork at officeWork from homeFlexible hours2 days per week
$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...SuggestedImmediate start- ...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...SuggestedWork from home
$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...SuggestedTemporary work- ...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...
$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 holidayFlexible hours$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$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...PrincipalTemporary workFlexible hours- ...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 contractWork at office
- ...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...
$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...PrincipalTemporary workFlexible hours- ...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
- ...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 timeLocal areaWork from home
$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...PrincipalFull timePart timeLocal area$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...PrincipalFull timePart timeLocal area- ...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...PrincipalLocal areaRemote workWorldwide
- ...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...
$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...PrincipalTemporary workFlexible hours$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...PrincipalTemporary workFlexible hours- ...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 workMonday to Friday
- ...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...
$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...PrincipalTemporary workLocal areaFlexible hours$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...PrincipalTemporary workFlexible hours$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...PrincipalTemporary workFlexible hours$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...PrincipalTemporary workFlexible hoursNight shift- ...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...PrincipalWork at office
- ...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 timeLocal areaRelocation package
- ...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
$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 workFor contractors3 days per week
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!
- data integration architect Richmond, VA
- data architect Richmond, VA
- database designer Richmond, VA
- data center architect Richmond, VA
- senior principal cloud computing engineer Richmond, VA
- senior principal scientist Richmond, VA
- principal cloud computing engineer Richmond, VA
- associate principal Richmond, VA
- principal financial analyst Richmond, VA
- principal Richmond, VA


