Job details
Job type full-time
Full job description
Roles and responsibilities
Job responsibilities require that the senior qa data analyst meet the critical job demands, including but not limited to, the following key areas:
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
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
Subject matter expert in all areas that fall under their domain.
Demonstrates above average technical expertise in all areas that fall under their job title.
Constantly strives to improve process in all areas of domain knowledge.
Demonstrates an above-average work ethic by striving to hit deadlines and working closely with leads / workforce / resource management to remediate issues without defaulting to push-back.
Is a go-to associate in times where there may be issues, fires, compressed deadlines, etc.
Demonstrates on-going education by earning certifications or has shown progress towards working toward these certifications.
Is a mentor to peers not only when assigned by leadership, but by default.
Low defect count where making mistakes in their domain is a primary factor.
Communicates properly and effectively not only internally but externallyThis includes providing status on time and constantly keeping clear communication open to leadership, workforce and pms
Works well with other associates not only internally but externallySeeks to de-escalate in times of conflict rather than contribute to that conflict, regardless of who is right or wrong.
Consistently follows the policies and procedures of data services such as time entry, % complete, sr comments, etc.
Seeks to find solutions when they or their peers disagree with a standard, action, requirement, etcRather than encourage non-productive complaining.
Understands and follows standards of data services and provides dependable peer review to catch errors of this type.
Job qualifications and requirements
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
T-sql to include understanding of the following concepts:
Aggregates: count, sum, max/min, distinct, group by, having
Joins, ansi-89 and ansi-92 syntax.
Union vs union all
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.
3+ years’ experience in a software qa role understanding the entire software life cycle and various qa/testing methodologies/techniques
Expert understanding of dml (data manipulation language) & ddl (data definition language)
Maximum technical expertise/escalation on the team
Work environment
Work is fast-paced and performed in an office environment, or remote-office environment with regular use of webcam and screen-sharing, and with extensive contact with employees, and occasional contact with clientsThe industry we serve demands the highest level of confidentiality and professionalism in safeguarding client and project informationHighly effective class action & claims solutions and corporate services associates thrive on being in an environment that rewards the following critical success factors:
Adaptability: appropriately responding to changing situations without a loss of effectiveness and enthusiasm for strategic initiatives and corporate goals.
Analysis: identifying problems and causes or analyzing how processes and procedures could be improved, collecting relevant information and identifying possible solutions.
Attention to detail: appropriately completing all of the individual tasks accurately or according to workflow/process guidelines with an emphasis on reaching or exceeding quality standards.
Creativity: being inventive, imaginative and innovative.
Energy: maintaining a fast, active pace in the normal course of a day.
Flexibility: going into situations without preconceived notions, but with a willingness to assess various options, in order to determine a course of action.
Integrity: strict adherence to job-related standards, values or norms.
Learning ability: understanding and applying new information.
Listening: hearing and comprehending verbal messages and confirming back what is heard.
Team player: functioning as an active member of a group while maintaining focus on one’s individual contributions and responsibilities.
Verbal & written communication: effective oral, written, and nonverbal expression without preparation.
Development of others: providing the means for others to grow and develop personally and professionally within and across departments.
Physical demands
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this jobReasonable accommodations may be made to enable individuals with disabilities to perform the essentials functions.
Position requires no significant manual labor.
Position does require moderate standing, sitting, carrying and walking.
Position requires infrequent lifting, repetitive bending and/or moving.
Position requires close vision, distant vision, peripheral vision, and depth perception.
Position requires talking and listening to communications with clients and employees.#li-rc1
If you like wild growth and working with happy, enthusiastic over-achievers, you`ll enjoy your career with us!
It is epiq’s policy to comply with all applicable equal employment opportunity laws by making all employment decisions without unlawful regard or consideration of any individual’s race, religion, ethnicity, color, sex, sexual orientation, gender identity or expressions, transgender status, sexual and other reproductive health decisions, marital status, age, national origin, genetic information, ancestry, citizenship, physical or mental disability, veteran or family status or any other basis protected by applicable national, federal, state, provincial or local lawEpiq’s policy prohibits unlawful discrimination based on any of these impermissible bases, as well as any bases or grounds protected by applicable law in each jurisdictionIn addition epiq will take affirmative action for minorities, women, covered veterans and individuals with disabilitiesIf you need assistance or an accommodation during the application process because of a disability, it is available upon requestEpiq is pleased to provide such assistance and no applicant will be penalized as a result of such a requestPursuant to relevant law, where applicable, epiq will consider for employment qualified applicants with arrest and conviction records.
