Data Engineer

Position Summary

The Data Engineer is responsible for integrating and modeling data in JetBlue’s 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
• When working or traveling on JetBlue flights, and if time permits, all capable Crewmembers are asked to assist with light cleaning of the aircraft
• Must be an appropriate organizational fit for the JetBlue culture, that is, exhibit the JetBlue values of Safety, Caring, Integrity, Passion and Fun
• Promote JetBlue’s #1 value of safety as a Safety Ambassador, supporting JetBlue’s Safety Management System (SMS) components, Safety Policy and behavioral standards
• Identify safety and/or security concerns, issues, incidents or hazards that should be reported and report them whenever possible and by any means necessary including JetBlue’s confidential reporting systems (Aviation Safety Action Program (ASAP) or Safety Action Report (SAR))

Equipment:

• Computer and other office equipment

Work Environment:

• Traditional office environment

Physical Effort:

• Generally not required, or up to 10 pounds occasionally, 0 pounds frequently. (Sedentary)

Compensation:

• The base pay range for this position is between $100,000.00 and $128,600.00 per year. Base pay is one component of JetBlue’s total compensation package, which may also include access to healthcare benefits, a 401(k) plan and company match, crewmember stock purchase plan, short-term and long-term disability coverage, basic life insurance, free space available travel on JetBlue, and more.