Data Analyst at Azent Overseas · Mumbai · 2 - 5 years · ₹2L - ₹7L / yr · Bootstrapped · Posted 30 Jul 2021
Data AnalyticsData auditing, validating and monitoring all data for accuracy.
Create daily, weekly, monthly and quarterly MIS report.
Coordinating & collecting the data
Updated the data in CRM
Shubham Vishwakarma
Full Stack Developer - Averlon
About Azent Overseas
About
We are Revolutionizing how students go to study abroad
We are an international education advisory, backed by years of experience in education and technology, Azent is the brainchild of Atul Nishar (founder of Aptech and Hexaware Technologies). With an unprecedented investment in infrastructure and technology, we aim to create a one-of-a-kind experience for students aspiring to international education.
We, at Azent, help students with every step of the admissions process, from university shortlisting to course selection to application and visa requirements. It also facilitates a smooth transition to the new environment by providing support service offerings that extend up until the student's arrival on campus, and it has a significant presence in 1450+ universities in other cities (Experience Centres & Virtual Offices in 17 cities across India).
Company social profiles
Similar jobs (1)
Key Responsibilities
- Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
- Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
- Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
- Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
- Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
- Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
- Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
- Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
- Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.
Required Skills & Qualifications
- Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.
- Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
- Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
- Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
- Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
- Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon