Lead Associate, Data Architecture

• Support data-driven decision-making for critical missions within Peraton's Risk Decision Group
• Design, develop, and optimize analytic solutions for mission-critical applications
• Design, build, and maintain advanced dashboards and reports using Tableau Desktop and Power BI
• Develop advanced T-SQL queries, stored procedures, functions, views, and triggers
• Develop and optimize data workflows and ETL processes using Tableau Prep and Python
• Manage content, permissions, data sources, and performance tuning within Tableau Server
• Extract, manipulate, and analyze structured and unstructured data using complex SQL queries
• 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

Requirements

• 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
• Expertise in Tableau Prep, Tableau Desktop, and Tableau Server administration
• Strong proficiency in Power BI, including DAX, data modeling, and workspace management
• Advanced SQL skills with experience querying large datasets
• Experience designing, creating, implementing, and optimizing database indexes
• Hands‑on experience with database performance tuning, including analyzing query execution plans, identifying performance bottlenecks, optimizing SQL queries, and recommending solutions
• Working experience using Python for data cleaning, transformation, and automation
• Hands‑on experience designing, developing, and supporting an Enterprise Data Warehouse
• Expertise in business analytics and translating complex data into actionable insights for non-technical users
• Hands‑on experience creating SOPs and extensive documentation for workflows and processes
• Excellent analytical, troubleshooting, and communication skills
• Preferred: experience with AWS, Azure, or GCP
• Preferred: experience using R for statistical modeling or advanced analytics
• Preferred: knowledge of APIs, scripting, or workflow orchestration tools
• Preferred: experience with Git
• Preferred: familiarity with data governance, metadata management, or enterprise BI strategy
• Preferred: familiarity with 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
• Ability to manage multiple projects and adjust priorities as needed

Core Competencies

Demonstrates expertise in data analytics, including advanced SQL, Tableau, and Power BI, to support data-driven decision-making and deliver actionable insights. Proficient in developing and optimizing ETL processes and managing data workflows while ensuring data quality and governance.

Highest-signal resume keywords

• Tableau Desktop Expertise
• Advanced SQL Skills
• Power BI Proficiency
• Python for Data Automation
• Data Governance Knowledge

ATS Optimization Keywords

Hard Skills

• Advanced SQL
• Tableau Prep
• Tableau Server Administration
• Power BI
• ETL Processes
• Data Warehousing
• Database Performance Tuning
• DAX
• Data Modeling
• Data Analysis

Soft Skills

• Analytical Skills
• Troubleshooting Skills
• Communication Skills
• Collaboration Skills
• Adaptability

Certifications & Qualifications

• U.S. Citizenship
• T5/SSBI Clearance

Industry Keywords

• Business Analytics
• Data Governance
• Metadata Management
• Enterprise BI Strategy
• SOP Creation

Tools & Technologies

• Tableau
• Power BI
• Python
• AWS
• Azure
• GCP
• Git