质量保证数据分析师
Quality Assurance Data Analyst
类别：法律
地点：
Paradigm 正在为我们的客户 Epiq 招聘一名质量保障数据分析师，加入其集体诉讼数据服务团队。这是一个需要亲自动手的数据质量岗位，适合喜欢深入研究数据、理解数据在复杂系统中的流动方式，并确保最终输出准确的人。
理想的候选人应具备扎实的 SQL/T-SQL 技能、分析思维、出色的细节关注度和清晰的沟通能力。您将使用 SQL 和 Excel 验证涉及包含数百、数千或数百万条记录的数据集的导入、更新、提取和转换。您将在高度协作、以截止日期为导向的环境中与数据工程师、业务分析师、项目团队和其他 QA 专业人士紧密合作。
类型：合同制
时长：12 个月*
薪资：33–38 美元/小时
福利：医疗、牙科、视力、人寿保险、401(k)、带薪假期和病假
地点：远程办公 – 批准的美国地点
职位编号：Para_1500
* 任务时长是根据预期的工作量和工作范围进行预估的。根据业务需求，任务可能会延长或提前结束。
批准的招聘地点：阿拉巴马州、亚利桑那州、科罗拉多州、康涅狄格州、特拉华州、佛罗里达州、佐治亚州、爱达荷州、伊利诺伊州、印第安纳州、堪萨斯州、肯塔基州、路易斯安那州、马里兰州、马萨诸塞州、密歇根州、明尼苏达州、密苏里州、内华达州、新泽西州、纽约州、北卡罗来纳州、俄亥俄州、俄克拉荷马州、俄勒冈州、宾夕法尼亚州、南卡罗来纳州、田纳西州、德克萨斯州、犹他州、弗吉尼亚州、华盛顿州、华盛顿特区和威斯康星州。
作为质量保障数据分析师，您将：
- 验证涉及从数百到数百万条记录的数据集的导入、更新、转换和提取的准确性与完整性。
- 审查并理解复杂 SQL 查询、存储过程、触发器、函数和其他数据库流程背后的逻辑。
- 编写并执行 SQL 测试查询，以验证数据完整性、业务逻辑和预期结果。
- 使用 SQL Server、Excel 和相关工具分析数据，确认已满足业务和项目需求。
- 设计并执行涵盖正常情况、异常情况、数据异常和其他相关场景的测试用例。
- 审阅需求和规格说明书，识别差距、不一致之处或潜在的数据质量问题。
- 与数据工程师、业务分析师、项目经理和 QA 团队成员密切合作，识别、记录、排查和解决缺陷。
查看英文原文
Category: Legal
Location:
Paradigm is seeking a Quality Assurance Data Analyst to support our client, Epiq, on its Class Action Data Services team. This is a hands-on data quality role for someone who enjoys digging into data, understanding how it moves through complex systems, and making sure the final output is accurate.
The ideal candidate combines strong SQL/T-SQL skills, analytical thinking, exceptional attention to detail, and clear communication. You will use SQL and Excel to validate data imports, updates, extracts, and transformations involving datasets that may contain hundreds, thousands, or millions of records. You will work closely with data engineers, business analysts, project teams, and other QA professionals in a highly collaborative, deadline-driven environment.
Type: Contract
Duration: 12-month*
Pay Rate: $33–$38/hour
Benefits: Medical, dental, vision, life, 401(k), PTO, and sick leave
Location: Remote – approved U.S. locations
Job No.: Para_1500
* Assignment lengths are estimated based on the expected workload and scope of work. The assignment may be extended or conclude earlier than anticipated based on business needs.
Approved Hiring Locations: Alabama, Arizona, Colorado, Connecticut, Delaware, Florida, Georgia, Idaho, Illinois, Indiana, Kansas, Kentucky, Louisiana, Maryland, Massachusetts, Michigan, Minnesota, Missouri, Nevada, New Jersey, New York, North Carolina, Ohio, Oklahoma, Oregon, Pennsylvania, South Carolina, Tennessee, Texas, Utah, Virginia, Washington, Washington DC, and Wisconsin.
As a Quality Assurance Data Analyst, you will:
- Validate the accuracy and completeness of data imports,updates, transformations, and extracts involving datasets ranging from hundredsto millions of records.
- Review and understand the logic behind complex SQL queries,stored procedures, triggers, functions, and other database processes.
- Write and execute SQL test queries to verify data integrity,business logic, and expected results.
- Analyze data using SQL Server, Excel, and related tools toconfirm that business and project requirements have been met.
- Develop and execute test cases covering normal conditions,exceptions, data anomalies, and other relevant scenarios.
- Review requirements and specifications to identify gaps,inconsistencies, or potential data-quality issues.
- Work closely with data engineers, business analysts, projectmanagers, and QA team members to identify, document, troubleshoot, and resolvedefects.
- Verify corrections and problem resolutions accurately andefficiently.
- Assist business partners in translating functionalrequirements into appropriate testing scenarios and validation criteria.
- Perform dependable peer reviews to identify errors andensure adherence to Data Services standards.
- Maintain clear documentation and appropriate work artifactsdemonstrating that required validation and testing have been completed.
- Provide timely and accurate status updates to leadership,Workforce, project managers, and other stakeholders.
Requirements
Our ideal candidate will have:
- Four-year college degree or equivalent relevant professional experience.
- 2+ years of strong database testing or data-validation experience, including writing and executing complex SQL queries.
- 1+ years of hands-on experience with T-SQL, ANSI-89, and/or ANSI-92 SQL.
- Strong working knowledge of relational databases and the ability to understand moderately to highly complex SQL logic.
- Experience reviewing and understanding stored procedures, functions, triggers, and database logic.
- Experience in a Data Analyst, Business Analyst, QA/Data Testing, Process Specialist, or similar analytical role.
- Strong analytical skills and deductive reasoning, with exceptional attention to detail.
- Working knowledge of data modeling and data organization concepts.
- Familiarity with extract, transform, and load (ETL) concepts, tools, and processes.
- Proficiency with Microsoft Office, particularly Excel.
SQL/T-SQL Knowledge
Candidates should be comfortable working with and discussing SQL/T-SQL concepts such as:
- NULL handling
- Subqueries, including IN, EXISTS, inline views, and correlated subqueries
- Primary keys, foreign keys, constraints, and defaults
- Transactions and error handling
- BCP and BULK INSERT
- Indexing
- Stored procedures and user-defined functions
- Triggers
- Views and temporary tables
- Common table expressions (CTEs)
- Querying, creating, validating, and updating data
This position does not require a SQL developer, but candidates must have sufficient hands-on SQL experience to understand database logic, analyze data, and write queries used to validate complex data processes.
Benefits
Paradigm offers medical, dental, vision, life, 401K, PTO, and sick days.
About Us, Paradigm
Paradigm Information Services is an established staffing company that has been connecting talented people with great opportunities for more than 25 years. We work with clients across a variety of industries and positions, giving our recruiting team the opportunity to work on interesting and sometimes challenging searches.
Paradigm Information Services does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits.
DetailsOriginally posted on Himalayas