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.