Job Purpose
This role is responsible for execution of all type of marketing analytics, report creation and provide data insights to identify actionable items for both marketing and business.
Requirement
- 0-1 years of proven experience in data analysis.
- Proficiency in Python programming language.
- Familiarity with data visualization tools such as QuickSight, Google Data Studio, etc.
- Expertise in Microsoft Excel for data manipulation and analysis.
- Experience working with Salesforce or similar CRM platforms.
Essential Duties And Responsibilities
- Preparation of key lead to conversion funnel reports with relevant cuts
- Preparation of relevant reports for each marketing channel
- Monitor daily trends and identify gaps or indicators which can help team to take corrective actions in advance
- Ad-hoc data analysis to identify root causes for case to case basis. Preparation of one-time reports, data consolidation etc. as and when required.
- Cost & Performance optimization between various communication channels/lead gen channels
- Combine offline and online data to get a complete view and generate useful insights
Impact analysis of various events like print/tv ads, various experiments on website/app/other channels etc.
- Managing master data, including creation, updates, and deletion.
- Managing users and user roles.
- Provide quality assurance of imported data, working with quality assurance analysts if necessary.
- Commissioning and decommissioning of data sets.
- Processing confidential data and information according to guidelines.
- Helping develop reports and analysis.
- Managing and designing the reporting environment, including data sources, security, and metadata.
- Supporting the data warehouse in identifying and revising reporting requirements.
- Supporting initiatives for data integrity and normalization.
- Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
- Generating reports from single or multiple systems.
- Troubleshooting the reporting database environment and reports.
- Evaluating changes and updates to source production systems.
- Training end-users on new reports and dashboards.
Skills: data,preparation,reporting,analytics,case,data analysis,quality assurance,ad-hoc,app,crm