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.
- 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
- ...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...SuggestedContract workRemote work
- ...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...SuggestedFull timeContract workTemporary workImmediate startRemote work
- ...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...PrincipalFull timeTemporary workPart timeWork experience placementWork at office
$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....SuggestedRelocation- ...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
- ...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 officeHome office
- ...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,...
$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 timeTemporary workPart timeWork experience placementWork at officeFlexible hours- ...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
- ...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
$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- ...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 timePart timeSummer workCasual workLocal areaImmediate start
$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- ...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 ~...
- ...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
- ...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....
- ...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....
- ...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
- ...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 areaWorldwideShift work
- ...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 contractorsFlexible hoursShift work
- ...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...
- ...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 timeImmediate start
- ...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
- ...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...
- ...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...
- ...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...
$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- ...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
- ...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...
$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 timeTemporary workPart timeWork experience placementWork at office
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 architect Pittsburgh, PA
- data center architect Pittsburgh, PA
- database designer Pittsburgh, PA
- data integration architect Pittsburgh, PA
- senior principal cloud computing engineer Pittsburgh, PA
- senior principal scientist Pittsburgh, PA
- principal Pittsburgh, PA
- data coordinator Pittsburgh, PA
- master data coordinator Pittsburgh, PA
- data officer Pittsburgh, PA


