> Markdown version of [/jobs/ext/2862195-data-architecture-lead-associate](https://www.wearedevelopers.com/jobs/ext/2862195-data-architecture-lead-associate). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Architecture, Lead Associate - **Company:** Peraton Inc - **Location:** Reston, VA, United States (Remote available) - **Experience:** Expert - **Salary:** $66,000.0 - $106,000.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Application Programming Interfaces (APIs), Amazon Web Services, Microsoft Azure, Big Data, Cloud Computing, Data Architecture, Data Cleansing, Data Governance, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Python (Programming Language), Meta-Data Management, Performance Tuning, Power BI, SQL Stored Procedures, SQL Databases, Tableau (Software), Transact-SQL, Unstructured Data, Workflow Management Systems, Scripting, Freeform SQL, Google Cloud, Data Storage Technologies, Sql Optimization, Database Optimization, Database Performance, Git, Software Version Control - **Published:** September 12, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/18284719?backUrl=%2Fcareer%2F18284719%2FData-Architecture-Lead-Associate-Virginia-Reston ## About the Role * 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. * 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. * 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 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 * Experience with cloud platforms (AWS, Azure, GCP). * Experience using R for statistical modeling or advanced analytics. * 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, Azure, or GCP) 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. ## Description Peraton is hiring a full-time Data Architect to support data-driven decision-making for critical missions within Peraton's Risk Decision Group., 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 Tableau Prep, Tableau Desktop, Tableau Server, Power BI, SQL, and Python. 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., 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. * 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. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)