Data Analyst

& 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 serve as a strategic and operational partner in driving the Universitys Business Intelligence (BI) and analytics initiatives. The role is responsible for designing, developing, and managing robust data frameworks, dashboards, and reporting systems to enable data-driven decision-making aligned with institutional objectives.

The incumbent will manage end-to-end analytics operations, ensure data integrity, optimize reporting processes, and support leadership with actionable insights to enhance organizational performance.

3. Key Accountabilities

A. Strategic Responsibilities

• Support the design and execution of the Universitys 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

• Act as the single point of contact (SPOC) for Business Intelligence and reporting.
  
• Design, develop, and maintain dashboards, analytics frameworks, and management reports.
  
• Extract, transform, and load (ETL) data from multiple internal and external data 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 data 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 education sector / university environment preferred.
  
• Proven hands-on expertise in:
  
• SQL & Database Management
  
• Power BI / Tableau / Periscope
  
• Advanced MS Excel
  
• Data Modelling & Warehousing
  
• ETL Frameworks
  
• Reporting Tools (Business Objects, etc.)
  

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)
  
• Data governance, normalization, and security
  

C. Behavioral & Leadership Attributes

• Highly proactive, self-driven, and result-oriented professional.
  
• Strong ownership mindset with 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 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 related field.