About FlightSafety International
FlightSafety International is the world’s premier professional aviation training company and supplier of flight simulators, visual systems and displays to commercial, government and military organizations. The company provides training for pilots, technicians and other aviation professionals from 167 countries and independent territories. FlightSafety operates the world’s largest fleet of advanced full-flight simulators and award-winning maintenance training at Learning Centers and training locations in the United States, Canada, France and the United Kingdom.
Purpose of Position
The Lead Data Engineer is a hands-on technical leader responsible for architecting, developing, and guiding the implementation of modern data solutions in a cloud-based environment. This role provides technical leadership to Senior Data Engineers and Senior Analytics Engineers , ensuring best practices in data engineering, analytics, and reporting. The Lead Data Engineer plays a key role in strategic initiatives, driving the design and delivery of scalable data platforms, and enabling actionable insights through advanced Power BI dashboards and reports.
Tasks and Responsibilities
- Serve as the technical lead on data engineering and analytics initiatives, ensuring alignment with architectural standards and business goals
- Provide technical mentorship and guidance to Senior Data Engineers and Senior Analytics Engineers
- Design and implement scalable ETL / ELT pipelines using Azure Data Factory (ADF) , Databricks , and DBT
- Lead the development of Data Vault 2.0 models and ensure consistency across projects
- Architect and orchestrate data workflows using Databricks LakeFlow , Apache Airflow , and ADF
- Oversee data ingestion and replication strategies using tools such as Fivetran, SQDR, Rivery, or custom Python scripts
- Develop and optimize Power BI dashboards, reports, and semantic models to support business intelligence and self-service analytics
- Collaborate with business stakeholders, architects, and analysts to translate requirements into technical solutions
- Ensure data quality, governance, and security standards are met across all data products
- Lead code reviews, enforce development standards, and promote best practices in data engineering and analytics
- Support CI / CD automation, DevOps practices, and version control for data pipelines and reporting assets
- Troubleshoot and resolve complex data issues in production and development environments
- Contribute to enterprise data strategy and participate in architectural review boards
- Maintain documentation for data architecture, pipelines, and reporting solutions
- Infrequent travel as needed
Minimum Education
Bachelor's degree from an accredited institution or equivalent industry experienceMinimum Experience
12+ years of experience in data engineering or software development roles3+ years in a technical leadership or lead engineer capacity5+ years of experience with Azure Data Factory and Azure Data Lake Storage3+ years of experience with Databricks , Delta Live Tables , and Unity Catalog3+ years of experience with Power BI dashboard and report development2+ years of experience with DBT and Apache AirflowExperience with Data Vault 2.0 modeling (certification preferred)Strong experience with Python, PySpark, and SQLKnowledge, Skills, Abilities
Deep expertise in cloud data platforms , especially Azure and DatabricksStrong understanding of ELT / ETL , data modeling, and data warehousing principlesProven ability to lead and mentor technical teams in a collaborative environmentAdvanced skills in Power BI , including DAX, Power Query, and data modelingExperience with data ingestion and replication tools (e.g., Fivetran, SQDR, Rivery)Proficiency in Python, PySpark, and SQL for data transformation and automationExperience orchestrating workflows using Apache Airflow and Databricks LakeFlowFamiliarity with DevOps, CI / CD pipelines, and version control systems (Git, TFS)Strong communication and stakeholder engagement skillsKnowledge of data governance, metadata management, and compliance frameworksExperience with Agile / Scrum methodologiesExposure to AI / ML tools and concepts within Databricks is a plusExperience in Education or Aviation industries is a plus