Quality Assurance Analyst

Position Requirement:

• 3+ years experience in SQL ( analytical functions, trending, windowing)- Traditional (for e.g. MSSQL, Oracle, PostgreSQL) or Columnar (like Vertica, Amazon, Redshift)
• Experience with data QA and ETL / ELT (data pipelines) QA
• Experience working closely with teams outside of IT (i.e. Business Intelligence, Marketing Adops, Sales)
• Strong understanding of the Web Analytics, metrics, KPIs, and reporting
• Experience with automating regression tests, reporting platforms (for e.g. Tableau or Pentaho BI) and ETL tools (for e.g. Pentaho or Talend) will be an added advantage
• Understanding of Ad stack, Email data and data (Ad servers, DSM, DMP etc) is good to have

Role & Responsibilities:

• Performing statistical tests on large datasets to determine data quality and integrity
• Evaluating system performance and design, as well as its effect on data quality
• Collaborating with database developers to improve data collection and storage processes
• Running data queries to identify coding issues and data expectations, as well as cleaning data
• Gathering data from primary or secondary data sources to identify and interpret trends
• Reporting data analysis findings to management to inform business decisions and prioritize information system needs
• Documenting processes and maintaining data records
• Adhering to best practices in data analysis and collection
• Keeping abreast of developments and trends in data quality analysis