Job Description: Associate – Academic Operations (Technical & Data Operations)Role Overview

We are looking for a technically proficient Associate – Academic Operations to manage and optimize academic operations through data analysis, reporting, automation, and ERP system management across our programs and university campuses.

This role is best suited for candidates with a B.Tech or BCA background who possess strong technical aptitude and hands-on experience with Advanced Excel, SQL queries, data dashboards, and organizational ERP systems.

The role involves managing academic data, maintaining operational dashboards, monitoring attendance and examination records, managing ERP-based workflows, and ensuring the smooth execution of academic processes. The candidate will work closely with academic teams, faculty, university stakeholders, and internal operations teams to improve operational efficiency through technology and data-driven decision-making.

We are looking for someone who can go beyond routine coordination and use technical skills to solve operational problems, automate repetitive tasks, build reliable reporting systems, and improve organizational processes.

Key Responsibilities1. Data Management & Analysis

- Manage, validate, clean, and maintain large datasets related to learners, attendance, courses, assessments, examinations, and academic operations.
- Write and execute SQL queries to extract, analyze, reconcile, and report academic and operational data.
- Identify data discrepancies, investigate issues, and ensure data accuracy across different systems.
- Generate regular operational reports and provide actionable insights to academic and management teams.

2. Advanced Excel & Google Sheets

- Use Advanced Excel and Google Sheets features, including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, conditional formatting, advanced formulas, data validation, and data cleaning.
- Build and maintain automated trackers for attendance, examinations, invigilation, assessments, learner queries, and academic schedules.
- Develop efficient spreadsheet-based solutions to reduce manual work and improve reporting accuracy.
- Use macros, VBA, or Google Apps Script for workflow automation, wherever applicable.

3. Dashboard Development & Reporting

- Develop, maintain, and optimize data dashboards using tools such as Metabase, Power BI, Tableau, or similar platforms.
- Create dashboards to track attendance, academic performance, examination operations, learner engagement, and other key operational metrics.
- Establish regular reporting mechanisms and provide timely visibility into operational performance, pending tasks, exceptions, and process gaps.
- Convert raw data into meaningful reports that support operational and management decisions.

4.



ERP & Organizational System Management

- Manage and maintain organizational ERP systems and academic management platforms.
- Handle data uploads, system configurations, learner/course mapping, records management, and routine system updates.
- Monitor data synchronization between portals, ERP platforms, attendance devices, dashboards, and other internal systems.
- Troubleshoot system-related operational issues and coordinate with technical teams for resolution.
- Ensure data integrity, process compliance, and consistency across connected systems.

5. Academic & Examination Operations

- Support the planning and execution of classes, labs, assessments, internal contests, mid-semester examinations, and end-semester examinations.
- Maintain examination schedules, room allocations, invigilation plans, attendance records, and assessment trackers.
- Use data and reporting tools to identify attendance discrepancies, examination exceptions, and pending academic activities.
- Coordinate with faculty, academic teams, examination teams, and university stakeholders to ensure timely execution.

6. Process Automation & Improvement

- Identify repetitive manual tasks and develop technology-driven solutions to improve efficiency.
- Automate reports, trackers, data reconciliation, notifications, and routine operational workflows.
- Document standard operating procedures (SOPs) and establish standardized reporting processes.
- Proactively identify process bottlenecks and recommend solutions using data, automation, and system improvements.

7. Stakeholder & Learner Support

- Coordinate with faculty, academic teams, university administrators, and internal stakeholders to resolve operational dependencies.
- Investigate learner-related issues involving attendance, academic records, assessments, and system access.
- Track and resolve operational queries within defined timelines.
- Communicate system issues, data discrepancies, and operational updates clearly to relevant stakeholders.

Required Qualifications & Skills

- Educational Qualification: B.Tech/B.E. in Computer Science, Information Technology, or a related technical field, or BCA.
- Advanced Excel/Google Sheets: Solid practical knowledge of formulas, Pivot Tables, lookups, data cleaning, reporting, and large-data handling.
- SQL: Ability to write SQL queries using SELECT, WHERE, JOIN, GROUP BY, aggregate functions, subqueries,



and other commonly used query techniques.
- Dashboarding: Hands-on experience creating or maintaining dashboards using Metabase, Power BI, Tableau, or similar tools.
- ERP/System Management: Understanding of ERP systems, database-driven applications, data mapping, record management, and operational workflows.
- Analytical Thinking: Ability to analyze large datasets, identify discrepancies, troubleshoot issues, and derive actionable insights.
- Technical Problem-Solving: Ability to investigate system and data-related issues and coordinate appropriate resolutions.
- Communication: Strong written and verbal communication skills for effective coordination with technical and non-technical stakeholders.
- Ownership: Ability to independently manage tasks, prioritize multiple requirements, and ensure timely completion.

Preferred Qualifications & Skills

- 1–2 years of experience in data operations, academic operations, business operations, MIS reporting, or technical operations.
- Experience working in a university, college, edtech organization, or other education-focused environment.
- Familiarity with Metabase, Power BI, Tableau, or similar reporting tools.
- Basic knowledge of Python, JavaScript, Google Apps Script, VBA, or other scripting/automation tools.
- Experience working with ERP platforms, student information systems, academic portals, or attendance management systems.
- Understanding of data validation, database structures, system integrations, and workflow automation.

Ideal Candidate Profile

The ideal candidate is a technology-oriented operations professional who combines technical knowledge with strong execution skills. They should be comfortable working with databases, spreadsheets, dashboards, and ERP systems while ensuring that academic operations run smoothly.

The candidate should be able to independently analyze data, write SQL queries, build reports and dashboards, troubleshoot system-related issues, and automate repetitive operational tasks.

The most important selection criteria are:

- B.Tech/BCA educational background with strong technical aptitude.
- Practical knowledge of Advanced Excel and Google Sheets.
- Ability to write SQL queries and work with structured datasets.
- Experience or demonstrated ability in building and maintaining data dashboards.
- Understanding of ERP systems and organizational data management.
- Strong analytical thinking, troubleshooting, and process automation skills.

Role Type: Full-time
Experience: 1–2 years preferred; capable freshers with strong technical skills may also be considered.
Function: Academic Operations, Data Operations & Systems Management

Pay: ₹30,000.00 - ₹45,000.00 per month

Benefits:

- Food provided

Work Location: In person

📌 Academic Operations Associate [ Data Operations ] (Sonipat)
🏢 Newton School of Technology Sonipat
📍 Sonipat