Data Engineer

Alvion; Richmond (VA); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Life insurance

401(k) matching

Paid time off

Job summary

Alvion, in collaboration with Richmond International Airport, is hiring a Data Engineer to design and build the airport’s data ecosystem on-site in Richmond, Virginia.

You will connect operational and commercial systems, develop production-grade pipelines, data models, APIs, and analytics-ready datasets to support dashboards and reporting for airport leadership.

This role requires 3–5 years in data engineering, strong SQL and Python skills, and experience with ETL/ELT pipelines and data modeling.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or related field; equivalent experience considered.
• 3–5 years of professional experience in data engineering, software/data integration, or related field.
• Strong SQL skills and hands-on experience with relational databases.
• Proficiency in Python for data processing and automation.
• Experience designing and maintaining ETL/ELT pipelines.
• Experience designing data models and database structures.
• Experience integrating enterprise applications via REST APIs, middleware or iPaaS platforms.
• Experience with dimensional or analytical modeling (Star Schema and/or Data Vault).
• Experience building production data pipelines with version control and separate development/production environments.
• Ability to communicate effectively with technical and non-technical stakeholders.

Responsibilities

• Define and establish enterprise data architecture, including data models and centralized data repository.
• Design and maintain production-grade ETL/ELT pipelines across enterprise systems.
• Build ingestion processes for REST APIs, relational databases, structured files, vendor feeds, and IoT sources.
• Select integration approaches including batch, near-real-time, and event-driven processing.
• Develop system-to-system integrations using APIs, middleware, iPaaS, and file exchanges.
• Transform raw data into standardized, analytics-ready datasets and data models.
• Establish monitoring, logging, data-quality processes for production pipelines.
• Build curated datasets and structures to support dashboards and reporting.
• Collaborate with stakeholders to understand source systems, data ownership, and reporting needs.
• Maintain technical documentation including architecture diagrams and data dictionaries.

Skills

SQL

Python

ETL/ELT pipelines

Data modeling

REST APIs

iPaaS

Star Schema

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle Integration Cloud

Azure Data Factory

MuleSoft

Oracle Fusion ERP

Oracle Cloud Infrastructure

Microsoft Azure

Power BI

Job description

Alvion is working with Richmond International Airport to hire a Data Engineer.

Richmond International Airport is modernizing its enterprise and operational technology environment and building the data capability needed to run and grow the airport on better information. The Data Engineer will play a central role in that effort.

This is a hands-on, build-from-the-ground-up position responsible for designing and developing the airport’s data ecosystem. You will connect operational and commercial systems into a centralized data repository, build production-grade pipelines and integrations, develop data models and APIs, and turn raw information into trusted, reporting-ready datasets.

The environment is broad and operationally complex, with data coming from systems such as flight information displays, passenger processing, baggage handling, gate and apron management, parking, property and concession management, passenger-flow sensing, CRM, and enterprise ERP/EPM platforms.

What You’ll Do

• Help define and establish the Commission’s enterprise data architecture, including data models, schemas, integration patterns, data standards, and a centralized repository for airport data.
• Design and maintain production-grade ETL/ELT pipelines across enterprise and operational systems.
• Build ingestion processes for REST APIs, relational databases, structured files, vendor feeds, IoT sources, and other application interfaces.
• Select appropriate integration approaches, including batch, near-real-time, and event-driven processing.
• Develop and support system-to-system integrations using APIs, middleware, iPaaS platforms, file exchange, and other practical integration methods.
• Transform raw source data into standardized, analytics-ready datasets and data models.
• Establish monitoring, logging, exception handling, reconciliation, recovery, and data-quality processes for production pipelines.
• Build curated datasets and structures that support dashboards, recurring reporting, ad hoc analysis, and future advanced-analytics use cases.
• Partner with application owners, business stakeholders, vendors, consultants, and IT leadership to understand source systems, integration constraints, data ownership, and reporting needs.
• Maintain technical documentation including architecture diagrams, data-flow diagrams, data dictionaries, integration specifications, procedures, and support runbooks.

What We’re Looking For

• Graduation from an accredited college or university with a bachelor’s degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related discipline; equivalent professional experience may be considered.
• 3-5 years of professional experience in data engineering, software/data integration, data-platform development, or a closely related field.
• Strong SQL skills and hands-on experience designing and working with relational databases.
• Proficiency in Python for data processing, integration, automation, or application development.
• Experience designing, developing, and supporting ETL/ELT pipelines.
• Experience designing data models and database structures.
• Experience integrating enterprise applications through REST APIs, middleware or iPaaS platforms, file exchange, direct database extraction, or similar methods.
• Experience with dimensional or analytical modeling approaches such as Star Schema and/or Data Vault.
• Experience building and maintaining production data pipelines using source control, documented deployment practices, and separate development and production environments.
• Experience with data quality, reconciliation, monitoring, troubleshooting, and production support.
• Ability to communicate effectively with both technical and non-technical stakeholders.

Preferred Experience

Experience in one or more of the following areas is beneficial:

• Oracle Integration Cloud or comparable iPaaS platforms such as Azure Data Factory, MuleSoft, etc.
• Oracle Fusion ERP, Oracle EPM, or comparable enterprise financial platforms
• Oracle Cloud Infrastructure or Microsoft Azure
• Oracle Analytics/OTBI, Power BI, or comparable analytics platforms
• Establishing a new enterprise data platform, data warehouse, or centralized repository
• Operational, IoT, facilities, physical-security, transportation, or other nontraditional enterprise data sources
• Airport, transportation, critical-infrastructure, public-sector, or similarly complex operating environments

Aviation experience is helpful but not required.

What Success Looks Like – Key Deliverables for the Role

• Integrated Airport Data Repository — a centralized repository that houses historical and current data from priority operational and commercial systems, accommodating both structured and unstructured sources.
• Automated Data Pipelines — production-grade, version-controlled workflows that ingest data from airport systems without manual intervention, including automated replacement of the manual reconciliation between airfield activity data and the property and revenue system.
• Trusted Revenue and Operations Datasets — reconciled, reporting-ready datasets covering passenger enplanements, cargo and aircraft landed weights, gate utilization and aircraft dwell time, and parking and concession performance.
• Operational API Layer — a suite of internal APIs that allow working groups to pull current operational information from airport systems (for example, security wait times and baggage retrieval times).
• Security and Passenger Flow Datasets — the ingestion design and data model for passenger flow sensing, and cleaned datasets tracking dwell time and terminal movement as that sensing capability is deployed.
• Compliance and Regulatory Reporting Engine — automated recurring reports with an audit trail demonstrating that reported data is complete and unaltered.
• Initial Dashboards — a first wave of dashboards supporting priority operational, commercial, and leadership needs, built on documented datasets that others can extend.

Additional Information

This is an on-site position at Richmond International Airport in Richmond, Virginia. The role participates in a scheduled on-call rotation supporting production data integrations and reporting systems.

Candidates must possess a valid Virginia Driver’s License and be able to obtain and maintain eligibility for a Security Identification Display Area (SIDA) badge.

Benefits include health insurance, dental insurance, life insurance, 401(k) matching, and paid time off.

Capital Region Airport Commission is an Equal Opportunity Employer.