Data Analytics Associate

Azimpremjiuniversity; Bengaluru; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Azim Premji University in Bengaluru seeks a professional with extensive hands-on experience in Microsoft Excel and Power BI for data analysis and reporting. The ideal candidate will be proficient in Salesforce Marketing Cloud and Google Analytics, demonstrating strong analytical and communication skills.

The position requires a graduate degree and a minimum of four years in a similar role. Responsibilities include developing dashboards, managing campaigns, and conducting thorough data analyses.

Qualifications

• Minimum four years of experience in a similar role.
• High analytical ability is a must.
• Strong communication skills, both written and oral.

Responsibilities

• Analyze data and generate reports using Microsoft Excel.
• Develop interactive dashboards using Microsoft Power BI.
• Manage and execute marketing campaigns on Salesforce Marketing Cloud.
• Track web traffic and campaign performance using Google Analytics.

Skills

Microsoft Excel

Power BI

Salesforce Marketing Cloud

Google Analytics

Education

Graduate or postgraduate degree

Job description

• Extensive hands-on experience (3 to 5years) in using Microsoft Excel for data analysis, reporting, and processautomation.


• Proficiency in advanced Excel functions including VLOOKUP , XLOOKUP , INDEX-MATCH , Pivot Tables, Power Query, Power Pivot, conditional formatting, array formulas, and data visualisation techniques.


• Ability to design and maintain complex spreadsheets, create dynamic models, and ensure data integrity fordecision-making.


• Excellent analytical and problem-solving skills to extract insights from complex datasets from different datatables

2. Power BI – Automation and DashboardDevelopment

• Proven experience in developing interactive dashboards and reports using Microsoft Power BI .


• Expertise in connecting multiple data sources, transforming data using Power Query, creating measures and calculated columns using DAX , and delivering insightful visualanalytics.


• Ability to automate data refresh processes and deploy dashboards for real-time businessintelligence.

3. Salesforce Marketing Cloud ( SFMC ) – Campaigns and JourneyManagement

• Strong working knowledge of Salesforce Marketing Cloud for managing and executing marketingcampaigns.


• Experience in setting up, monitoring, and optimising journeys using Journey Builder, Automation Studio, and EmailStudio.


• Strong understanding of real-time data synchronisation between Salesforce CRM and Marketing Cloud for accurate campaign targeting andreporting.

4. Google Analytics & Digital MarketingTools

• Proficiency in Google Analytics for tracking and analysing web traffic, user behaviour, and campaignperformance.


• Familiarity with other digital marketing tools such as social media analytics platforms to support end-to-end marketingstrategies.

Requirements

• A graduate or postgraduate degreein anydiscipline.


• Minimum four years of experience in asimilar role.


• High analytical ability, is amust.


• Adept in critical thinking and ability to suggestalternatives


• Strong communication skills, both written andoral.