Data QA Analyst (only for USC & GC )

Highbrow LLC; Remote; EUR 60.000 - 80.000; Vollzeit

Zusammenfassung

A leading data solutions company is seeking a Data QA Analyst to ensure the quality of data through rigorous testing methodologies. Key responsibilities include reviewing design specifications, developing test plans, and executing both manual and automated tests. The ideal candidate has hands-on experience with ETL tools, strong SQL and data warehouse skills, and is familiar with tools such as Power BI and Jira. This is a long-term remote position open to US citizens and GC holders.

Qualifikationen

• Hands on experience with testing in ETL and Data warehouse.
• Strong experience in testing SQL reports and paginated reports.
• Prior experience working on migration projects.

Aufgaben

• Review and analyze functional and design specifications documents.
• Identify test requirements from design document and mapping documents.
• Develop automation test scenarios and enhance automation test platform.
• Create and facilitate test plans/reviews with team.
• Manage UAT and execute manual and automated test cases.

Kenntnisse

ETL tools like DBT

Strong SQL skills

Data warehouse concepts

Power BI

Automation tools like Validator

Understanding of stored procedures and PL/SQL

Data analysis

Jira

Cloud technologies

XML

Tools

Snowflake

MS Office

Jobbeschreibung

Job Title: Data QA Analyst

Job ID: 2023-12357

Job Location: Remote (EST or CST)

Job Travel Location(s):

# Positions: 1

Employment Type: W2

Candidate Constraints:

Duration:Long term

# of Layers:0

Work Eligibility: US Citizens & GC Holders

Key Technology:ETL, Data Warehouse, SQL, Power BI

Job Responsibilities:

• Review and analyze functional and design specifications documents
• Identify test requirements from design document and mapping documents
• Involve in test planning, writing test cases/scripts, creating reusable test data, test case automation, and test execution
• Develop automation test scenarios and enhance automation test platform
• Create and facilitate test plans/reviews with team
• Execute manual and automated test cases
• Manage UAT
• Enhance existing Test scripts, identify end-to-end test scenarios
• Independently create Test Scenarios & Test Cases
• Use gathered data to analyze test results and trends

Skills and Experience Required:

Required:

Hands on experience with testing in ETL and Data warehouse.

• Hands on with ETL tools like DBT.
• Strong SQL skills and strong experience in testing SQL reports, paginated reports, etc.,
• Must be able to understand stored procs, PL/SQL (Nice to have coding skills).
• Strong experience in data warehouse concepts and Snowflake or similar databases.
• Good experience in data analysis, data profiling, preparing test data, etc.,
• Prior experience working on migration projects.
• Experience with Power BI and SSRS.
• Experience with Jira, Scrum, and Kanban.
• Experience in automation tools like Validator.
• Experience documenting QA efforts such as acceptance criteria, Source-target mapping, RTM, test plans, test cases, test results, bug reporting, etc.,
• Experiencing working independently as a full QA resource and adaptability to work in multiple teams at the same time.
• Rich experience in functional, integration, end to end, regression, performance, and user acceptance testing.
• Experience in cloud technologies.
• Experience with XML.
• Experience with MS Office.
• Experience in handling health data.