Signature Aviation’s Global Data Operations Team has an exciting opportunity for a motivated Data Warehouse Engineer to join our team and make significant contributions to designing, building, operating, and maintaining enterprise-level, scalable, and highly reliable data warehouse solutions. The Data Warehouse Engineer will work with a talented team to manage, deliver, and maintain data infrastructure, supporting custom applications and enterprise analytics systems. The right candidate will tackle high-priority challenges, leveraging expertise in Microsoft Azure and Databricks to support business intelligence, reporting, and advanced analytics.
Essential Duties and Responsibilities
Data Warehouse Architecture: Design, implement, and maintain scalable data warehouse environments using tools like Azure Synapse Analytics, Databricks, and Snowflake, ensuring high availability and performance.
- ETL/ELT Pipeline Development: Develop and optimize ETL/ELT pipelines using Azure Data Factory, Databricks, or dbt to integrate data from diverse sources, including structured and unstructured datasets.
- Security and Compliance: Ensure data warehouse solutions adhere to security and compliance best practices, implementing role-based access controls (RBAC), encryption, and compliance with regulations (e.g., GDPR, CCPA) in Azure and Databricks environments.
- Performance Optimization: Monitor and optimize data warehouse performance, including query execution, data storage, and cost efficiency, using Azure and Databricks tools.
- Collaboration: Work closely with data analysts, data scientists, business stakeholders, and IT teams to ensure seamless integration and delivery of data services.
- Troubleshooting: Identify and resolve issues related to data pipelines, warehouse performance, and integrations, ensuring minimal downtime and rapid recovery.
- Documentation: Develop and maintain technical documentation, including data models, ETL process flows, architecture diagrams, and operational procedures.
- Continuous Improvement: Stay up-to-date with emerging technologies, including advancements in Azure, Databricks, and other data platforms, to drive innovation and inform architectural decisions.
Minimum Education and/or Experience
Additional Knowledge and Skills
With more than 225 locations worldwide, Signature Aviation is the largest global network of private aviation terminals, delivering safe, convenient, and elevated experiences to those we serve. As a premier hospitality organization and a certified Great Place to Work™, we are committed to redefining private air travel. Our nearly 6,000-strong team of aviation experts and enthusiasts is dedicated to delivering excellence to our guests and communities, and it starts with taking care of our team. Signature provides a variety of benefits, programs, and resources to support our team members’ overall well-being and professional development. We proudly volunteer and give back, focusing on elevating the neighborhoods where we operate, empowering the next generation of aviation professionals, and supporting our veterans.
From your health to your financial wellness, there are several benefits for you and your family when joining Signature Aviation.
Our Benefits:
- Medical/prescription drug, dental, and vision Insurance
- Health Savings Account
- Flexible Spending Accounts
- Life Insurance
- Disability Insurance
- 401(k)
- Critical Illness, Hospital Indemnity and Accident Insurance
- Identity Theft and Legal Services
- Paid time off
- Paid Maternity Leave
- Tuition reimbursement
- Training and Development
- Employee Assistance Program (EAP) & Perks
Qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, or other protected characteristics.
