data analyst (Gurgaon, India)

Data Management:

1. Gather, organize, and maintain data related to advertising campaigns and their revenue, ensuring accuracy and consistency.

2. Querying the Database: Using SQL/BigQuery to run queries on ShareChat’s analytical engine

3. Scripting: Writing scalable scripts to fetch or modify data from API endpoints.

4. Collaborate with data teams to ensure proper integration and flow of data between different systems and platforms.

Reporting and Insights:

1. Create reports and dashboards to visualize key performance metrics.

2. Generate regular and ad-hoc reports that provide insights into monthly/quarterly/annual revenue, campaign performance and key metrics.

3. Communicate findings and insights to cross-functional teams, including AdOps, sales and management, to drive data-informed decision-making.

Ad Strategy:

1. Work with Strategy team with data insights to develop Go to Market strategies for Key Clients

2. Monitor ad inventory levels and work with Strategy teams to ensure ad space is efficiently utilized.

3. Assist in forecasting future ad inventory needs based on historical data.

4. Identify opportunities for process improvements and automation in ad operations workflows.

5. Contribute to the development and implementation of best practices and standard operating procedures for ad operations.

Salesforce Administration, Integration and Automation:

1. Configure, customize and maintain the Salesforce CRM system to meet the specific needs of the advertising team.

2. Create and manage custom objects, fields, and workflows to support advertising operations.

3. Integrate Salesforce with other advertising and marketing tools and platforms for seamless data flow.

4. Automate routine tasks and processes to improve efficiency and reduce manual work.

Who are you?

1. BS in Mathematics, Economics, Computer Science, Information Management or Statistics is preferred.

2. Proven working experience as a data analyst or business data analyst

3. Strong knowledge of and experience with SQL/BigQuery and Excel

4. Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

5. Experience with Salesforce would be an advantage