Business Analyst

Gandhi Institute of Technology and Management (GITAM); Visakhapatnam; On-site; INR 700,000 - 1,100,000; Full time

Job summary

Gandhi Institute of Technology and Management (GITAM) invites applications for a Business Analyst at the Visakhapatnam Campus. You will analyze admissions data, build dashboards, and provide insights to improve decision making.

The role requires strong SQL, Power BI, and data-visualization skills, plus experience in higher education analytics and cross-functional collaboration with admissions and marketing teams.

Qualifications

• Bachelor's degree or equivalent in a related field.
• 2-5 years of experience in Higher Education/University analytics.
• Advanced SQL skills for querying, extraction and ETL workflows.
• Power BI mandatory with experience in other visualization tools.

Responsibilities

• Provide detailed data analysis reports to managers and higher management.
• Create ad hoc reports for Admissions data analysis as requested.
• Monitor admissions process and ensure applicants receive required support.
• Develop and maintain admissions dashboards and reports.
• Forecast insights from admissions data and present findings.

Skills

SQL

Excel

Power BI

G Suite

Education

Bachelor's degree (related field)

Tools

GA4

Google Ads

Windsor.ai

Job description

Position: Business Analyst

Campus: Visakhapatnam Campus

We are looking for young, enthusiastic professionals with exceptional analytical skills to join us as Business Analysts at the Directorate of Admissions. This role requires experience in monitoring, measuring, and analyzing data outcomes, outputs, and the impact of university admissions.

Responsibilities:

• Provide detailed data analysis reports to managers and higher management based on specified requirements.
• Create ad hoc reports for Admissions data analysis as requested by management.
• Actively monitor the admissions process and intervene as necessary to ensure applicants receive the required support.
• Reconcile admissions counts at each stage of the data loading process and maintain thorough documentation.
• Identify and resolve errors in data conversion, including edits, duplicate records, and bypassed records.
• Ensure quality assurance of imported data, collaborating with quality assurance analysts when needed.
• Generate reports from single or multiple systems.
• Identify business needs, work with technology teams, and derive solutions.
• Forecast and derive insights from admissions data.
• Convert tables into actionable insights and recommend appropriate actions.
• Design presentations for weekly, biweekly, monthly, and yearly admissions reviews.

Admissions Analysis:

• Collect, analyse, and interpret admissions data across different regions.
• Identify admission trends, growth patterns, and seasonal variations across campus, schools and programmes.
• Provide insights into top-performing regions and areas with growth potential.
• Develop and maintain admissions dashboards and reports for management review.
• Conduct cohort analysis and segment applicants by source, geography, and program.

Marketing & Channel Analytics:

• Analyze paid media performance across channels (Google Ads, Meta, programmatic, CTV, Reddit, Quora) against KPIs including Cost-per-Admission (CPA), Return on Ad Spend (ROAS), and conversion rates.
• Monitor organic search performance and traffic trends across regions.
• Conduct channel attribution analysis to understand contribution of each marketing channel to admissions.
• Identify and recommend marketing spend optimization opportunities across channels.
• Develop and maintain channel performance dashboards and reports for stakeholder review.
• Support budget allocation decisions and performance marketing strategy initiatives.
• Benchmark channel efficiency and identify areas for cost optimization.
• Analyze affiliate and partnership performance metrics including conversion rates and quality metrics.

Admission Team Analysis:

• Analyse performance metrics, including applicant satisfaction, efficiency, and resolution times.
• Identify trends in admission requests and resolutions.
• Provide recommendations for improving admission quality and efficiency.
• Develop and maintain admission team performance dashboards and reports.

Admission Spend Analysis:

• Analyse budget heads and spending to identify areas for cost savings and efficiency improvements.
• Monitor financial performance against budgets and forecasts.
• Conduct ROI and unit economics analysis across marketing channels and initiatives.
• Track and report on cost-per-acquisition metrics by channel and region.

CRM & MarTech Integration:

• Manage and integrate CRM systems (e.g., Meritto, CATS) with marketing automation and analytics platforms.
• Ensure accurate data flow between lead sources, CRM, and analytics systems (GA4, Windsor.ai).
• Resolve data discrepancies and implement reconciliation processes across platforms.
• Develop and maintain system integration documentation and data mapping.
• Support platform implementations and vendor evaluation initiatives.

Reporting and Presentation:

• Present findings and recommendations to senior management and other stakeholders.
• Develop clear and concise reports and presentations that communicate complex data insights in an understandable manner.
• Strong command in designing presentations for weekly, biweekly, monthly, and yearly admissions reviews.
• Create automated dashboards and reports using Power BI, GA4, and other visualization tools.
• Maintain and schedule recurring reports for consistent stakeholder communication.

Collaboration:

• Work closely with the finance, admissions, and admission team to gather necessary data and insights.
• Collaborate with IT to ensure data integrity and availability for analysis.
• Participate in cross-functional projects to support business initiatives.
• Support vendor selection and evaluation initiatives for analytics and marketing platforms.

Requirements:

• Experience in maintaining data and performing data analysis.
• Proficiency in checking data and creating/executing dashboards with conditional logic.
• Advanced skills in SQL for data querying, extraction, and ETL workflows.
• Advanced skills in Microsoft Office (especially Excel for data analysis and generating insights) and G- suite (Google Sheets, Google Slides, and Google Docs).
• Power BI (mandatory) and other visualization software (e.g., Tableau, Looker) expertise.
• Strong communication skills to effectively interact with multiple stakeholders.
• Technical expertise in data storage structures, data mining, cleansing, and data architecture design.
• Proficiency with marketing analytics platforms (Google Analytics 4, Windsor.ai, Google Ads) and

CRM systems.

• Familiarity with Python or R for data analysis and automation (preferred).

Communication Skills:

• Excellent written and verbal communication skills are essential.
• Ability to translate complex technical data insights into business language for various stakeholders.

Interpersonal Skills:

• Ability to manage multiple projects and tasks simultaneously while meeting strict deadlines.
• Comfortable working in a fast-paced environment and within a team setting.
• Self-motivated with a positive attitude, excellent time management, and problem-solving skills.
• A go-getter mentality is crucial.

Education:

• Bachelor's degree or equivalent in a related field. Equivalent working experience is also acceptable.
• Preferable degrees: MBA (Business Analytics), MTech (Data Science), M.Sc. (Data Science), M.Sc. (Statistics), BBA (Business Analytics), B.Sc. (Statistics).

Experience (Preferred):

• 2-5 years of experience in Higher Education/University settings, especially in dynamic and highly competitive environments.
• 1-3 years of experience in digital marketing analytics, paid media management, or marketing automation (preferred).

Key Competencies:

• Analytical Thinking
• Attention to Detail
• Business Acumen
• Communication Skills
• Problem-Solving
• Collaborative Mindset
• Strategic Thinking
• Data Architecture & Infrastructure Design
• Technical Proficiency (SQL, Python, BI Tools)