JetBlue is looking to integrate and model data in its modern data stack to support various business functions and decision-making processes.
Requirements
- Deep understanding of Structured Query Language (SQL)
- Familiar with Snowflake
- Familiar with dbt (data build tool)
- Familiar with git version control
- 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
- 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
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 a strong advocate for a culture of process and data quality across development teams
- Follow an agile development methodology
Other
- The Data Engineer must enjoy working with others and be comfortable expressing ideas in a public setting.
- Be comfortable presenting to large groups & expressing ideas in public settings with high visibility
- 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
- Prior airline experience
- 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))
