Data Analyst ETL Specialist

Red Arch Solutions is a proven and effective small business IT integrator and consultant, recognized as a leading IT provider for the Federal Government, primarily focused within the Intelligence Community. We provide state‑of‑the‑art tactical and strategic intelligence, systems, and software engineering solutions, addressing some of the most pressing and unique challenges related to national security.

Our employees are exceptionally skilled professionals 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 an official AWS Partner and 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 role will identify, register, and onboard discrete datasets into the ZT environment, develop data onboarding workflows, and build reporting capabilities to track adoption of ZT services. The position 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 W’s 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, including developing requirements from user needs and 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 automated data tagging or classification.
• Familiarity with Git Lab for documentation and version control.
• Experience using Service Now or…