Engineer IT Quality Data
About the position 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. Responsibilities • 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. • 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. • Software development lifecycle. • Microsoft Azure technologies.