Remote QA Data Analyst (SQL & Data Accuracy)

Ian Martin Group; United States; Remoto; USD 45.000 - 52.000; Tempo pieno

Descrizione del lavoro

The Ian Martin Group is hiring a Remote Quality Assurance Data Analyst for a 12-month contract. The role involves validating data integrity, writing test cases, and collaborating with data engineers and business analysts.

The position is remote with Pacific Time work hours and potential overtime based on workload. Qualified candidates will have 2+ years of database testing experience, strong T-SQL skills, and a background in data analysis using SQL Server and Excel.

Competenze

• 4-year college degree or equivalent industry experience.
• Excellent verbal and written communication skills; Excellent analytical and organizational skills; Strong deductive reasoning
• Ability to multi-task and work under tight deadlines in a fast-paced environment
• Proficient with MS Office tools, particularly Excel.
• Experience as Business Analyst, Data Analyst, or similar role
• Experience with relational databases and moderate SQL logic
• Basic understanding of data modeling and ETL concepts
• Expert-level T-SQL including NULL handling, subqueries, constraints, transactions, indexing, stored procedures, triggers, views, temp tables, and CTEs
• 2+ years of strong database testing experience with complex SQL queries
• 1+ years of experience with T-SQL or ANSI SQL

Mansioni

• Verify data updates and extracts by understanding complex queries and data logic.
• Collaborate with data engineers, BI analysts, and QA peers to identify and fix defects.
• Query data using Excel and SQL Server to verify requirements.
• Adhere to Data Services standards and document time against projects.
• Review requirements to identify gaps and data anomalies.
• Write and execute test plans and cases to validate data across scenarios.
• Log time accurately and maintain professional communication with stakeholders.
• Support data validation during imports of large datasets.

Conoscenze

Microsoft SQL

Attention to detail

Clear communication

Formazione

4-year college degree or equivalent industry experience

Strumenti

SQL Server

Excel

Descrizione del lavoro

The Ian Martin Group is hiring a Remote Quality Assurance Data Analyst for a 12-month contract. The role involves validating data integrity, writing test cases, and collaborating with data engineers and business analysts.

The position is remote with Pacific Time work hours and potential overtime based on workload. Qualified candidates will have 2+ years of database testing experience, strong T-SQL skills, and a background in data analysis using SQL Server and Excel.