Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
Data Engineer NavitasPartners - 4.0 Philadelphia, PA Job Details Contract 12 hours ago Qualifications Data model design Commercial use (data warehousing systems) Performance tuning Cloud analytics services System troubleshooting System performance optimization Schema design SQL ETL process automation Business intelligence tools Cloud database architecture Version control systems System tuning Data performance optimization Python Data analytics technologies Dimensional modeling
Full Job Description Job Title:
Data Engineer Location:
Philadelphia, PA Job Type:
Long-Term Contract Work Setting:
Onsite Project Overview We are supporting a large-scale airport technology environment that requires 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 supporting airport operations, security, communications, and enterprise analytics. Successful candidates will play a key role in building and maintaining the data platforms that enable reliable reporting, operational intelligence, and data-driven decision-making across airport systems. Responsibilities Design, build, and maintain scalable ETL/ELT data pipelines using AWS services such as Glue, Lambda, S3, and Redshift to support enterprise analytics and reporting needs Develop and optimize SQL and Python-based data transformation logic to clean, standardize, and structure data for downstream analytics consumption Manage and maintain Amazon Redshift environments, including schema design, table structures, performance tuning, and storage optimization Monitor data pipelines and workflows to identify failures, latency issues, and data quality problems, and implement timely corrective actions Integrate data from multiple airport operational systems (such as AODB, QMS, FIDS, finance, HR, and concessions systems) into centralized data platforms Support Power BI datasets, data models, gateway configurations, and refresh processes to ensure consistent and reliable reporting performance Troubleshoot complex data ingestion, transformation, and warehouse performance issues across cloud and reporting layers Document data pipelines, system architectures, ETL processes, and data flow dependencies to ensure transparency and maintainability Support onboarding of new data sources and contribute to enhancements in data architecture and analytics platform capabilities Provide Tier 2/3 support for data ingestion, data warehouse, and BI dataset-related issues, ensuring timely resolution of production incidents Perform other related duties as assigned to support data engineering and analytics operations Requirements 3-7 years of experience in data engineering, ETL/ELT development, or cloud-based data integration roles Strong hands-on experience with AWS services including Glue, Lambda, S3, IAM, and Redshift Advanced SQL skills with strong proficiency in Python for data processing and automation Experience with data warehousing concepts including dimensional modeling, star schema design, and performance optimization Familiarity with Power BI datasets, data modeling, and refresh/performance tuning Understanding of enterprise or airport operational datasets (AODB, operations, finance, HR, concessions) is preferred Strong analytical and troubleshooting skills with ability to resolve complex data issues Experience with version control systems and documentation best practices Relevant certifications such as AWS Data Engineer or Power BI certifications are a plus
