Data Architect

Peraton•,

12d•$66,000 - $106,000•Remote

About The Position

Peraton is hiring a full-time Data Architect to support data-driven decision-making for critical missions within its Risk Decision Group. The position is 100% remote and focuses on designing, developing, and optimizing analytic solutions for mission-critical applications. The role transforms raw data into useful insights, develops scalable dashboards, and supports enterprise reporting initiatives, using SQL, Tableau Prep, Tableau Desktop, Tableau Server, and related tools.

Requirements

U.S. citizenship.
Ability to obtain and maintain a T5/SSBI federally adjudicated clearance.
Minimum of 5 years of experience with a bachelor's degree; minimum of 3 years with a master's degree; or 0 years with a Ph.D.
Advanced SQL skills and experience querying large datasets.
Demonstrated experience 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 performance improvements.
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 creating SOPs and extensive workflow and process documentation.
Excellent analytical, troubleshooting, and communication skills.

Nice To Haves

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 AWS cloud technologies for data storage, compute, or analytics.
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 on multiple projects at once and adjust priorities as needed by the business.

Responsibilities

Develop advanced T-SQL queries, stored procedures, functions, views, and triggers.
Review execution plans, indexing strategies, and performance plans.
Analyze, ingest, and/or correct data within an enterprise data warehouse (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 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 Tableau dashboards and reports.

Benefits

Medical benefits
Dental insurance
Vision insurance
Life insurance
Health savings account
Short- and long-term disability
Employee Assistance Program (EAP)
Parental leave
401(k)
Paid time off (PTO) for vacation
Company-paid holidays
Potential overtime, shift differential, and discretionary bonus eligibility, depending on the position