JetBlue Airways Corporation: Engineer IT Quality Data – Long Island City, NY
DUTIES:
- Collaborate with multiple teams to ensure data integrity and validation using the right tools and automation.
- Be proficient in pre-screening raw data, vital checks on completeness and integrity of data, field tests on Aggregation,
- Reconciliation tests and Report testing.
- Evaluate the quality of data received from data sources to ensure that it meets company standards.
- Review Data Models, Data Mappings, and Architectural Documentation to execute effective system integration testing.
- Work closely with Business Analysts, Architects, Development team and Product Owners to ensure data housed in multiple source systems is loaded to target accurately.
- Develops validation scripts for automated execution, while creating actionable data quality reports that measure trends over time.
- Build new scripts and troubleshoot existing scripts. Solve complex record and run issues including complex correlation problems.
- Verify and validate data accuracy, completeness, and consistency using Extract/Transform/Load (ETL) tools and SQL queries.
- Analyzes and troubleshoots erroneous results, determines the root cause of defects, logs the defects JIRA/QTest and enables defect management, including working with the development team on the resolution of Software related defects.
- Drive opportunities and lead efforts to improve existing test processes or create new to increase efficiency and
- productivity in test case development, scheduling, or deployment.
- Analyze test results and prioritize and log defects with appropriate information.
- Manage multiple projects/deadlines with changing priorities.
- Other duties as assigned.
REQUIREMENTS: Bachelor’s degree or foreign equivalent degree in Computer Science or related technical field and 3 years of experience with ETL/Data warehouse test or development experience. Experience must include:
- 3 years of experience with data analysis.
- 3 years of experience in SQL for data querying, validation, and analysis.
- 3 years of experience with complex joins, subqueries, and performance optimization.
- 3 years of experience in Scala/Python for test automation and data manipulation.
- 3 years of experience on Snowflake and Azure Databricks.
- 3 years of experience identifying changes, driving improvements, and streamlining processes.
- Demonstrated knowledge of:
- Software development lifecycle.
- Microsoft Azure technologies.
*Knowledge may be demonstrated through education, training and/or experience
SALARY: $113,173.00 to 136,000 /year
LOCATION: 27-01 Queens Plaza North, Long Island City, NY, 11101. 100% Remote; position may be performed from anywhere within the U.S. Up to 10% domestic and international travel to JetBlue locations.