Data Analyst

NavitasPartners offers an onsite contract Data Analyst opportunity in Philadelphia, focusing on a large-scale airport technology environment. You will deliver data-driven insights through dashboards and analytics, collaborating with stakeholders to translate requirements into effective BI solutions across airport operations.

Responsibilities

• Design and develop Power BI dashboards, reports, and visualizations using data from Redshift, S3, and other enterprise data platforms
• Develop and maintain DAX calculations, semantic models, and streamlined datasets to enable efficient reporting and analytics
• Analyze data to support airport operations and business units, identifying trends, patterns, and actionable insights
• Develop and optimize SQL queries to extract, validate, and analyze data from Redshift and related sources
• Collaborate with stakeholders to collect reporting requirements and translate them into meaningful dashboards and KPIs
• Clean, validate, and transform data to ensure accuracy, consistency, and reliability for reporting use cases
• Document KPI definitions, dashboard logic, data mappings, and specifications to support governance and standardization
• Conduct ad hoc analyses, forecasting, and trend analysis to inform operational and strategic decisions
• Collaborate with Data Engineers to address data quality issues, schema changes, and model enhancements
• Support operational reporting, performance monitoring, and department analytics across airport functions
• Assist with additional duties as needed to support analytics and reporting initiatives

Requirements

• 3–6 years of experience in data analysis, business intelligence, or analytics roles
• Proficiency in Power BI with experience building dashboards, DAX measures, and data modeling
• Advanced SQL skills with experience in cloud data warehouses such as Amazon Redshift
• Experience handling large datasets and performing data cleaning, validation, and transformation
• Strong analytical and problem-solving abilities with meticulous attention to data accuracy
• Ability to translate business requirements into technical reporting solutions
• Familiarity with data warehousing concepts and dimensional modeling is preferred
• Strong communication skills for collaboration with technical teams and business stakeholders
• Experience in enterprise, transportation, or operational environments is a plus

Technologies

• Power BI
• DAX
• SQL
• Amazon Redshift
• S3

Project overview

The project supports a large-scale airport technology environment requiring skilled IT professionals to support, maintain, and enhance critical systems across multiple airport facilities. These long-term contract roles operate within a complex, mission-critical infrastructure that underpins airport operations, security, communications, and enterprise analytics. Successful candidates will help deliver accurate, timely, and actionable insights that enable data-driven decision making.