Remote Quality Assurance Data Analyst

Raise - find a more meaningful working experience; United States; Remote; USD 45,000 - 52,000; Full time

Job summary

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.

Qualifications

• 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

Responsibilities

• 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.

Skills

Microsoft SQL

Attention to detail

Clear communication

Education

4-year college degree or equivalent industry experience

Tools

SQL Server

Excel

Job description

Remote Quality Assurance Data Analyst

• Pay Rate: $33 - $38/hour on W2
• Contract Length: 12 months
• Location: 50 miles within Oregon, Idaho or Nevada only | Remote
• Work Schedule: Monday – Friday, 10:00 AM – 7:00 PM Pacific Time, with a 1-hour unpaid lunch. Occasional overtime and weekend work may be required based on workload and business needs.
• Training Schedule: 8:00 AM – 5:00 PM Pacific Time for approximately 3 – 4 weeks, or until minimum proficiency is achieved.

Raise is hiring a contract team member on behalf of our client. They’re expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader.

Responsibilities

• Confirm the accuracy of various data updates and extracts, which involves understanding the logic of complex queries, stored procedures, triggers, and functions based on requirements, writing appropriate test queries, and executing them to verify the logic and data.
• Work closely with data engineers, business analysts, and other QA team members to identify, report, and troubleshoot defects; verify problem fixes in a detailed, efficient, and timely manner.
• Use tools such as Excel and SQL Server, and others, directly query, assess, and analyze data to ensure requirements are being met.
• Follow prescribed software development standards, processes, procedures, methodologies, etc., according to departmental policies and conventions.
• Interact and correspond professionally with team members, project management, clients, and other stakeholders.
• Account for and accurately log time against project work.
• Work well with other associates not only internally but externally. Seek to de-escalate in times of conflict rather than contribute to that conflict, regardless of who is right or wrong.
• Consistently follow the policies and procedures of Data Services such as time entry, % complete, SR comments, etc.
• Review requirements specifications and identify gaps and inconsistencies
• Confirm the accuracy of initial import of data involving hundreds, thousands, or even millions of records
• Work closely with business partners in eliciting project requirements to create test cases
• Understand the context of work and write or evaluate test plans and/or set up and execute test cases, to confirm data on normal and exceptional records, to cover various data scenarios and anomalies
• Demonstrates appropriate work ethic by striving to hit deadlines and working closely with others to remediate issues without defaulting to push-back.
• Communicates properly and effectively not only internally but externally. This includes providing status on time and constantly keeping clear communication open to leadership, Workforce and PMs.
• Understands and follows standards of Data Services and provides dependable peer review to catch errors of this type.

Top 3 Required Skills

• Microsoft SQL experience - does not need to be an expert/developer, but needs some exposure and familiarity with this coding for our data analysis
• Attention to detail and adherence to process to ensure quality
• Clear communication in a connected and dependent team setting

Qualifications

• 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 separate projects in a fast paced & dynamic company environment and extremely tight timelines
• Demonstrated ability to work independently with limited direction or as part of a team
• Ability to work in an environment with immediate deadlines and shifting priorities.
• Proficient with MS Office tools, particularly Excel.
• Ability to communicate effectively, both verbally and in writing; able to adjust for intended audience. Fluent in English.
• Experience as Business Analyst, Data Analyst, Process Specialist, or other role where business functional requirements are captured and decomposed.
• Experience with relational databases and ability to comprehend moderately complex SQL logic.
• Basic understanding of data modeling and data organization.
• Basic understanding of and experience with extract, transform, load (ETL) concepts, tools, and practices.
• Expert-level T-SQL to include thorough understanding of the following concepts:
  • NULL handling
  • Sub queries: IN, EXISTS, and inline views, Correlated Subqueries
  • Constraints, Primary keys, foreign keys, defaults
  • Error trapping
  • Transactions
  • BCP, BULK INSERT
  • Indexing
  • Advanced stored procedures and user defined functions programming
  • Triggers
  • Correct usage of views and temp tables and common table expression for pulling, creating, and updating data
• 2+ years of very strong experience in database testing with the ability to understand, write, and execute very complex SQL queries, and understand the logic of stored procedures
• 1+ years of experience working with T-SQL, or ANSI-89 / ANSI-92.

Looking for meaningful work? We can help

Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.

We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.

We have a dedicated webpage for accommodations where you can learn more about what we offer, and request accommodation: https://raise.jobs/accommodations/

In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at [phone] or [e-mail]

#HOTJOB