Data Analyst

Job Description & Person Specification

1. Job Details

Job Title: Executive Data Analyst
Department: Career Development Centre
Location: MIT World Peace University (MIT-WPU), Pune
Reporting To: Director- Career Development Centre

2. Job Purpose

The Executive Data Analyst will be a key strategic and operational partner, driving the University's Business Intelligence (BI) and analytics initiatives. This role is responsible for the end-to-end design, development, and management of robust data frameworks, dashboards, and reporting systems. The goal is to enable data-driven decision-making that aligns with institutional objectives. The incumbent will ensure data integrity, optimize reporting processes, and provide actionable insights to leadership to enhance overall organizational performance.

3. Key Accountabilities

A. Strategic Responsibilities

• Support the design and execution of the University's analytics and business intelligence strategy.
• Translate management objectives into actionable analytics frameworks and reporting solutions.
• Provide strategic insights through advanced data analysis and visualization.

B. Operational Responsibilities

• Serve as the single point of contact (SPOC) for Business Intelligence and reporting.
• Design, develop, and maintain dashboards, analytics frameworks, and management reports.
• Perform Extract, Transform, Load (ETL) operations for data from various internal and external sources.
• Manage and optimize data warehouses, databases, and reporting environments.
• Write and optimize SQL queries for complex data extraction and validation.
• Manage master data, including creation, updates, and deletion.
• Ensure data accuracy, integrity, normalization, and security compliance.
• Design and manage reporting environments, including metadata, data sources, and access security.
• Provide quality assurance (QA) for imported data and improve upstream data processes.
• Support internal teams and external vendors in data warehouse implementation and upgrades.
• Develop and generate automated and ad-hoc reports across multiple platforms.
• Train and support end users on dashboards, reports, and BI tools.
• Create executive presentations, dashboards, and visual analytics using infographics and charts.
• Ensure confidential data handling and regulatory compliance.

C. Research & Development

• Stay updated with emerging trends, tools, and best practices in analytics, BI, and data science.
• Recommend and implement innovative analytics solutions.

D. Financial & Budget Responsibilities

• Ensure optimal utilization, monitoring, and control of allocated analytics and IT budgets.
• Support cost optimization initiatives through data-driven insights.

E. Collaboration & Stakeholder Engagement

Internal: Schools, Academic Units, Departments, Functions, Leadership Teams

External: Technology partners, BI vendors, professional academic networks, industry forums

4. Person Specification

A. Experience & Competencies

• Minimum 3+ years of experience in Business Intelligence, Data Analytics, or related domains.
• Prior experience in the education sector or university environment is preferred.
• Proven hands-on expertise in: SQL & Database Management, Power BI / Tableau / Periscope, Advanced MS Excel, Data Modelling & Warehousing, ETL Frameworks, Reporting Tools (e.g., Business Objects).

B. Technical Expertise

• Strong knowledge of SQL querying and optimization, data visualization and dashboarding, data warehousing concepts, ETL processes and frameworks, programming exposure (XML, JavaScript, ETL tools), and data governance, normalization, and security.

C. Behavioral & Leadership Attributes

• Highly proactive, self-driven, and result-oriented professional.
• Strong ownership mindset with the ability to work independently.
• Demonstrated ability to drive innovation and process improvements.
• Excellent communication, presentation, and documentation skills.
• Strong analytical thinking and structured problem-solving ability.
• Collaborative mindset with the capability to work across multiple stakeholders and functions.
• Ability to manage pressure, deadlines, and dynamic requirements.

D. Educational Qualification

• Graduate / B.Tech in Information Technology, Computer Science, Data Science, or a related field.