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.