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 10 hours ago
Similar jobs that could be interesting for youBased on the IT Principal Data Architect - Data Migration, OLTP, ETL in Buffalo, NY vacancy
  • $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... 
    Suggested
    Summer holiday
    Flexible hours

    EY

    Buffalo, NY
    3 days ago
  •  ...Data Solution Architect Buffalo, NY or Wilmington, DE (3 days onsite/2 days remote), OR Remote w/ travel 6+-month contract to hire Web Cam Interview...  ...using technologies such as Databricks, Kafka, etc. ETL/ELT Frameworks: Develop and implement ETL/ELT frameworks for... 
    Suggested
    Contract work
    Work at office
    Remote work
    Monday to Thursday

    Syntricate Technologies

    Buffalo, NY
    3 days ago
  •  ...Title: Snowflake Data Modeler Location: Buffalo, NY(Remote) Job Description: ~7+ years of experience...  ...structures and schemas. ~ Collaborate with data architects and data engineers to align models with ETL/ELT pipelines and integration strategies. ~... 
    Suggested
    Remote work

    United IT Solutions

    Buffalo, NY
    2 days ago
  •  ...Information Officer related duties: # Assumes responsibility as Chief Information Officer (also referred to by NYSED as District Data Coordinator). # Supervises the Registration Office. # Manages the Registration Office Secretary "Registrar". # Facilitates enrollment... 
    Principal
    Full time
    Work at office

    West New York EMS

    Lackawanna, NY
    2 days ago
  • $201.7k - $267.3k

     ...Principal Data Scientist : Product to Market (P2M) Optimization Gap Inc. is seeking a Principal Data Scientist with deep expertise in operations research and machine learning to lead the design and deployment of advanced analytics solutions across the Product-to-Market... 
    Principal
    Minimum wage

    Gap Inc.

    Buffalo, NY
    3 days ago
  • $124k - $280k

     ...Specialty/Competency: Data, Analytics & AI Industry/Sector: Health Services Time Type: Full time Travel Requirements:...  ...FHIR R4, and interoperability standards - Proven track record architecting data solutions for healthcare programs - Navigating HIPAA compliance... 
    Full time
    H1b

    PwC

    Buffalo, NY
    2 days ago
  • $123.3k - $221.95k

     ...Principal Artificial Intelligence (AI) Security Engineer The Principal Artificial Intelligence (AI) Security Engineer serves as the...  ...design, and detection strategy across the AI lifecycle, including data ingestion, feature engineering, training and fine-tuning,... 
    Principal
    Work from home
    Home office

    Univera Healthcare

    Buffalo, NY
    23 hours ago
  •  ...~9+ years of IT experience with string emphasis on ETL, DW Technologies ~ Must have strong knowledge and hands on experience in Informatica Power...  ...Snowflakes ~ Must have good experience in ETL design, EDW/Data Mart Design/architecture ~ Good Debugging and... 

    United IT Solutions

    Buffalo, NY
    1 day ago
  •  ...Program Director, Cloud & Data Center Migration This role serves as an execution leader for Clients Cloud & Data Center Migration initiative. The Program Director partners closely with Cloud & Data Center Migration Leads to translate strategy into execution, establish... 

    World Wide Technology

    Buffalo, NY
    23 hours ago
  • $100k - $172.5k

     ...Job Description: We are searching for the best talent for a Principal Product Security Engineer to be located in Danvers, MA or...  ...development activities including security plans, architecture diagrams, data flow diagrams, threat models, security requirements, Design for... 
    Principal
    Full time
    Temporary work
    Work at office
    Local area
    Immediate start
    Remote work
    3 days per week

    Johnson & Johnson

    Buffalo, NY
    4 days ago
  •  ...Job Description Insight Global is seeking a driven, hardworking Data Center Infrastructure Architect to join an AI cloud and infrastructure start-up dispersed across the US. This role can be remote in NYC, SF, Seattle, or Austin. This is a full-time, permanent role... 
    Permanent employment
    Full time
    Remote work

    Insight Global

    Clarence, NY
    23 hours ago
  • $150k - $180k

     ...Principal Software Engineer / Remote (Polyglot Needed)2 days ago Be...  ...conception to build and releaseCloud Migration: Seamlessly transition your...  ...dynamic team of experts to architect, deploy, and optimize cutting...  ...Services and IT Consulting and Software DevelopmentJ... 
    Principal
    Local area
    Remote work

    Jobot

    Buffalo, NY
    2 days ago
  • $108.23k - $158.73k

     ...Qualification Summary: The Senior Data Engineer will join the Americas IT software and architecture team. This...  ..., guide junior engineers, and architect solutions from the ground up based on...  ...Optimization: Lead optimization of ETL/ELT workloads for large-scale analytics... 
    Full time

    Linde Gas & Equipment Inc.

    Tonawanda, NY
    3 days ago
  •  ...ACV Auctions Inc. (ACV), has applied innovation and user-designed, data driven applications and solutions. We are building the most...  ...effectively. Lead the evaluation and modernization of legacy ETL-style, batch, and synchronization workflows that support core business... 
    Temporary work
    Local area
    Visa sponsorship
    Work visa

    ACV, INC.

    Buffalo, NY
    4 days ago
  • $120k

     ...description: SENIOR DATA ENGINEER | Direct Hire...  ...will be the founding architect of a centralized data platform...  ...the autonomy to design it, build it, and lay the...  ...designing and building ETL/ELT pipelines and data...  ...integrations, data migration, and reporting needs... 

    NPAworldwide

    Buffalo, NY
    1 day ago
  •  ...Certified - Administrative - Elementary Asst Principal Job Number 3300055383...  ...and share monthly discipline and attendance data Create and implement action plans to improve...  ...Principal or Chief Talent Officer How it Supports the Mission and Vision This... 
    Principal
    Contract work

    West New York EMS

    Buffalo, NY
    23 hours ago
  •  ...and proposals. This role is specific to ETL Development: Key information - Knowledge...  ...Developer Tools: Git, Azure Devops, CDIPC - Cloud Data Integration for PowerCenter ETL Process...  ..., creates and follows all documented IT processes and standards, application documentation... 

    Excellus Health Plan

    Buffalo, NY
    3 days ago
  •  ...lieu of degree. - Experience with complex or higher-level recruitment projects. - Experience recruiting and sourcing for Executive IT positions. - Proficient at sourcing on job boards, ATS, networking sites, sourcing platforms. Also, using unique strategies to... 
    Principal
    Minimum wage
    Contract work
    Temporary work
    Work experience placement

    MAXIMUS

    Buffalo, NY
    4 days ago
  •  ...activities for mainframe test environments, including refreshing data, executing batch jobs, and resolving environment-related issues...  ...that changes are validated and approved for production migration. Report and document results: Provide regular updates and reporting... 

    United IT

    Buffalo, NY
    3 days ago
  • $50 - $55 per hour

     ...requirements and Corporate Technology standards Participate in data mapping for system integrations, conversions, and acquisition-...  ...working on large-scale transformation projects such as system migrations, platform implementations, or business transformation... 
    Contract work

    Lighthouse Technology Services

    Buffalo, NY
    4 days ago
  •  ...Responsibilities/Experience: To assist the principal, faculty, staff, and students in creating a positive school culture that improves...  ...consultative meetings to support diverse student needs. Data, Technology, & Testing Coordination: Manage student information... 
    Principal
    Summer work

    Kenmore-Town of Tonawanda UFSD

    Buffalo, NY
    3 days ago
  • $85k

     ...Full job description Assistant Principal -  John F. Kennedy Middle School Location:  John F. Kennedy Middle School, Cheektowaga...  ...Systematically collects and analyzes academic, behavioral, and attendance data to inform school-wide interventions and track student progress... 
    Principal

    CHEEKTOWAGA-SLOAN UNION FREE SCHOOL DISTRICT

    Buffalo, NY
    10 hours ago
  •  ...ADW / DIS Developer Location: Buffalo, NY Onsite Job Description: We are seeking an experienced Oracle ADW Autonomous Data Warehouse Developer with strong expertise in DIS/DIH, data engineering, and banking domain workflows. The ideal consultant will work... 

    United IT Solutions

    Buffalo, NY
    3 days ago
  •  ...Reference Data Management Analyst Location: Buffalo, NY - Onsite Key Responsibilities Collaborate with business stakeholders and data teams to analyze business processes and implement reference data standardization. Translate business requirements into... 
    Work experience placement

    United IT

    Buffalo, NY
    3 days ago
  •  ...support Snowflake and Databricks environments that underpin the Teradata migration program. You will be responsible for administration, automation, performance, and reliability of the cloud data platforms. Key Responsibilities Deploy, configure, and administer... 

    United IT

    Buffalo, NY
    3 days ago
  •  ...Axiom Developer Design and develop Data Sources, Data Models, Shorthands, Portfolios...  ...Strong hands-on development experience with ETL jobs and creating the Unix & Linux Shell...  ...the Axiom code in Controller View Migration of Axiom components from Dev environment... 

    United IT

    Buffalo, NY
    3 days ago
  •  ...the Seneca Nation. Great Waters Federal is seeking a Senior IT Governance Specialist for the National Capital Region or a remote...  ...and application of industry standard and best practice data governance and data management theories, principles, practices, and... 
    Permanent employment
    Full time
    H1b
    Remote work
    Flexible hours

    Seneca Holdings LLC

    Williamsville, NY
    3 days ago
  • $128.9k - $214.9k

     ...Bank.This includes leading a diverse team of IT Audit staff and guiding the risk-based...  ...related risks and controls within legacy data centers, co-location environments, and public...  ...as the organization continues its migration of operations to the cloud. This role requires... 
    Work experience placement
    Shift work

    M&T Bank

    Buffalo, NY
    3 days ago
  • $139.7k - $232.9k

     ...this role you will collaborate closely with cross-functional teams, including infrastructure, software engineers and IT professionals, to ensure data integrity, accessibility, and performance across platforms. Primary Responsibilities: Lead the database engineering... 
    Work experience placement
    Work from home
    1 day per week

    M&T Bank

    Buffalo, NY
    3 days ago
  • $90k - $105k

     ...Middle School Principal Buffalo/Rochester Academy of Science Charter School 24 Agassiz Circle Buffalo , NY 14214 Certified -...  ...budgeting, staffing, scheduling, and operational planning. Analyze data to drive school improvement and student outcomes. Support... 
    Principal
    Full time
    Local area

    Erie 2-Chautauqua-Cattaraugus BOCES

    Buffalo, NY
    2 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!