Data Analyst ETL Specialist

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

Job summary

A leading IT solutions provider in Virginia is looking for a Data Analyst / ETL Specialist. This role involves identifying and onboarding datasets into the Zero Trust environment, developing workflows, and ensuring stakeholder engagement. Applicants should have significant experience in data analysis or data science, proficiency in Python, and an active TS/SCI with Polygraph. This position offers an opportunity to work on critical national security projects within an innovative and collaborative team environment.

Qualifications

• 16 years of experience in IT.
• Minimum 5 years in data analysis or data science.
• Active TS/SCI with Polygraph.

Responsibilities

• Identify and onboard datasets into the ZT environment.
• Prepare dataset registrations with data stewards.
• Develop reporting requirements to track ZT service adoption.

Skills

Python for data manipulation

Data visualization (Tableau, Splunk)

ETL pipeline development

Analytical skills

Documentation skills

Education

Bachelor's degree in a relevant field

Master's degree preferred

Tools

GitLab

ServiceNow

Databricks

Job description

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.

Position Overview

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.

Key Responsibilities

• 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 GitLab in accordance with the ZT Program's GitLab 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

Required Qualifications

• 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

Preferred Qualifications

• 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 (SageMaker, 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 GitLab for documentation and version control
• Experience using ServiceNow or Databricks in a data management context
• Machine learning background with classification/regression experience

Education

• Bachelor's degree in a relevant field preferred (Computer Science, Data Science, Information Systems, Analytics, or related discipline) (4 years of experience and be used in lieu of a BS degree)
• Master's degree preferred; equivalent professional experience may be considered in place of an advanced degree (6 years of experience can be used in lieu of a MS degree)

Core Competencies

• Ability to operate with limited supervision in a fast-paced, mission-driven environment
• Strong stakeholder engagement skills with experience facilitating cross-team collaboration
• Proactive, detail-oriented approach to documentation and process development
• Demonstrated ability to respond to high-priority tasks on short notice with high-quality deliverables