Data Engineer

Data Engineer

Remote

Tri state are

Top Skills :

Strong SQL

Python

Snowflake

Azure Products

Position Summary

The Data Engineer is responsible for integrating and modeling data in modern data stack to support analysts, business intelligence users, data scientists, and decision-makers across the company. The Data Engineer must have a deep understanding of Structured Query Language (SQL) and be familiar with Snowflake, dbt (data build tool), and git version control. In this role, the Data Engineer collaborates with stakeholders across the company to understand and address their needs. The Data Engineer must enjoy working with others and be comfortable expressing ideas in a public setting. The Data Engineer reports to the Manager of IT Data Engineering.

Essential Responsibilities

Work with business stakeholders to understand problems and data sources, playing the pivotal role of architecting data models to address Crewmember needs

Gather requirements, build roadmaps, and write great documentation for data sources that need to be modeled

Build Extract, Load, Transform (ELT) jobs based on jointly defined requirements

Perform end-to-end unit testing & code reviews to promote data integrity across a variety of products built by the development team

Support bug fixing and performance analysis along the data pipeline, including writing tests & coordinating with Quality Assurance teams

Be comfortable presenting to large groups & expressing ideas in public settings with high visibility

Be a strong advocate for a culture of process and data quality across development teams

Follow an agile development methodology

Other duties as assigned

Minimum Experience and Qualifications :

Bachelor's Degree in Mathematics, Operations Research, Statistics, Computer Science, Engineering, or Physics; OR demonstrated capability to perform job responsibilities with a combination of a High School Diploma / GED and at least four (4) years of previous relevant work experience

Three (3) years of relevant experience in a data role working with data warehouses and business intelligence tools

Proven experience with dbt (data build tool) & Snowflake

Strong SQL skills

Experience with modern ELT orchestration tools like Azure Data Factory or Airflow

Experience with git and git-based workflows

Available for occasional overnight travel (10%)

Must pass a pre-employment drug test

Must be legally eligible to work in the country in which the position is located

Authorization to work in the US is required. This position is not eligible for visa sponsorship

Preferred Experience and Qualifications

Experience implementing best-practices for data modelling, especially with regards to dimensional modelling for business intelligence

Basic Python skills

Proven track record of successfully contributing to a project that transitioned a large enterprise to a new cloud data warehouse, like Snowflake

Prior airline experience

Crewmember Expectations :

Regular attendance and punctuality

Potential need to work flexible hours (including nights & weekends) and be available to respond on short-notice

Able to maintain a professional appearance

Crewmembers are asked to assist with light cleaning of the aircraft

Management System (SMS) components, Safety Policy and behavioral standards