- Extract, clean and aggregate data (Hadoop/Hive and Greenplum). Create project specific schemas, tables, functions, views to process and store data. Ensure quality and integrity of data and procedures.
- Leverage database using SQL (Postgres) to lead data extraction projects for clients and fulfill data requests from all departments.
- Create analytical business reports combining digital data and survey research results to provide accurate, granular insights to clients' digital marketing strategies.
- Provide analysis and insight on research process regarding setup, logic, feasibility, performance, potential issues, and data output.
- Ensure quality and integrity of data with creation of complex syntax in SPSS and Excel.