Senior Data Integration Specialist II #1733184

Network Designs•Washington, DC

1d•Remote

About The Position

NDi is seeking a Senior Data Warehouse Specialist II to support a federal aviation safety analytics program for the Federal Aviation Administration (FAA). The program supports the Aviation Safety Information Analysis and Sharing (ASIAS) environment, which integrates aviation safety data from multiple government and industry sources to support safety analysis, risk monitoring, and operational decision-making across the National Airspace System. The Senior Data Warehouse Specialist will support the data architecture and analytics platform that powers this environment, including data warehouse maintenance, ETL development, data integration, and analytical data preparation. The role requires strong experience working with complex multi-source datasets and supporting large-scale enterprise data environments.

Requirements

U.S. Citizenship is required
Must be able to obtain a Public Trust clearance.
Bachelor's degree in Computer Science, Information Systems, Data Engineering, Mathematics, or a related technical field.
Minimum fifteen (15) years of professional experience in data warehousing, data engineering, or enterprise data analytics environments.
Experience designing and maintaining ETL/data integration pipelines across multiple source systems.
Strong experience with SQL development, relational databases, and data modeling.
Experience working with enterprise data warehouse architectures and analytical data environments.
Experience supporting data quality, metadata management, and data governance practices.
Experience documenting data flows, data mappings, and technical specifications.
Strong analytical skills and ability to work with complex datasets.
Ability to communicate effectively with both technical and non-technical stakeholders.
High attention to detail and commitment to data quality.

Nice To Haves

Experience supporting large federal data or analytics platforms.
Experience with data standardization or taxonomy development initiatives.
Experience supporting analytical systems used for safety, risk, or operational analytics.
Experience working in large multi-source data integration environments.
Familiarity with ETL tools, data warehouse performance optimization, and enterprise data architectures.

Responsibilities

Design, develop, and maintain ETL processes supporting integration of multiple aviation safety data sources.
Support the maintenance and enhancement of the enterprise data warehouse environment.
Develop and maintain data models and analytical datasets supporting safety analytics.
Support integration of new data sources into the analytics platform.
Maintain data standards, metadata, and documentation for the data warehouse environment.
Support data quality validation, transformation logic, and data governance processes.
Document system architecture, data flows, and integration processes.
Support analysts and technical teams in accessing and using integrated safety datasets.
Assist with development of analytical data structures used for safety metrics and reporting.
Collaborate with technical teams to improve data accessibility, performance, and reliability of the analytics environment.