Data Analyst

Tetra Tech; Washington, Northern (District of Columbia, KY); On-site; 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 delivers a wide range of services to 13 executive agencies and 15 independent agencies. Halvik is a highly successful WOB business with more than 50 prime contracts and 500+ professionals delivering Digital Services, Advanced Analytics, Artificial Intelligence/Machine Learning, Cyber Security and Cutting-Edge Technology across the US Government. Be a part of something special!

Position Overview

We are looking for a Data Analyst to join the BTS contract team at Halvik. Under the direction of Federal Data Administrators, assists in all activities related to the administration of computerized aviation-related statistical databases. This includes the activities of data collection, editing, processing, and dissemination functions, and maintaining Standard Operating Procedures (SOP) for same. Additionally, assists the OAI Data Administrators in the formulation and/or implementation of policies and procedures pertaining to database management, processing, security maintenance, and dissemination. In consultation with OAI Data Administrators, exercise judgment in resolving technical problems and issues that arise relative to aviation-related data processing, editing, and dissemination. In consultation with OAI Data Administrators, consults with and advises database users relative to procedures, technical problems, priorities, and methodologies.

Core Responsibilities

• Monitor and manage incoming data submissions and resubmissions through dashboards, reports, and system notifications.
• Review, analyze, and validate complex datasets using Tableau reports and cross-reference multiple data sources to identify discrepancies, reporting issues, and data quality concerns.
• Analyze and verify operational and market data, including routes, passenger counts, carrier relationships, codeshare/interline relationships, and related reference datasets.
• Investigate underreporting and overreporting trends by comparing submitted data against supporting operational and market datasets.
• Reference and validate raw source data to support troubleshooting, issue resolution, and data quality initiatives.
• Maintain and update operational support tables and reference datasets, including carriers, routes, airports, and associated relationships.
• Reprocess data submissions and coordinate corrective actions, issue resolution, and resubmission activities with stakeholders and external partners.
• Write and execute beginner to intermediate SQL queries for data validation, analysis, troubleshooting, and reporting support.
• Collaborate with business users, external stakeholders, and carriers to resolve submission issues, communicate data corrections, and support ongoing operational processes.
• Release validated data products to internal teams, external stakeholders, buyers, and public-facing users in accordance with established processes and timelines.
• Support backlog prioritization and collaborate with cross-functional teams to align deliverables with business objectives and data quality goals.
• Assist in preparing and presenting routine and ad hoc project status reports, metrics, dashboards, and stakeholder updates.
• Coordinate project documentation activities, including maintaining templates, meeting agendas, meeting minutes, action items, and centralized document repositories.
• Ensure all project guidance, deliverables, work products, and supporting documentation are current, organized, and accessible within shared collaboration platforms.
• Support business analysis and data quality initiatives involving complex, highly dynamic datasets with continuously changing schedules, sampling methodologies, and carrier agreements.

Education

• Must have a minimum of 1 year of specialized experience with the relevant technical/ platform in addition to any required applicable training.
• Minimum Education/Experience: HS Diploma with 3 years of experience.
• Working knowledge of SQL for data analysis, validation, and troubleshooting

Preferred Expertise

• Strong written and verbal communication skills with the ability to translate business needs into clear functional and technical requirements.
• Strong analytical and problem-solving capabilities.
• Experience with Agile methodologies and tools such as Jira.
• Experience using visualization tools like Tableau or Power BI.

Halvik offers a competitive full benefits package including:

• Company-supported medical, dental, vision, life, STD, and LTD insurance
• Benefits include 11 federal holidays and PTO
• Eligible employees may receive performance-based incentives in recognition of individual and/or team achievements.
• 401(k) with company matching
• Flexible Spending Accounts for commuter, medical, and dependent care expenses
• Tuition Assistance
• Charitable Contribution matching

Halvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.