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

MAXIMUS

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

EEO Statement


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.


Pay Transparency


Maximus compensation is based on various factors including but not limited to job location, a candidate's education, training, experience, expected quality and quantity of work, required travel (if any), external market and internal value analysis including seniority and merit systems, as well as internal pay alignment. Annual salary is just one component of Maximus's total compensation package. Other rewards may include short- and long-term incentives as well as program-specific awards. Additionally, Maximus provides a variety of benefits to employees, including health insurance coverage, life and disability insurance, a retirement savings plan, paid holidays and paid time off. Compensation ranges may differ based on contract value but will be commensurate with job duties and relevant work experience. An applicant's salary history will not be used in determining compensation. Maximus will comply with regulatory minimum wage rates and exempt salary thresholds in all instances.


Accommodations
Maximus provides reasonable accommodations to individuals requiring assistance during any phase of the employment process due to a disability, medical condition, or physical or mental impairment. If you require assistance at any stage of the employment process-including accessing job postings, completing assessments, or participating in interviews,-please contact People Operations at View email address on click.appcast.io .


Minimum Salary


$


156,640.00


Maximum Salary


$


234,960.00
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the IT Principal Data Architect - Data Migration, OLTP, ETL in Pittsburgh, PA vacancy
  •  ...Enterprise Data Architect Location: Remote (Must be available during...  ...experience with data modeling, ETL, Azure Data Factory, Data Lake...  ...management, data governance, OLTP systems, AI-ready data...  ...tools, data mapping, profiling, migration, and system integration strategies... 
    Suggested
    Contract work
    Remote work

    3B Staffing LLC

    Pittsburgh, PA
    4 days ago
  •  ...has an immediate need for an Enterprise Data Architect. Ideal candidates must have 10+ years of...  ...Identify opportunities for data reuse, migration, or retirement, and resolve data issues...  ...Data Management, data integration, and OLTP database solutions A comprehensive understanding... 
    Suggested
    Full time
    Contract work
    Temporary work
    Immediate start
    Remote work

    A.C.Coy Company

    Pittsburgh, PA
    4 days ago
  •  ...contribute to the company's success. As a Software Engineer Principal (Oracle/ ETL/ Data Warehousing) within PNC's Wealth Management organization,...  ...as Salesforce and Oracle Siebel. -Align to business and IT priorities by effectively leveraging waterfall, iterative and... 
    Principal
    Full time
    Temporary work
    Part time
    Work experience placement
    Work at office

    PNC

    Pittsburgh, PA
    1 day ago
  • $130k - $190k

     ...Senior Data Architect Eaton's Corporate Sector division is currently seeking a Senior...  ...responsible for working in partnership with Principal Data Architect, IT value stream groups and business...  ...in supporting data integration (ETL/ELT) and data quality frameworks.... 
    Suggested
    Relocation

    Eaton Plc

    Coraopolis, PA
    5 days ago
  •  ...Job Title- Senior Data Architect Duration: 9 Months (initial budget through July 2026) - potential for conversion if candidate...  ...concerning data privacy and security. • Support the creation of migration strategies for transitioning from legacy payment... 
    Suggested

    campus4tech

    Pittsburgh, PA
    1 day ago
  •  ...Description Job Description Microsoft Fabric Data ArchitectPosition Overview We are...  ...highly motivated Microsoft Fabric Data Architect to join our team at ivision. In this...  ...reusable IP such as reference implementations, migration guides, and architectural frameworks.... 
    Work at office
    Home office

    iVision Scale LLC

    Pittsburgh, PA
    2 days ago
  •  ...Strategy Define and continuously evolve the data architecture across the Digital Products...  ...frameworks. Act as the bridge between architects, SME/Analysts, data engineers, and...  ...Delivery Design and implement modern ELT/ETL pipelines using tools like Spark, Python,... 

    Insight Global

    Pittsburgh, PA
    2 days ago
  • $80k - $194.35k

     ...contribute to the company’s success. As a Data Architect Sr within PNC's Retail Architecture...  ...warehouses, with flexible and scalable data and ETL architecture, to support business users...  ...integration for the enterprise. Works with IT and business customers to develop... 
    Full time
    Temporary work
    Part time
    Work experience placement
    Work at office
    Flexible hours

    PNC

    Pittsburgh, PA
    5 days ago
  •  ...Data Architect Location:Pittsburgh PA Fulltime Must Have Technical/Functional Skills: Database design, data modeling, data warehousing, SQL, ETL processes, cloud technologies, data mining. Programming languages like Python... 
    Full time

    SARIAN Co

    Pittsburgh, PA
    4 days ago
  •  ...immediate opening for a Senior Databricks Architect . The primary focus of this role...  ...of designing and building robust data platforms in complex environments. Experience...  ...platforms (AWS, Azure, or GCP) Develop migration strategies from legacy data platforms to... 
    Immediate start

    eNGINE

    Pittsburgh, PA
    3 days ago
  • $120k - $130k

     ...Data Architect Location: Pittsburgh, PA / Strongsville, OH Duration: Fulltime Salary Range: $120,000-$130,000 a year Job Description...  ..., scalability, and maintainability. Support data integration, ETL/ELT, and reporting initiatives with clear architectural guidance... 
    Full time

    Diverse Lynx

    Pittsburgh, PA
    4 days ago
  •  ...Job Description Title: Data Architect Reports To : Director - Data Engineering Location: Pittsburgh, PA or New York, NY...  ...design and implementation of our enterprise data architecture and ETL frameworks supporting our modern data warehouse in Google Cloud... 
    Full time
    Part time
    Summer work
    Casual work
    Local area
    Immediate start

    American Eagle Outfitters

    Pittsburgh, PA
    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

    Pittsburgh, PA
    5 days ago
  •  ...SQL Developer With ETL Location: Pittsburgh, PA Key Skills ~8+ years in Oracle / PL-SQL database development ~ Strong hands...  ..., functions, and cursors ~ Experience with ETL tools & data pipelines ~ Background in upgrade & transformation projects ~... 

    SWITS DIGITAL Private Limited

    Pittsburgh, PA
    4 days 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

    Pittsburgh, PA
    5 days ago
  •  ...Role: Data Engineer / Architect Location: Pittsburgh, PA (Hybrid) Duration:Long Term...  ...work closely with data scientists, and IT teams to ensure data reliability and actionable...  ...) and Engineer workflows for efficient ETL/ELT processing and data validation.... 

    Pacer Group

    Pittsburgh, PA
    2 days ago
  •  ...Experience: 6-10 years Mandatory Experience Experience required in SQL Server (2008 to present) Experience required in ETL Experience required in SSIS Experience required in SSRS Experience required in ASP.NET (ASP.NET MVC, ASP.NET Web Pages, ASP.... 

    Omni Inclusive

    Pittsburgh, PA
    2 days ago
  •  ...Sr ETL Developer Location: Strongsville, OH/Pittsburgh, PA/Dallas, TX Duration: Full Time Job Description: ETL Informatica...  ...years of experience. Need extensive knowledge to develop ETL data flows using Informatica Power center for data integration from... 
    Full time

    JConnect Infotech

    Pittsburgh, PA
    5 days ago
  •  ...V2Soft is a global leader in IT services and business solutions, delivering innovative and cost-effective technology solutions worldwide...  .../developing J2EE based web-applications Prior experience Architecting J2EE & Core Java based applications. Expert in Design and... 
    Local area
    Worldwide
    Shift work

    V2soft

    Pittsburgh, PA
    2 days ago
  •  ...Angular JS) Expert in designing/developing J2EE based web-applications (JSP, Servlets, JSF, XSLT, XML) Prior (hands-on) experience Architecting J2EE & Core Java based applications. Expert in Design and development of REST services including authorization and metering.... 
    For contractors
    Flexible hours
    Shift work

    AGM Tech Solutions

    Pittsburgh, PA
    2 days ago
  •  ...Data Modeler/ Architect 8+ years hands-on experience modeling and implementing complex data models both in relational as well as in-memory NoSql DBs such as Cassandra, HBase, MongoDb Experience with GraphDB modeling and development is a major plus Experience with... 

    ClifyX

    Pittsburgh, PA
    3 days ago
  •  ...Data Architect (Open Source) Location: Pittsburgh, PA Duration: Fulltime Job Description: Skills Desired: Open-Source Technologies: Hadoop, Spark, Kafka, Airflow, dbt, Talend. Cloud Platforms: AWS, Azure, or GCP with hands-on experience in data services... 
    Full time
    Immediate start

    JConnect Infotech

    Pittsburgh, PA
    5 days ago
  •  ...Office systems. Translate business requirements into scalable OMS and mid-office solution designs. Define system integrations, data flows, and interoperability between OMS, Dynamics, WMS, and Oracle ERP. Develop functional specifications for OMS-related... 
    Work at office

    Insight Global

    Pittsburgh, PA
    2 days ago
  •  ...processes and Dynamics-based solutions. Key Responsibilities Architect and deliver end-to-end Dynamics solutions integrated with OMS,...  ...ERP. Expertise in API-based integrations, middleware, and data architecture. Experience with Azure and cloud-native... 

    Insight Global

    Pittsburgh, PA
    2 days ago
  •  ...We are seeking an experienced Application Architect with deep expertise in Warehouse Management...  ...blueprints, system integrations, and data flows supporting realtime warehouse execution...  ...configurations aligned with operational and IT strategy. Define and enforce best... 

    Insight Global

    Pittsburgh, PA
    2 days ago
  •  ...Lead and mentor a high-performing team of data platform administrators and engineers....  ...with enterprise policies. Partner with IT security to ensure compliance with regulatory...  ...Certifications such as Azure Solutions Architect, Azure Data Engineer, Databricks Admin Associate... 

    Insight Global

    Pittsburgh, PA
    3 days ago
  • $145k - $165k

     ...Howmet Aerospace is currently in search of a Data Strategy Architect to join our Global Information Services (GIS) Resource Unit at the Howmet...  ...technology with BU/RU leadership. Major Activities: The IT business architect clarifies strategic intentions, identifies... 
    Work at office

    Howmet Aerospace

    Pittsburgh, PA
    1 day ago
  •  ...Data Engineer/ETL Location: Pittsburgh, PA Contract for 12+ months Description: Data Engineer - ETL with Python, Hadoop...  ...• Define optimal data flow for system integration and data migration • Integrate new data management technologies and software... 
    Contract work

    Apex Informatics

    Pittsburgh, PA
    4 days ago
  •  ...Data Engineering Position Responsibilities: Data Engineering, Data Modeling, Data Warehousing, Master Data Management, Reference Data Management, Data Lineage, Data Governance and Meta Data Management experience required Experience in defining Data & Analytics... 

    E-Solutions

    Pittsburgh, PA
    4 days ago
  • $55k - $132k

     ...geographic areas. Needed skills: o ETL o Informatica o Oracle Database, PL...  ...jobs) o APIs (REST, microservices) o Data Service Layer Mapping & Integrations o...  ...o Informatica PowerCenter to IICS cloud migration - a plus o Teradata knowledge - a plus... 
    Full time
    Temporary work
    Part time
    Work experience placement
    Work at office

    PNC

    Pittsburgh, PA
    3 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!