Data Architect

Integration International Inc.; Washington (District of Columbia); Hybrid; USD 74,000 - 105,000; Full time

Job summary

Amtrak is seeking a Senior Data Information Engineer to lead enterprise data modeling and information engineering across Transportation Operations systems. The role defines and governs shared information models, schemas, and data contracts to enable interoperable, trustworthy data exchange across legacy and modern platforms.

The candidate will establish semantic definitions, drive portfolio-wide information modeling frameworks, and oversee data governance, security, and performance requirements.

Qualifications

• Demonstrated experience designing and governing enterprise information models, conceptual/logical/physical data models, schemas, and data standards across complex, highly integrated environments.
• Experience integrating information across multiple operational applications and systems.
• Transportation, railroad, logistics, transit, or similarly complex domain experience preferred.
• Bachelor’s degree required; 15+ years of related work experience.

Responsibilities

• Own portfolio-wide information modeling framework for data in motion and at rest; ensure alignment with standards and security requirements.
• Lead creation of standardized data models, including database, event, and API contracts.
• Design, develop, and maintain conceptual, logical, and physical data models and schemas to support business needs.
• Translate complex operational concepts into precise data definitions and models for multiple systems.
• Establish and govern schema lifecycle and evolution across databases, APIs, and event streams.

Skills

Information modeling

Data modeling

Data governance

API contracts

Event-driven design

Relational databases

NoSQL databases

Stakeholder collaboration

Education

Bachelor's degree in information technology or related field

Master's degree in engineering or computer science

Job description

Job Title: Senior Data Information Engineer — Enterprise Data Modeling & Information Engineering

Contract Duration: 12 Months of contact

Client Location: Washington, DC (Remote but needs to be onsite for Pi Meeting)

Client Name: Amtrak

Pay rate: $65/hr on w2

Role Overview:

• The Senior Data Information Engineer serves as the portfolio’s senior information engineering and enterprise data modeling authority.
• This role is responsible for defining and governing shared information models, schemas, data standards, and event/API data contracts across Transportation Operations applications and systems.
• The role establishes consistent semantic and structural definitions for operational information exchanged across legacy and modern platforms, enabling interoperability, reuse, trustworthy data exchange, and scalable integration across the portfolio.

Key Responsibilities:

• Own the portfolio-wide information modeling framework for data in motion and at rest, ensuring alignment with enterprise data modeling standards and applicable security, performance, interoperability, and governance requirements.
• Evaluate, design, implement, and maintain technical information frameworks for the portfolio’s ecosystem.
• Lead creation of standardized data models, including database, event, and API contracts.
• Design, develop, and maintain conceptual, logical, and physical data models and schemas to support business and technical requirements.
• Analyze legacy data systems, including mainframe environments, to inform target-state information models and migration strategies.
• Verify and maintain data integrity across the system portfolio.
• Review database design and recommend opportunities for enhancement.
• Evaluate, establish, and implement policies and procedures relating to database management, security, maintenance, and utilization.
• Contribute to the development and refinement of enterprise information management standards.
• Maintain traceability between business concepts, logical information models, physical schemas, APIs, and event contracts.
• Translate complex operational concepts into precise, reusable data definitions and models that can be consistently implemented across multiple systems.
• Develop current-state, transition-state, and target-state information models to support modernization of legacy operational systems.
• Evaluate data models and event contracts for semantic consistency, interoperability, backward compatibility, reuse, and downstream consumer impact.
• Define and govern schema lifecycle and evolution practices across databases, APIs, and event-streaming platforms.
• Lead information modeling working sessions with business SMEs, system and solution architects, application teams, integration teams, and data engineering teams.
• Establish modeling standards and conventions governing conceptual, logical, physical, API, and event-based information structures.
• Define and govern canonical information models and shared business entities across Transportation Operations systems, including authoritative definitions, relationships, identifiers, and ownership.

Minimum Qualifications:

• Demonstrated experience designing and governing enterprise information models, conceptual/logical/physical data models, schemas, and data standards across complex, highly integrated, business-critical operational environments.
• Experience integrating information across multiple operational applications and systems is required.
• Transportation, railroad, logistics, transit, aviation, utilities, or similarly complex operational domain experience is strongly preferred.
• Bachelor’s degree in information technology or a related discipline.
• 15+ years of related work experience.
• Excellent written, presentation, and verbal communication skills.
• Demonstrated experience with relational and NoSQL technologies.

Preferred Qualifications:

• Master’s degree in engineering or computer science, or equivalent.
• Knowledge of distributed systems, middleware, API integration, event-driven design, and enterprise information management practices.