Data Integration Engineer

Red Arch Solutions; Reston (VA); On-site; USD 160,000 - 185,000; Full time

Job summary

Red Arch Solutions is seeking a Data Integration Engineer to design, develop, and maintain enterprise data pipelines supporting analytics and reporting. You will map and transform data, validate quality, and implement metadata and lineage within ingestion workflows.

The role emphasizes collaboration with Data Governance, Stewardship, Metadata, and Security teams, ensuring governance standards and data quality across the data lifecycle.

Qualifications

• Bachelor’s degree in computer science or related discipline.
• 12+ years of data engineering experience.
• Experience with Azure, AWS, or hybrid cloud environments.
• Strong knowledge of data integration patterns, data lifecycle management, and modern cloud-based data architecture.
• Experience implementing metadata capture, lineage tracking, tagging, and classification within data ingestion workflows.
• Experience supporting enterprise data catalogs and metadata management initiatives.

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.

Skills

Python

SQL

ETL/ELT Development

API Development

Azure Data Factory

Databricks

Data Modeling

Cloud Data Platforms

Data Validation and Testing

Education

Bachelor’s degree in computer science or related discipline

Tools

Azure Data Factory

Databricks

Cloud Platforms

Job description

Position Summary

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.

Required Skills

• Python
• SQL
• ETL/ELT Development
• API Development
• Azure Data Factory
• Databricks
• Data Modeling
• Cloud Data Platforms
• Data Validation and Testing

Desired Qualifications

• Bachelor’s degree in computer science or related discipline.
• 12+ years of data engineering experience.
• Experience with Azure, AWS, or hybrid cloud environments.

Salary range for this opening $160-185K #CJ