Data Integration Engineer with Security Clearance

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 TestingDesired 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  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 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.

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.