Data Integration Engineer

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

Benefits offered by this job

Health insurance

401K with company match

Performance bonus

Tuition reimbursement

Paid holidays

Generous PTO

Job summary

Red Arch Solutions, Inc. is seeking a Data Integration Engineer in Reston, VA to design, develop, and maintain data integration pipelines supporting analytics, sharing, and reporting.

This role emphasizes data mapping, transformation, normalization, quality validation, and governance collaboration with cross-functional teams. The candidate will work with Data Governance, Stewardship, Metadata, and Security teams to ensure standards compliance and metadata capture.

Qualifications

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

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

AWS

Hybrid cloud

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

Benefits Snapshot

• 100% paid employee healthcare premiums. CareFirst Advantage Best in Class Benefits.
• HaloScripts Concierge prescription medication service
• Generous PTO.
• 10 % 401K 6% match vested day one and up to 4% profit sharing contribution.
• Annualized bonus compensation.
• Spot bonuses for hard work.
• Tuition reimbursement.
• 529 College Saving Plan.
• College Loan Pay Back Program.
• 11 Paid Federal Holidays
• Generous Referral Bonuses.

The Red Arch Solutions pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Determination of official compensation or salary relies on several factors including, but not limited to, level of position, job responsibilities, geographic location, scope of relevant work experience, educational background, certifications, contract-specific affordability, organizational requirements, alignment with local internal equity as well as alignment with market data.

Red Arch Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

Have more questions about Red Arch? Email us at [e-mail]