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
- ...building a modern, intelligent data ecosystem that powers world‑... .... We are seeking a Principal Data Architect for our Enterprise Data group... ...Partner with Cybersecurity and IT to define access models, data... ...Hands-on experience with ELT/ETL frameworks, real-time/streaming...PrincipalTemporary work
- ...month contract to start with likely extensions Overview We are seeking an experienced Enterprise Data Architect to support a large-scale platform migration and enterprise data migration initiative . This role will focus on designing scalable cloud data architectures...SuggestedContract workRemote work
- ...Data Architect(ETL, SQL exp)_Columbus OH We are based in Fremont, California that offers complete technology services in IT staffing, Mobile development, Web development and Cloud computing. We work along with its clients to deliver high-performance results, based...Suggested
- ...A technology consulting firm is seeking an experienced Enterprise Data Architect to support platform migration and enterprise data migration initiatives. The role involves designing scalable cloud data architectures, focusing on SaaS data transformation and modern cloud...SuggestedRemote work
- ...Data Architect Position Details: Job Title: Data Architect Location: Columbus, OH 432... ...development, implementation and use of Data/ETL/BI solutions within the enterprise. •... ...and implementing ETLs and data migrations • Strong skills in modeling data for modern...Suggested
$134.1k - $201.2k
...Stantec every day.???? Senior Data Architect We are seeking a Senior... ...with other teams - including IT Infrastructure & Operations,... ...This includes coordinating data migration efforts during EBS upgrades... ...Oracle Data Integrator (ODI) for ETL tasks, and Oracle REST/SOAP...Full timeTemporary workPart timeCasual work- ...Job Title: Principal Engineer I - Senior Data Engineer Location: Block 23... ...data engineers, enterprise architects, and business stakeholders... ...strategy and roadmap. Develop ETL and data pipeline... ...Support and influence the migration from Azure Synapse to Microsoft...Principal
- ...Job Title: Senior Data Architect Work Location: On-site 4 days per week in Columbus, OH About Us: Step into... ...teams to deliver. Support Modernization: Help drive the migration from Angular to React while working with Java Spring Boot microservices...
$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...PrincipalRemote workWorldwide- ...technology solutions provider in Columbus, Ohio, is seeking a skilled data architect to drive the design of an Enterprise Data Warehouse. The ideal... ..., modeling data for modern systems, and implementing ETL processes. Responsibilities include creating data mapping for...Contract work
$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- ...Title Required Skills: ~7 years or more experience working in Data warehousing system ~ At least 2-3 years of experience in Working with Informatica ~ Good understanding of data warehouse and ETL concepts ~ Very strong in SQL programming Teradata - SQL,...
- ...I have an opportunity for "GCP Data Architect" and looking for a candidate who can join Immediately if you are interested reply me with... ...Teradata, Tableau, Qlik or MicroStrategy. • Customer facing migration experience, including service discovery, assessment, planning...Contract workImmediate start
- ...Microsoft Fabric Data Architect We are seeking an experienced and highly motivated Microsoft Fabric Data Architect to join our team at... ...initiatives by building reusable IP such as reference implementations, migration guides, and architectural frameworks. Collaborate with...Work at officeHome office
$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 holidayFlexible hours$79.79k - $93.87k
...OPERS & Ohio Deferred Compensation POSITION SUMMARY COTA's Data Architect defines and advances the enterprise data architecture strategy... ...standards and compliance obligations. Lead large scale data migration initiatives from legacy environments to cloud or hybrid architectures...- ...Are you a skilled data professional with a passion to transform raw data into actionable... ...the future. As a Data Domain Architect - Sr. Associate in the CCB Finance Data... ...business intelligence tools Work with IT to migrate to production the developed solutions...Work experience placementWork at office
- ...Lead Data Architect Join a diverse team of visionaries dedicated to making a lasting impact in the Card Technology industry. As a... ...maintain conceptual, logical, and physical data models to support migration requirements and ensure data integrity Establish and...
- ...Database Engineer (SQL/AWS/ETL) Location : Columbus, OH - 299684 hybrid (3 days onsite 2 days WFH) Experience :8 +... ...DBMS knowledge on SQL server - Postgres (Oracle) - Must have good data modeling experience - will be working with architecture team to...Work from home
- ...Data Solution Architect Columbus, OH This role will be responsible for providing solution architecture, configuration details and conduct proof... ...development environment is a plus. ~10+ years of strong ETL experience on either Informatica, Ab-Initio, SSIS, Talend, or...
- ...Data Domain Architect Lead - VP Join the Customer Loyalty Analytics Team within Consumer & Community Banking Data & Analytics and help shape... ...Broad expertise in data technologies such as data warehousing, ETL, data quality concepts, business intelligence, analytics...
- ...positions become available. Columbus is looking for a Principal Technical Architect, D365 (CRM/CE) to join our growing team. In this... ...Integration Design D365 FO Dual Write Integration Data Migration Planning/Design Power Platform Development This is...PrincipalFull timeTemporary workRemote work
$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...PrincipalTemporary workWorldwideFlexible hours- ...Data Domain Architect Lead Are you a skilled data professional with a passion to transform raw data into actionable insights, and a demonstrated... ...support their analytical and reporting needs Work with IT to migrate to production the developed solutions and as an SME/...Work experience placementH1bWork at officeLocal areaImmediate startRelocationWork visaRelocation package
- ...We are seeking a Principal Data Engineer to drive scalable, business-focused data solutions that power insight-driven decision-making across... ...-cloud environments . Familiarity with orchestration and ETL tools (e.g., Airflow, Informatica, Matillion). Experience...PrincipalLocal areaRemote work
- ...Senior Principal Software Engineer If you are looking for a game-changing career, working... ...the implementation of critical paths, migrations, and reliability fixes. Establishes repeatable... ...security/resiliency implications, data sensitivity, and risk-based governance;...Principal
$93k - $189k
...Senior Google Cloud Data Architect We are seeking an exceptional Senior Google Cloud Data Architect who is passionate about building world... ...power the enterprise. This is not a generic architect role — it is a high influence, high ownership opportunity to help define...Work at officeRemote workWork from homeFlexible hours$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...PrincipalTemporary workFlexible hours$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- ...business capabilities. As a Principal Engineer, you’ll... ...Access Management (IAM) data platforms and applications... ...of leading large-scale migrations from on-prem to cloud-... ...modernization and ETL processes. Experience with... ...Google Professional Cloud Architect (or Data Engineer/...PrincipalFull timeWork experience placementWork at officeVisa sponsorship3 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!
- sr data modeler Columbus, OH
- data architect Columbus, OH
- remote data architect Columbus, OH
- data center architect Columbus, OH
- database designer Columbus, OH
- data integration architect Columbus, OH
- senior data architect Columbus, OH
- senior data modeler Columbus, OH
- senior principal cloud computing engineer Columbus, OH
- senior principal scientist Columbus, OH


