The Data Integration Engineer designs, develops, and maintains data integration solutions and pipelines that support enterprise analytics, data sharing, and operational reporting.
The candidate shall have experience performing data mapping, transformation, normalization, and data quality validation activities to support enterprise analytics, reporting, operational, and mission requirements. The candidate should possess strong knowledge of data integration patterns, data lifecycle management, and modern cloud-based data architecture.
The candidate shall demonstrate experience supporting data onboarding initiatives, including source system analysis, requirements collection, interface design, integration development, testing, and operational deployment. Experience working closely with Data Governance, Data Stewardship, Metadata, and Security teams to ensure compliance with data standards and governance requirements is required.
The candidate shall possess experience implementing metadata capture, lineage tracking, tagging, and classification capabilities within data ingestion and processing workflows. Experience supporting enterprise data catalogs and metadata management initiatives is highly desired.
Key Responsibilities
- Design and build ETL/ELT data pipelines.
- Develop APIs and data integration services.
- Perform data mapping and transformation activities.
- Implement automated data ingestion processes.
- Monitor and optimize data processing performance.
- Support cloud-based data architectures.
- Document data lineage and integration workflows.
- Collaborate with governance teams to ensure compliance standards are met.
- Python
- SQL
- ETL/ELT Development
- API Development
- Azure Data Factory
- Databricks
- Data Modeling
- Cloud Data Platforms
- Data Validation and Testing
- Bachelor’s degree in computer science or related discipline.
- 12+ years of data engineering experience.
- Experience with Azure, AWS, or hybrid cloud environments.
Skills Required
- Python
- SQL
- ETL/ELT development
- API development
- Azure Data Factory
- Databricks
- Data modeling
- Cloud data platforms
- Data validation and testing
- Bachelor's degree in computer science or a related discipline
- 12+ years of data engineering experience
- Experience with Azure, AWS, or hybrid cloud environments
What We Do
Red Arch Solutions is a premier U.S. small business providing its customers with state-of-the-art tactical and strategic intelligence, systems, and software engineering solutions, solving some of the most pressing and unique intelligence community challenges related to National Security. Our employees are exceptionally skilled professionals; individuals who are dedicated to collecting, analyzing, creating and engineering the best solutions in support of critical missions. Red Arch Solutions takes pride in the success of our customers. The depth of our engineers’ experience combined with our breadth of exposure across the intelligence community enables us to provide value added, synergistic analytical and engineering support. Unique to Red Arch Solutions is the focus on its employees. Our guiding principle is “People First.” We offer employees career mobility and stability, work-life balance flexibility, and individualized career paths. The loyalty of highly trained, skilled professionals is our key corporate asset. Red Arch Solutions is an Equal Opportunity Affirmative Action Employer.
