Aviation Data Analyst: SQL, Tableau & Data Quality

Tetra Tech; Washington, Northern (District of Columbia, KY); Hybrid; USD 70,000 - 100,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) matching

Flexible Spending Accounts

Tuition Assistance

Charitable matching

Job summary

Halvik Corp is seeking a Data Analyst to join the BTS contract team. You will support the administration of aviation-related statistical databases, performing data collection, editing, processing, and dissemination, and help maintain SOPs.

Work with Federal Data Administrators to validate datasets, run SQL queries, and develop dashboards in Tableau or Power BI. Strong communication and problem-solving skills, plus agile tools like Jira, are a plus.

Qualifications

• Minimum 1 year of specialized experience with relevant technical platforms.
• HS Diploma with 3 years of experience required.
• Working knowledge of SQL for data analysis, validation, and troubleshooting.

Responsibilities

• Monitor and manage data submissions and resubmissions via dashboards and system notifications.
• Review, analyze, and validate complex datasets using Tableau and cross-check with multiple sources.
• Analyze operational and market data including routes, passenger counts, carrier relationships, and reference datasets.
• Investigate underreporting/overreporting trends by comparing data against supporting datasets.
• Reference and validate raw source data to support troubleshooting and data quality initiatives.
• Release validated data products to internal teams and external stakeholders in line with processes.

Skills

Data analysis

SQL

Communication

Education

HS Diploma with 3 years experience

Tools

Tableau

Power BI

Jira

Job description

Halvik Corp is seeking a Data Analyst to join the BTS contract team. You will support the administration of aviation-related statistical databases, performing data collection, editing, processing, and dissemination, and help maintain SOPs.

Work with Federal Data Administrators to validate datasets, run SQL queries, and develop dashboards in Tableau or Power BI. Strong communication and problem-solving skills, plus agile tools like Jira, are a plus.