Engineer IT Quality Data

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.