Data Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Assist in data-driven decision-making for essential missions within Peraton's Risk Decision Group

• Create, develop, and enhance analytical solutions for mission-critical applications

• Convert raw data into valuable insights

• Build scalable dashboards and facilitate enterprise reporting initiatives

• Craft advanced T-SQL queries, stored procedures, functions, views, and triggers

• Evaluate execution plans, indexing strategies, and performance plans

• Analyze, ingest, and/or rectify data within an Enterprise Data Warehouse

• Develop and refine data workflows and ETL processes utilizing Tableau Prep and Python

• Oversee content, permissions, data sources, and performance optimization within Tableau and SQL Server

• Extract, manipulate, and analyze structured and unstructured data using complex SQL queries

• Collaborate with business partners to comprehend data requirements and provide actionable insights

• Ensure data accuracy, consistency, and quality through validation and testing

• Support BI governance, documentation, and best practices for the analytics environment

• Automate recurring reporting tasks utilizing Python or SQL-based solutions

• Design, build, and sustain advanced Tableau dashboards and reports

⛳️ Requirements

• U.S. Citizenship is required

• Must be capable of obtaining and maintaining a T5/SSBI federally adjudicated clearance

• Minimum of 5 years of experience with a BS/BA; minimum of 3 years with an MS/MA; 0 years with a PhD

• Advanced SQL skills with experience in querying large datasets

• Experience in designing, creating, implementing, and optimizing database indexes

• Familiarity with database performance tuning, query execution plans, performance bottlenecks, and SQL query optimization

• Experience in designing, developing, and supporting an Enterprise Data Warehouse

• Proficiency in business analytics and converting complex data into actionable insights

• Experience in creating SOPs and comprehensive workflow/process documentation

• Excellent analytical, troubleshooting, and communication skills

• Preferred: Tableau Prep, Tableau Desktop, and Tableau Server administration

• Preferred: Databricks

• Preferred: Python for data cleaning, transformation, and automation

• Preferred: AI and machine learning

• Preferred: APIs, scripting, or workflow orchestration tools

• Preferred: Version control systems such as Git

• Preferred: Data governance, metadata management, or enterprise BI strategy

• Preferred: Cloud technologies such as AWS

• Ability to translate business requirements into insightful solutions

• Strong collaboration skills with both technical and non-technical teams

• Clear documentation and communication skills in fast-paced environments

• Ability to adapt to an ever-changing environment

• Ability to manage multiple projects and prioritize tasks as necessary

🏝️ Benefits

• Medical insurance

• Dental insurance

• Vision insurance

• Life insurance

• Health savings account

• Short-term disability

• Long-term disability

• Employee assistance program (EAP)

• Parental leave

• 401(k)

• Paid time off (PTO) for vacation

• Company paid holidays

• Eligible employees may qualify for overtime, shift differential, and a discretionary bonus in addition to base pay