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 Albany, NY vacancy
  •  ...highly motivated and experienced candidate to serve as an ETL Developer / Data Architect on our Business Intelligence ("BI") team supporting key...  ...development, and testing. ETL environment implementation and migration. Report / Dashboard creation using leading... 
    Suggested
    Flexible hours

    VISTRADA

    Albany, NY
    1 day ago
  • $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

    Albany, NY
    3 days ago
  •  ...Extract Transform Load Developer/Data Warehouse Architect Location: 110 State...  ...with all necessary IT equipment. Work a 40-hour...  ...reviewing and analyzing existing ETL processes, designing data...  ...Consultant will be involved in migrating ETL environments, developing... 
    Suggested
    Work at office
    Monday to Friday

    Tri-Force Consulting Services, Inc.

    Albany, NY
    1 day ago
  •  ...Responsibilities: Lead end-to-end data migrations across multiple Salesforce orgs and...  ...and validation logic. Build custom ETL scripts using Apex, API calls, external...  ...with business analysts, administrators, architects, and stakeholders to gather requirements... 
    Suggested

    CMA Consulting Services, Inc

    Albany, NY
    4 days ago
  •  ..., and system troubleshooting. 84 Months Data Modeling Experience: experience with data...  ...Data Modeler, for designing and maintaining OLTP systems. 84 Months IBM Cognos Analytics...  ...for designing, developing, and executing ETL processes. 60 months IBM Cloud Pak for Data... 
    Suggested

    JSM Consulting

    Albany, NY
    10 hours 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

    Albany, NY
    4 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

    Albany, NY
    1 day ago
  •  ...short description of the Position: Expert Data Modeler working for NYS Information Technology...  ...Off the Shelf (COTS) products, and IT teams to determine and design application and...  ...Identify, recommend and implement ODI/ELT and ETL process and architecture improvements. • Design... 

    Mindlance

    Albany, NY
    3 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

    Albany, NY
    4 days ago
  •  ...Database Architect Expert, Database Architect 30 month contract Interview...  ..., validation, and entry of data from various sources into...  ...monitoring of data pipelines and ETL (Extract, Transform, Load)...  ...approved requests. Support the migration and archiving of data... 
    Contract work
    Work at office
    Remote work

    MVP Consulting Inc

    Albany, NY
    1 day ago
  •  ...is seeking an expert Database Architect to support the redesign and modernization...  ...business analysis, reporting, data governance, and system...  ...includes SQL development, ETL monitoring, data quality management...  ...database backup, restoration, migration, and archiving activities... 

    Siritech Solutions Corp

    Albany, NY
    3 days ago
  •  ...Data Warehouse Developer (Mid-Level Role) Location: Albany,...  ...reports, OBIEE/OAS dashboards, ETL processes, SQL tuning, and supporting...  ...ongoing DW enhancements and migrations. Mandatory Experience...  ...Bachelor's in Computer Science, IT, or Engineering Recruiter... 
    Hourly pay
    Full time
    Contract work
    H1b
    Remote work
    Relocation
    Monday to Friday

    Veracity

    Albany, NY
    2 days ago
  •  ...Senior Data Architect Location: Saratoga Springs / Albany, NY Must have experience working with prior higher education university/clients. This is a critical Phase 1 initiative focused on assessing and documenting the university’s data warehouse environment.... 

    Kaav Inc.

    Albany, NY
    3 days ago
  • $146k - $241k

     ...A leading biopharmaceutical firm is looking for a Principal Data/AI Engineer to drive the strategy and architecture for data and AI platforms. You will architect and maintain scalable data pipelines, implement ML solutions, and collaborate with business and technical teams... 
    Remote work

    FUJIFILM Corporation

    Albany, NY
    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

    Albany, NY
    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

    Albany, NY
    3 days ago
  •  ...integration initiatives. The role requires strong expertise in databases like PostgreSQL, security compliance, and experience in building ETL frameworks. Qualified candidates will have a Bachelor's in a relevant field, 3+ years of database experience, and familiarity with... 

    Inside Higher Ed

    Albany, NY
    10 hours ago
  • A leading computing company is seeking a Senior Consultant in Data Governance. This role will involve working with data teams to develop and execute data governance frameworks across various business areas. The ideal candidate will boast over 7 years of relevant experience... 
    Remote work

    IBM Computing

    Albany, NY
    3 days ago
  • A leading consultancy firm seeks a Senior Manager in Data Architecture for the Power & Utilities Sector. The role requires deep expertise in data architecture, AI solutions, and cloud technologies. The candidate will lead transformative projects, optimize data strategies... 

    Ernst & Young Oman

    Albany, NY
    2 days ago
  • A leading technology firm is seeking a Principal Solution Consultant in Albany, NY. This role involves designing and developing enterprise solutions based on data and identity capabilities. Candidates should have over 5 years of experience in Ad Tech, Martech, or Identity... 

    Acxiom

    Albany, NY
    2 days ago
  • $97.5k - $199.5k

     ...insights via dynamic visualizations, and enabling collaborative, data-driven improvement projects across the enterprise....  ...Federal Security Clearance. Responsibilities As a Senior Data Architect on the Oracle Health Advance research and development team, you... 
    Temporary work
    Work experience placement
    Flexible hours

    Oracle

    Albany, NY
    1 day ago
  • A global consulting firm is seeking a Senior Manager in Data Architecture for the Power & Utilities Sector. This position requires a strong background in data architecture and extensive experience in cloud solutions, AI, and data modernization. The successful candidate... 

    Ernst & Young Oman

    Albany, NY
    2 days ago
  •  ...Database Architect Location: Menands, NY, 12204 Duration...  ...experience in database design, data modeling, data hosting, data warehouse...  ...OBIEE experience Data migration tools knowledge bout Us:...  ...experience in providing IT Consulting Services, Artificial... 
    Contract work

    InterSources

    Menands, NY
    4 days ago
  •  ...Principal Systems Analyst Anywhere Type: Contract Category: Business Analysis...  ...modernization of brokerage, trading, reporting, and data processing systems to AWS. The role...  ...APIs, data movement, reporting, and migration from legacy mainframe platforms. Due... 
    Principal
    Hourly pay
    Contract work
    Local area
    Remote work

    Eliassen Group

    Albany, NY
    6 days ago
  •  ...functions which include the development, support, and optization of data related functions within the new NYS Unemployment Insurance...  ...questions and troubleshooting issues. Data Warehousing (Oracle): ETL Monitoring: Monitor the execution of ETL (Extract, Transform, Load... 
    Night shift
    Day shift

    Mindlance

    Albany, NY
    1 day ago
  • A technology services firm based in Albany is seeking an experienced ETL Developer / Data Architect for their Business Intelligence team. This role involves designing and developing analytics data warehouse architecture and implementing ETL environments to meet clients... 

    VISTRADA

    Albany, NY
    10 hours ago
  • $99.6k - $223.4k

     ...skilled AI engineers to design and build high-scale, cloud-based data processing pipelines that ingest, transform, and analyze massive...  ...Strong knowledge of SQL. • Deep expertise in data engineering: ETL, data transformation, data modeling (Spark, SQL) • Experience building... 
    Principal
    Temporary work
    Flexible hours

    Oracle

    Albany, NY
    3 days ago
  • $99.6k - $223.4k

     ...Exadata Database Machine is the only database appliance in the industry that is capable of providing extreme performance for data warehousing, OLTP and consolidated workloads. Built using database and storage software from Oracle and industry standard hardware from Sun/... 
    Principal
    Temporary work
    Flexible hours

    Oracle

    Albany, NY
    1 day ago
  • $106.9k - $176.5k

    AI & Data - Data Modeler - Senior Location: Anywhere in Country At EY, we’re all in to shape your future with confidence. We’ll help you...  ...(STM) documentation and data transformation specifications for ETL/ELT developers, including all SCD Type 2 logic and surrogate key... 
    Summer holiday
    Flexible hours

    EY

    Albany, NY
    10 hours ago
  • A leading global professional services firm is seeking a Data Architect - Manager to drive transformative technology projects in the Power & Utilities sector. The ideal candidate will have over 8 years of experience in data architecture and engineering, with a strong background... 

    EY

    Albany, NY
    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!