Job Description
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
- 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
Apply for this Position
Ready to join ? Click the button below to submit your application.
Submit Application