Data Management:

Gather, organize, and maintain data related to advertising campaigns and their revenue, ensuring accuracy and consistency.
Querying the Database: Using SQL/BigQuery to run queries on ShareChat’s analytical engine
Scripting: Writing scalable scripts to fetch or modify data from API endpoints.
Collaborate with data teams to ensure proper integration and flow of data between different systems and platforms.

Reporting and Insights:

Create reports and dashboards to visualize key performance metrics.
Generate regular and ad-hoc reports that provide insights into monthly/quarterly/annual revenue, campaign performance and key metrics.
Communicate findings and insights to cross-functional teams, including AdOps, sales and management, to drive data-informed decision-making.

Ad Strategy:

Work with Strategy team with data insights to develop Go to Market strategies for Key Clients
Monitor ad inventory levels and work with Strategy teams to ensure ad space is efficiently utilized.
Assist in forecasting future ad inventory needs based on historical data.
Identify opportunities for process improvements and automation in ad operations workflows.
Work with the ad sales teams to deep dive on platform data to derive useful business insights.
Collaborate with the sales teams to optimise media plans basis advertiser requirement, business feasibility and platform potential
Contribute to the development and implementation of best practices and standard operating procedures for ad operations.
Create and update client presentations, playbooks, case studies and narratives for internal and external usage

Salesforce Administration, Integration and Automation:

Configure, customize and maintain the Salesforce CRM system to meet the specific needs of the advertising team.
Create and manage custom objects, fields, and workflows to support advertising operations.
Integrate Salesforce with other advertising and marketing tools and platforms for seamless data flow.
Automate routine tasks and processes to improve efficiency and reduce manual work.

Who are you?

0-2 years working experience as a data analyst or business data analyst
BS in Mathematics, Economics, Computer Science, Information Management or Statistics is preferred.
Strong knowledge of and experience with SQL/BigQuery and Excel
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
Hands on experience of working on presentations, power-point and google decks
Experience with Salesforce would be an advantage

Business Analyst

Similar Jobs