Position Title : Data Engineer (LSC)
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 experienceThree (3) years of relevant experience in a data role working with data warehouses and business intelligence toolsProven experience with dbt (data build tool) & SnowflakeStrong SQL skillsExperience with modern ELT orchestration tools like Azure Data Factory or AirflowExperience with git and git-based workflowsAvailable for occasional overnight travel (10%)Must pass a pre-employment drug testMust be legally eligible to work in the country in which the position is locatedAuthorization to work in the US is required. This position is not eligible for visa sponsorshipPreferred Experience and Qualifications
Experience implementing best-practices for data modelling, especially with regards to dimensional modelling for business intelligenceBasic Python skillsProven track record of successfully contributing to a project that transitioned a large enterprise to a new cloud data warehouse, like SnowflakePrior airline experienceCrewmember Expectations :
Regular attendance and punctualityPotential need to work flexible hours (including nights & weekends) and be available to respond on short-noticeAble to maintain a professional appearanceWhen working or traveling on JetBlue flights, and if time permits, all capable Crewmembers are asked to assist with light cleaning of the aircraftMust be an appropriate organizational fit for the JetBlue culture, that is, exhibit the JetBlue values of Safety, Caring, Integrity, Passion and FunPromote JetBlue's #1 value of safety as a Safety Ambassador, supporting JetBlue's Safety Management System (SMS) components, Safety Policy and behavioral standardsIdentify 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 equipmentWork Environment :
Traditional office environmentPhysical 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.LI-JC1
LI-Hybrid
Salary : $100,000 - $128,600
