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
- ...Key Responsibilities 1. To architect| design and develop (through Team) solution for... ...requirement : Design and implement data pipelines to extract, transform, and load... ...and compliance Develop and maintain ETL workflows using tools Design and...Suggested
- ...ETL Data Architect Location: Chicago, IL (Day one Onsite) Duration: Contract/Fulltime Job Description: Overall 14+ years of experience and has played Data Architect role with 7-8 Years of exp. Worked as Data Architect for 2-3 enterprise level applications...SuggestedFull timeContract work
$93.6k - $154.44k
The 10 HOSP Ann & Robert H. Lurie Children's Hospital of Chicago is seeking a Data Architect I. This role involves designing, creating, deploying, and managing ETL jobs or other custom data applications and solutions in a hybrid data environment. Salary ranges from $93,...Suggested$93.6k - $154.44k
10 HOSP Ann & Robert H. Lurie Children's Hospital of Chicago is seeking a Data Architect I to design and implement ETL solutions, manage data integrations, and support data analytics systems. The ideal candidate will have extensive experience in database development and...Suggested- ...Job Title: Data Architect Work Location: Chicago, IL Duration: Permanent Position... ...systems Lead data integration and migration projects Provide thought leadership... ...closely with engineering teams to implement ETL/ELT pipelines, data integration, and...SuggestedPermanent employment
$176.1k - $238.2k
...complex challenges. Are you a customer-obsessed Application cloud migration expert with a passion for helping customers achieve their full... ...choice for customers? Do you love building new strategic and data-driven businesses? Join the ASP Healthcare & Life Sciences...PrincipalWorldwideFlexible hours- ...Media Data Management Work location: Local to Chicago, 2 days in the office on flexible... ...WM metadata (consolidate/organize) for migration to Collibra solution. To build out the WM... ...and services. The Business Data Analyst/ETL Developer is a key role in the project as...For contractorsWork at officeLocal areaRemote workFlexible hours
- ...Axiom Specific Data Consultant Senior Axiom Consultants are specialists... ...in technology strategy, migration, integration, and evolution of... ...of experience as Developer in IT industry with a minimum of 3 years... .... Hands on development of ETL jobs, Shell scripting and delivering...
- ...Title: Sr GCP Data Architect - Onsite role Location :... ...Data Architect (10+ years of IT experience majorly in the Data... ...The outcome is a tailored GCP migration roadmap and implementation plan... ..., infrastructure components, ETL/ELT and reporting/analytic...Contract work
$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- ...SNOWFLAKE DATA ARCHITECT Location: Chicago IL (Day One Onsite) Duration... ...of working experience in IT and 8+ years as a Snowflake Data... ...and standard DWH and ETL concepts Expertise in Snowflake... ...SnowPipe etc. Experience in Data Migration from RDBMS to Snowflake cloud...Full timeContract workWork experience placement
- ...Position- DATA Architect Duration-Contract Location- Chicago, IL (Need Only IL... ...and CDC extraction tools. Platform Migration : Lead the strategic planning and execution... ...real-time data synchronization. ETL Tools : Expertise in Airflow for data...Contract workImmediate start
- ...leveraging services such as S3 for scalable data storage. Develop serverless... ...using Tableau. Utilize Matillion for ETL processes, ensuring efficient data extraction... ...continuous deployment (CI/CD) pipelines. Previous work on large-scale data migration projects....Work at office
- ...Data Architect Location: Chicago Hybrid onsite 3x a week... ...to Business Unit and IT management and staff at... ...cycle. Acts as the principal designer for major... ...Data transformation (ETL) Write Snowflake SQL... ...tuning Help complete migration of existing SQL Server...Contract workTemporary workFor contractorsLocal area
- Senior AWS Big Data Architect (Cloud Data Platforms & Streaming Analytics) Location: Chicago Work... ...architectures, optimizing high-volume ETL pipelines, and enabling scalable analytics... ...data processing pipelines Lead cloud migration and modernization initiatives for enterprise...Contract work
- AWS Big Data Architect Location: Chicago Work Arrangement: Hybrid Employment Type: Contract Position... ...analytics solutions Develop scalable ETL and data integration pipelines... ...gather data requirements Support data migration and cloud transformation initiatives Optimize...Contract work
- ...Database Engineer with over 6 years of experience in Microsoft SQL Server and T-SQL development. Key responsibilities include designing ETL pipelines and managing database architecture. The ideal candidate will have a solid foundation in Microsoft .NET technologies and...
- ...Automation, LLC, based in Chicago, seeks a SQL Server Developer with extensive experience in database architecture, T-SQL development, and ETL pipeline implementation using SSIS. The ideal candidate should have a proven track record in managing high availability solutions and...
- ...SQL. • Pull, analyse, and visualise large data sets-including price, forward curves,... ...engineer existing spreadsheet logic and help migrate critical workflows into more stable, maintainable... ..., or risk systems. • Exposure to ETL concepts and workflow orchestration. • Awareness...PrincipalContract workWork at officeLocal area
- ...Title: Senior Data Architect Location: North, NJ/ Chicago, IL Job Type: Full Time Salary: $Market (Based on the Experience... ...Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies Ability to perform PL/SQL...Full time
- ...Position: Sr Data Architect with MDM Location: Chicago, IL Duration: 6-12 Months Need local to Chicago... ...Large organization experience Do Not Submit If Only ETL developer No MDM or reference data experience No Synapse...Local area
$63.68 - $71.68 per hour
...Senior Data Architect - Onsite Genesis10 is currently seeking a Senior Data Architect - Onsite for a 12+ month contract position with a... ...Modeler), database management systems, big data environments and ETL tools ~ Hands-on expertise in relational and NOSQL database...Hourly payContract work- ...Position: Data Architect (42125) Location: REMOTE Description: This engagement will support a Data Warehousing and Data Governance... ...warehouse using a metadata driven approach to reduce bespoke ETL and one off development efforts. Responsibilities Work closely...Remote work
- ...Title: Principal Data Solutions Architect Client Environment: Snowflake, Power BI, Collibra, Azure Data Factory (ADF), Azure Data Lake, Sigma... ...scalability, and maintainability. Support integration and migration efforts across cloud and on-prem platforms....
$150k - $175k
...investment advisor (RIA). Your Future Team As a Senior Data Architect, you will design and evolve Hightower's enterprise data... ...SQL and cloud platforms (Azure, AWS, or GCP) with modern ELT/ETL tools. ~ Experience with financial or wealth management data...Permanent employmentTemporary workWork at officeLocal areaRemote workMonday to FridayFlexible hours- ...Overview: Azure Data Migration Specialist - OpenText Migration Must Have Technical/Functional Skills * Professional specializing in the planning, execution, and successful completion of migrations involving OpenText products and systems * Expertise in migrating...
- ...Skills ~7+ years of experience with Data Modeling, Data Warehousing, and working... .... ~ Experience working with Business Architects, System Architects, Engineering, Data... ...Golang, or others. ~ Experience with ETL tools and frameworks (Apache tools, AWS Lambda...Work experience placement
$65 - $70 per hour
...Data Architect We are seeking an experienced Data Architect with a strong focus on cybersecurity. This role is responsible for the execution... ...tools (e.g., SAP PowerDesigner, Erwin Data Modeler), and ETL tools (e.g., Informatica, SSIS, Alteryx). Expertise in relational...- ...Data Specialist Must have 5+ years of insurance domain expertise... ...knowledge of data warehousing, ETL, and BI architectures, concepts... ...generating DDL. The enterprise data architect is a pivotal role focused on... ...with business stakeholders and IT teams to drive data initiatives...
- ...Leader responsible for the development and maintenance of complex data engineering solutions. This role includes partner collaboration... ...experience in designing data-intensive systems and proficiency in ETL and cloud infrastructure. This position follows a hybrid work model...
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!
- azure data architect Chicago, IL
- sr data modeler Chicago, IL
- data architect Chicago, IL
- remote data architect Chicago, IL
- big data architect Chicago, IL
- data center architect Chicago, IL
- database designer Chicago, IL
- data integration architect Chicago, IL
- salesforce data architect Chicago, IL
- senior data architect Chicago, IL

