Quality Assurance Data Analyst

About the role

Day-to-day: Verify data accuracy through complex SQL queries and stored procedures; test data imports of millions of records; collaborate with engineers and analysts to identify and troubleshoot defects

You'll bring: 2 years database testing; expert T-SQL including stored procedures, triggers, subqueries; 1 years T-SQL or ANSI experience; 4-year degree or equivalent; strong Excel and SQL Server skills

Good fit if: Background as Business Analyst or Data Analyst; experience with ETL concepts; understanding of data modeling; ability to work independently with tight deadlines and shifting priorities

Generated from the recruiter description below. The full posting is the source of truth — always read it before applying.

About Client:
Company is a worldwide provider of legal services, serving law firms, corporations, financial institutions and government agencies helping them streamline the administration of business operations.
Its scalable, flexible technology is designed to help you quickly and efficiently turn huge amounts of data into manageable, actionable tools you can use to meet a variety of objectives.

Rate Range: $33-$38/Hr

Job Description:
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.

Qualifications and Requirements:

• Four-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 experience working with T-SQL, or ANSI-89 / ANSI-92.

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

Please note that ApTask offers subsidized insurance coverage to our employees.

About ApTask:
ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-owned company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.

Candidate Data Collection Disclaimer:
At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.

If you have any concerns or queries about your personal information, please feel free to contact our compliance team at compliance@aptask.com.

Applicant Consent:
By submitting your application, you agree to ApTask's (https://aptask.com) Terms of Use and Privacy Policy, and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-355-8000 or help@aptask.com. Message frequency may vary. Msg & data rates may apply.

About operations at ApTask

Operations roles at ApTask cover program management, PMO, business analysis, transformation, and change-management positions across enterprise clients. We place operators who translate strategy into delivery — PMPs, Scrum Masters, agile coaches, Six Sigma black belts, and change-management practitioners certified in Prosci or the client's preferred framework. Candidates are validated against the specific enterprise tooling the client runs (ServiceNow, Jira Portfolio, Clarity, Planview) and their prior track record in comparable-scale programs, not generic delivery experience.

Benefits:

Salary : $33 - $38