MIS Analyst SUNDUS MANAGEMENT CONSULTANCY & STUDIES BUREAUL.L.C

Business Intelligence & Reporting

1. Gather and translate business requirements into KPIs, metrics, and reporting specifications.

2. Design, develop, and maintain Power BI dashboards, reports, and scorecards aligned with business objectives.

3. Build and maintain semantic models / datasets (Power BI dataset, star schema) to ensure scalable reporting.

4. Create automated, scheduled reporting where appropriate and ensure reports are accessible, consistent, and user-friendly.

Data Preparation & Modelling

1. Collect data from approved sources (e.g., databases, Excel, line-of-business systems) and perform data cleansing, transformation, and validation using Power Query (M) and other approved tools.

2. Develop and optimize DAX measures and calculations to support accurate insights.

3. Maintain a consistent metric definition (single source of truth) and support master data consistency where applicable.

Data Quality, Governance & Documentation

1. Perform routine data quality checks and reconcile reporting outputs with source systems.

2. Document datasets, KPI definitions, report logic, refresh schedules, and data lineage to support auditability and continuity.

3. Apply appropriate data access controls and follow internal policies for confidentiality and information security.

Performance & Continuous Improvement

1. Monitor and improve dashboard performance (model size, refresh time, visuals, DAX optimization).

2. Identify opportunities to standardize and streamline recurring reports and reduce manual reporting effort.

Stakeholder Support & Enablement

1. Act as the key point of contact for assigned reporting areas, providing guidance on best ways to interpret and use dashboards.

2. Conduct basic user enablement sessions (how to read dashboards, filters, drill-through, export options).

3. Coordinate with IT / data owners / vendors as needed for data access, source stability, and refresh reliability.

Business Analysis

1. Engage business stakeholders to understand needs, objectives, challenges, and reporting outcomes.

2. Conduct workshops/interviews to elicit and clarify requirements, definitions of KPIs, and data sources.

3. Translate business needs into clear functional requirements and acceptance criteria for reporting solutions.

4. Prepare and maintain Business Requirements Documents (BRDs) and supporting artifacts.

5. Plan, coordinate, and moderate User Acceptance Testing (UAT) with business users.

6. Support the business during UAT, resolving misunderstandings, and ensuring acceptance criteria are met.

Change Management & Adoption

1. Support rollout by preparing user guidance (quick reference notes) and conducting brief walkthrough sessions for stakeholders.

2. Gather feedback post-release and prioritize enhancements in coordination with the reporting manager.

Other Duties

1. Perform any other related 

2. MIS/BI tasks as assigned, in line with organizational priorities.

Self-Management Responsibilities

1. Define performance goals at the start of the year with the reporting manager and ensure achievement throughout the year.

2. Maintain high proficiency in required competencies and keep up to date with BI best practices and emerging analytics capabilities.

3. Demonstrate ownership, accuracy, and professionalism in all deliverables and stakeholder interactions.