Engineer IT Quality Data (Long Island City, NY, US, 11101)

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.