Data Architect

Peraton; Herndon (VA); Remote; USD 66,000 - 106,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k)

PTO + holidays

Parental leave

Job summary

Peraton is hiring a Data Architect to support data-driven decision-making within the Risk Decision Group. The role is 100% remote and focuses on designing, developing, and optimizing analytic solutions for mission-critical applications using SQL, Tableau, and Python.

Strong data preparation, visualization, and automation experience is required. The ideal candidate has hands-on experience with EDW, performance tuning, and enterprise reporting, plus the ability to translate data into actionable

Qualifications

• U.S. Citizenship required.
• Able to obtain and maintain T5/SSBI clearance.
• Minimum 5 years with BS/BA; 3 years with MS; 0 years with PhD.
• Advanced SQL skills and experience querying large datasets.
• Experience designing and optimizing database indexes for performance.
• Hands-on with Enterprise Data Warehouse development and support.
• Ability to translate data into clear, actionable insights for non-technical users.
• Experience creating SOPs and detailed documentation for workflows.

Responsibilities

• Develop advanced T-SQL queries, procedures, functions, views, and triggers.
• Review execution plans and indexing strategies for performance.
• Ingest and correct data within an EDW.
• Develop data workflows and ETL using Tableau Prep and Python.
• Manage content, permissions, data sources, and performance in Tableau and SQL Server.
• Write complex SQL to extract and analyze structured and unstructured data.
• Collaborate with partners to understand data needs and deliver insights.
• Ensure data quality and governance across analytics environment.
• Automate recurring reporting tasks using Python or SQL-based solutions.
• Design and maintain advanced dashboards and reports in Tableau.

Skills

Advanced SQL

Query tuning

Analytics

Documentation

Communication

Collaboration

Education

BS/BA in related field

MS/MA

Tools

SQL

Tableau Prep

Tableau Desktop

Tableau Server

Python

Databricks

Git

Job description

Data Architect

Job Locations

US

Peraton Overview

Peraton is a next‑generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.

Responsibilities

Peraton is hiring a full‑time Data Architect to support data‑driven decision‑making for critical missions within Peraton's Risk Decision Group.

This position will be 100% remote.

This role focuses on designing, developing, and optimizing analytic solutions to support mission‑critical applications. The ideal candidate will have strong technical expertise in data preparation, visualization, and automation, with hands‑on experience in SQL, Tableau Prep, Tableau Desktop, Tableau Server. This role will be responsible for transforming raw data into meaningful insights, developing scalable dashboards, and supporting enterprise reporting initiatives. This position will be 100% remote.

Responsibilities

• Develop advanced T‑SQL queries, stored procedures, functions, views, and triggers.
• Review execution plans, indexing strategies, performance plans
• Analyze, ingest and/or correct data within an EDW.
• Develop and optimize data workflows and ETL processes using Tableau Prep and Python.
• Manage content, permissions, data sources, and performance tuning within Tableau and SQL Server.
• Write complex SQL queries to extract, manipulate, and analyze structured and unstructured data.
• Collaborate with business partners to understand data needs and deliver actionable insights.
• Ensure data accuracy, consistency, and quality through rigorous validation and testing.
• Support BI governance, documentation, and best practices across the analytics environment.
• Automate recurring reporting tasks using Python or SQL‑based solutions.
• Design, build, and maintain advanced dashboards and reports using Tableau.

Qualifications

Required Qualifications

• U.S. Citizenship required.
• Must be able to obtain and maintain a T5/SSBI federally adjudicated clearance
• Minimum of 5 years with BS/BA; Minimum of 3 years with MS/MA; 0 years with PhD
• Advanced SQL skills with experience querying large datasets.
• Demonstrated experience in designing, creating, implementing, and optimizing database indexes to improve query performance.
• Hands on experience with database performance tuning, including analyzing query execution plans, identifying performance bottlenecks, optimizing SQL queries, and recommending solutions to improve database performance.
• Hands‑on experience designing, developing, and supporting an Enterprise Data Warehouse.
• Expertise in business analytics and translating complex data into clear actionable insights for non-technical users.
• Hands‑on experience with creating SOP's and extensive documentation for workflows and processes.
• Excellent analytical, troubleshooting, and communication skills.

Preferred Qualifications

• Expertise in Tableau Prep, Tableau Desktop, and Tableau Server administration.
• Expertise with Databricks.
• Working experience using Python for data cleaning, transformation, and automation.
• Familiarity with AI and machine learning.
• Knowledge of APIs, scripting, or workflow orchestration tools.
• Experience with version control systems such as Git.
• Familiarity with data governance, metadata management, or enterprise BI strategy.
• Familiarity with cloud technologies (AWS) for data storage, compute, or analytics.

Soft Skills

• Ability to translate business needs into insightful solutions.
• Strong collaboration skills across technical and non-technical teams.
• Clear documentation and communication in fast‑paced environments.
• Ability to adapt to a constantly changing environment while creating consistency and logic among projects.
• Ability to work multiple projects at once and adjust priorities as needed by the business.

#RDG

Target Salary Range

$66,000 - $106,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual's experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.

Benefits Statement

Peraton offers eligible employees a variety of benefits including medical, dental, vision, life, health savings account, short/long term disability, EAP, parental leave, 401(k), paid time off (PTO) for vacation, and company paid holidays. A full listing of available benefits can be viewed at https://www.careers.peraton.com/benefits.

EEO

EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.