Data Engineer

Data Engineer Remote Tri State AreaTop Skills:Strong SQLPythonSnowflakeAzure ProductsPosition SummaryThe 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 ResponsibilitiesWork 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 assignedMinimum Experience and QualificationsBachelor'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 sponsorshipPreferred Experience and QualificationsExperience 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 experienceCrewmember ExpectationsRegular 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