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 16 hours ago
Similar jobs that could be interesting for youBased on the IT Principal Data Architect - Data Migration, OLTP, ETL in Hartford, CT vacancy
  • ContractStaffingRecruiters.com is seeking a Data Engineer in Farmington, CT who will develop scalable solutions for complex data processing...  ...and transformation, alongside responsibilities in designing ETL processes and database objects. Key qualifications include experience... 
    Suggested

    ContractStaffingRecruiters.com

    Farmington, CT
    5 days ago
  •  ...We are a federal IT company on a mission...  ...motivated Database Architect for a Full-Time position...  ...in modern data architecture, cloud...  ...strategy for cloud migration and modernization initiatives...  ...of: Data modeling (OLTP / OLAP) Performance...  ..., Redshift) ETL/ELT tools (Informatica... 
    Suggested
    Full time

    NuAxis Innovations

    Hartford, CT
    5 days ago
  •  ...Senior Data Architect Miniiapolis, MN OR Hartford, CT (Need only local candidates) (4 days onsite) A thought leader who can define and...  ...platforms (e.g., AWS, Azure, GCP). Strong understanding of ETL/ELT tools, data integration strategies, and advanced data processing... 
    Suggested
    Local area

    Diversity Nexus

    Hartford, CT
    1 day 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

    Hartford, CT
    4 days ago
  •  ...Data Architect Must have 6+ years of experience in Data Warehousing and Data Architecting Very strong experience in Data analysis and architectural...  ...throughout the project life cycle Participates in creation of ETL/ELT Specifications Interact daily and carry out knowledge... 
    Suggested

    ClifyX

    Hartford, CT
    1 day ago
  •  ...Data Architect The Data Architect will be responsible for designing and implementing robust data architectures that support the organization...  ...to think strategically and analytically. Exposure to the ETL, ELT, Data Quality and Governance tools Key... 

    Omni Inclusive

    Hartford, CT
    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

    Hartford, CT
    1 day ago
  •  ...Overview: Position: Data Architect Location: Hartford, CT (Remote right now) Duration: 12+Months Mandatory Skills : Talend...  ...: Translating data and technology requirements into our ETL / ELT architecture. Develop real-time and batch data... 
    Remote work

    r2 Technologies, Inc.

    Hartford, CT
    3 days ago
  •  ...Oefentherapie is seeking an experienced software engineer to design scalable data pipelines and AI-driven workflows. The ideal candidate will have...  ...and Java, and deep expertise in data engineering including ETL and data modeling. Responsibilities include building LLM/agent-... 

    Ll Oefentherapie

    Hartford, CT
    5 days ago
  •  ...proven track record in database architecture, SQL development, and ETL/ELT solutions. Key responsibilities include database design, custom SQL scripting, and ensuring data integrity during migrations. Candidates should possess strong problem-solving abilities, excellent... 

    Tri-Com Consulting Group

    Hartford, CT
    5 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

    Hartford, CT
    4 days ago
  •  ...Data Architect Location Remote but travel to CT Duration 6 Months Client: Yash/Insurance domain client Visa: USC/GC/GCEAD/H4EAD...  ...platforms. Develop and maintain data models, databases, and ETL pipelines. Integrate legacy systems including MS Access... 
    Remote work

    Kasmo Global

    Hartford, CT
    2 days ago
  • Nexiva Inc is seeking a Senior Tableau & ETL Developer to work out of Hartford, CT in a hybrid role. This position requires deep...  ...Tableau dashboards, optimizing SSIS ETL pipelines, and supporting data migrations. The ideal candidate possesses strong SQL skills, stakeholder... 
    Full time

    Nexiva Inc

    Hartford, CT
    5 days ago
  •  ...Staff Data Platform Architect (Databricks) Hartford, CT, hybrid (on-site 3 days per week)  Department: Data & Analytics Platform Business...  ...Unity Catalog governance, workspace topology, and complex migration patterns. Consult on the design of high-performance data... 
    Contract work
    3 days per week

    Aquent Talent

    Hartford, CT
    2 days ago
  •  ...MDM Good to Have Reltio MDM Node JS Python As Master Data Management MDM Reltio Expert you will be responsible for...  ...Management MDM solutions using Reltio MDM software primarily cloud migration Collaborate with business stakeholders to gather and understand... 
    Principal

    Futran Tech Solutions Pvt. Ltd.

    Hartford, CT
    4 days ago
  • Key Responsibilities Design and develop scalable data pipelines and AI-driven workflows. Build LLM/agent-based solutions for business...  .... Strong knowledge of SQL. Deep expertise in data engineering: ETL, data transformation, data modeling (Spark, SQL). Experience building... 
    Principal

    Ll Oefentherapie

    Hartford, CT
    5 days ago
  • $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... 
    Principal
    Temporary work
    Worldwide
    Flexible hours

    Oracle

    Hartford, CT
    1 day ago
  •  ...Overview: ROLE: Data Architect (SI Level) Experience Required: 12-18 Years Key Responsibilities: • Define enterprise-level data architecture blueprint and standards • Design scalable ingestion pipelines for systems such as AMI, CIS, OMS, GIS, SCADA,... 

    Purple Drive

    Berlin, CT
    4 days ago
  • $90k - $109k

     ...Server Support Engineer for its Hartford, CT location. The role involves enhancing and troubleshooting SSIS packages and SQL Server ETL workflows, optimizing performance, and diagnosing production issues using advanced SQL skills. This hybrid position offers an annual... 

    Cognizant

    Hartford, CT
    5 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

    Hartford, CT
    6 days ago
  •  ...and applies necessary elicitation techniques to draw out data and analytics business requirements completely and...  ...checks to assess the quality of data in different stages of ETL /ELT. Assist data architects in developing data dictionaries, flow diagrams, data modeling... 
    Work at office

    Syntricate Technologies

    Hartford, CT
    4 days ago
  •  ...after hours/on-call as needed. Collaborate with team and senior IT management to drive projects to completion. Perform...  ...ActiveBatch, etc., will suffice. Experience with at least one sales data provider, such as SS&C’s SalesConnect. Primarily in-office... 
    Work at office

    Zortech Solutions

    Hartford, CT
    4 days ago
  • $126.5k - $208.7k

     ...Openings 1 What Is the Opportunity? Travelers is seeking an Architect to join our organization as we grow and transform our...  ...What Will You Do? Lead the design and stewardship of BSI's data governance architecture, data traceability standards, and quality... 
    Work experience placement
    Local area

    Travelers Insurance

    Hartford, CT
    1 day 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

    Hartford, CT
    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

    Hartford, CT
    6 days 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

    Hartford, CT
    5 days ago
  •  ...in the process. Will set up, perform and automate test, analyze data, root out problems, and take corrective action as needed. We need...  ...or Product Engineering, ideally with project leadership skills. It would be preferred if the candidate has design experience, or at... 
    Principal

    Advanced Technology Search

    Hartford, CT
    5 days ago
  • $138.6k - $231k

     ...Senior Data Platform Solution Architect (Architecture Senior Advisor) We are looking for a Senior Data Platform Solution Architect to design and deliver secure, scalable data and analytics solutions. This role helps turn business needs into clear, practical systems... 
    Local area
    Work from home

    CarepathRx

    Bloomfield, CT
    5 hours ago
  • $132.23k - $176.31k

     ...the AI‑powered world, connecting people, data, and applications through our expansive...  ...and technically adept Senior Lead Data Architect to lead high-impact analytics initiatives...  ...analytics, with at least 3 years in a senior or principal role. ~ Proficiency in SQL, Python,... 
    Temporary work
    Remote work

    Lumen Inc

    Hartford, CT
    3 days ago
  • A leading data analytics company is seeking a Principal Engineer to drive innovations in Agentic AI. This role involves architecting AI components and collaborating with teams to create secure and scalable frameworks for autonomous AI agents. Candidates should have over... 
    Principal
    Flexible hours

    Teradata Corporation (SE)

    Hartford, CT
    5 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!