QA Analyst

About Company:
Headquartered in El Segundo, Calif., Internet Brands® is a fully integrated online media and software services organization focused on four high-value vertical categories: Health, Automotive, Legal, and Home/Travel. The company's award-winning consumer websites lead their categories and serve more than 250 million monthly visitors, while a full range of web presence offerings has established deep, long-term relationships with SMB and enterprise clients. Internet Brands' powerful, proprietary operating platform provides the flexibility and scalability to fuel the company's continued growth. Internet Brands is a portfolio company of KKR and Temasek.

Education: B.E. Computer Science/IT degree (or any other engineering discipline)
Experience: 3+ years

Position Requirement:

• Proficient 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