Data Analyst ETL Specialist

Red Arch Solutions is a proven and effective small business IT integrator and consultant, recognized as a leading IT provider to the Federal Government, primarily focused within the Intelligence Community. We provide our 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. We recruit individuals who are dedicated to collecting, analyzing, and disseminating critical information to national leaders. Our engineers design, develop, and deploy mission‑critical solutions to support our war fighters. We are also an official AWS Partner and are pleased to now offer Cloud Solutions Architecture and Engineering using Amazon Web Services.

The Data Analyst / ETL Specialist will serve as a core member of the Data Onboarding Team supporting the Client’s Zero Trust (ZT) Data Environment initiative. This individual will be responsible for identifying, registering, and onboarding discrete datasets into the ZT environment, developing data onboarding workflows, and building reporting capabilities to track adoption of ZT services. The role requires close collaboration with data stewards, governance teams, and ZT Core Services personnel in a dynamic, mission‑focused environment.

• Support the identification of discrete datasets for registration into the ZT Ecosystem, prioritizing resources in accordance with government‑directed priority order
• Assist Data Stewards in preparing and submitting dataset registrations; ensure data is accurately characterized using the 5 Ws framework (Who, What, When, Where, Why)
• Develop and document a comprehensive Data Onboarding Process covering all required steps from dataset identification through ingestion into the ZT Ecosystem (e.g., Visio‑type diagram and accompanying SOP)
• Gather and incorporate stakeholder feedback from data governance teams and ZT Core Services during onboarding process development
• Develop reporting requirements in coordination with stakeholders to support visibility into ZT service adoption across the client organization and external audiences
• Build and maintain a reporting capability specifically covering data onboarding and ingestion metrics
• Maintain all task documentation and artifacts in Git Lab in accordance with the ZT Program’s Git Lab standards
• Support monthly status briefs and quarterly Program Management Reviews (PMRs) as required
• Perform ETL operations including data extraction, transformation, cleaning, and loading to support onboarding activities
• Develop visualizations and dashboards to communicate data trends and onboarding progress to senior stakeholders and decision makers

• 16 years of experience. Experience developing requirements based on needs obtained from users. Experience building scripts to manipulate data for ingestion into databases.
• Minimum 5 years of experience in data analysis, data science, or a related field
• Demonstrated proficiency in Python for data manipulation, automation, and ETL processes
• Experience with data visualization tools such as Tableau, Splunk, Oracle DV, or Qlik
• Strong background in ETL pipeline development and data mining
• Familiarity with Agile project management environments (JIRA, Confluence, or similar)
• Experience working with and briefing senior‑level stakeholders and decision makers
• Strong analytical and written communication skills; ability to translate complex data processes into clear, consumable documentation
• Experience developing SOPs, process flows, or similar documentation artifacts
• Active TS/SCI with Polygraph

• Experience supporting federal government or intelligence community programs
• Familiarity with Zero Trust architecture concepts, particularly as they relate to data governance and access control
• Experience with AWS services (Sage Maker, Comprehend, S3) or cloud‑based data environments
• Knowledge of data governance frameworks and metadata management practices
• Experience with Natural Language Processing (NLP) for…