Lead Associate, Data Architecture

Jobtailor; Deutschland; Remote; EUR 70.000 - 100.000; Vollzeit

Zusammenfassung

Peraton's Risk Decision Group seeks a data analytics professional to support data-driven decision-making for mission-critical programs. You will design, develop, and optimize analytic solutions, dashboards, and reports using Tableau Desktop and Power BI.

You will advance data pipelines with T-SQL, ETL in Python, and Tableau Prep, manage Tableau Server, and collaborate with business partners to translate complex data into actionable insights while upholding data governance and documentation.

Qualifikationen

• U.S. Citizenship required.
• Must obtain and maintain a T5/SSBI 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 Python for data cleaning, transformation, and automation.
• 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.

Aufgaben

• Support data-driven decision-making for mission-critical programs.
• Design, develop, and optimize analytic solutions for critical applications.
• Design, build, and maintain 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.

Kenntnisse

Tableau Desktop Expertise

Tableau Server Administration

Power BI Proficiency

Advanced SQL

Python for Data Automation

Data Warehousing Concepts

Database Performance Tuning

Data Modeling

ETL Processes

Git

Ausbildung

BS/BA

MS/MA

PhD

Tools

Tableau

Power BI

Python

AWS

Azure

GCP

Git

Jobbeschreibung

• 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