Quality Assurance Analyst

Key Responsibilities

• Conduct comprehensive quality assurance on data updates, inserts, and modifications by data analysts and engineers
• Validate and QA complex SQL and Python scripts developed by the data team
• Review and ensure the quality of data migrations, custom reports, and self-service reporting systems
• Verify the accuracy and effectiveness of data visualization tools, techniques, metrics, and dashboards
• Conduct thorough QA on ad-hoc data requests, test scenarios, and data analysis in a production environment
• Validate web form builds and electronic data collection templates, ensuring accurate mapping between form fields and database fields
• Review and verify daily tickets submitted by business units for various data-related tasks
• Conduct audits to ensure compliance with data quality standards, metadata management, and data lineage practices
• Collaborate with data analysts and engineers to resolve quality issues and improve processes
• Contribute to the establishment and implementation of process improvements
• Document QA processes and maintain up-to-date quality assurance documentation
• Provide feedback on data quality management principles, including metadata, lineage, and business definitions
• Assist in validating data cleansing and manipulation processes to ensure data is in the correct format

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field
• 5+ years of experience in quality assurance, preferably in a data-intensive and legal services environment
• Strong understanding of data processes, analytics, and database concepts
• Proficiency in SQL and Python for validation purposes
• Experience with data validation tools and techniques
• Familiarity with data visualization tools, especially Power BI
• Knowledge of big data technologies such as Spark and Databricks
• Understanding of cloud computing platforms (Azure, AWS)
• Experience with version control systems (e.g., Git)
• Strong problem-solving and critical thinking abilities
• Excellent communication skills, both written and verbal
• Ability to work independently and as part of a team

Required Skills

• Advanced data quality assurance techniques
• Proficiency in SQL (including T-SQL) and Python for validation purposes
• Experience in validating ETL processes and data migrations
• Ability to review and QA complex SQL queries and query optimization
• Quality control processes for both data and web applications
• Web form validation and database mapping comprehension
• Technical documentation and process improvement
• Exceptional attention to detail and accuracy
• Time management and prioritization in a fast-paced environment
• Experience with version control systems (e.g., Git)
• Advanced Excel skills for data validation

Preferred Skills

• Experience in the legal services industry or similar professional services environment
• Familiarity with Power BI for validating data visualizations
• Knowledge of data privacy and security best practices
• Experience in a production operations environment
• Understanding of statistical analysis methods for effective QA