Senior Data Integration Specialist
Core
Design, develop, and maintain ETL processes and data models to integrate aviation safety data sources into an enterprise data warehouse for safety analytics and risk monitoring.
Role type
Senior IC data integration specialist (data engineering)
Builds
Enterprise data warehouse environment and integrated safety datasets for the FAA aviation safety program
Domain
Federal aviation safety analytics and data engineering
Required skills
Palantir Foundry, ETL pipeline development, data modeling (ontology), SQL, relational database design, data governance, metadata management, data quality validation, technical documentation
Preferred skills
Large federal data platform experience, data standardization/taxonomy initiatives, safety/risk analytics, multi-source integration environments, ETL tool optimization
Technologies
Palantir Foundry, SQL, Data Warehouse ETL
Responsibilities
Design and maintain ETL processes integrating multiple aviation safety data sources; Develop and maintain data models and analytical datasets for safety analytics; Integrate new data sources into the analytics platform; Maintain data standards, metadata, and documentation; Support data-quality validation and governance processes; Document system architecture and data flows; Collaborate with teams to improve data accessibility and performance.