Power BI Analyst

Salary: ₱50,000 – ₱60,000 per month

Key Responsibilities

Data Visualization and Reporting

• Develop and maintain interactive dashboards and reports using Power BI to monitor key institutional metrics, including student performance, enrolment trends, faculty productivity, and operational efficiency.

• Create reports that provide actionable insights to support management and institutional decision-making.

• Maintain and improve existing dashboards based on reporting requirements and stakeholder feedback.

• Utilize DAX and Power Query to transform data and develop meaningful business metrics.

Data Analysis and Data Management

• Analyse datasets to identify trends, patterns, and opportunities for improvement in academic and administrative operations.

• Perform basic statistical and cohort analysis to support student performance monitoring and institutional planning.

• Ensure data accuracy, consistency, and reliability across reports and BI systems.

• Conduct data validation, cleaning, and reconciliation to ensure accurate reporting.

Data Engineering and Integration

• Develop and maintain basic to intermediate data pipelines for extracting, transforming, and loading data from various institutional systems.

• Integrate data from external platforms using REST APIs.

• Utilize Python for data extraction, transformation, cleaning, and repetitive data processing tasks.

• Write SQL queries to retrieve, manipulate, and aggregate data from relational databases.

• Assist in improving existing data workflows and automating manual data integration processes.

AI and Process Automation

• Explore and implement practical AI-assisted solutions to improve data processing, reporting, and administrative workflows.

• Identify repetitive tasks that can be automated using Python, AI tools, and available automation platforms.

• Assist in developing automation solutions that reduce manual work and improve operational efficiency.

• Support the integration of AI capabilities into existing reporting and data processes.

Collaboration and Stakeholder Engagement

• Work with academic departments, administrative teams, and IT personnel to understand reporting and data requirements.

• Translate business requirements into dashboards, reports, and data solutions.

• Coordinate with stakeholders to improve the accessibility and utilization of institutional data.

System Maintenance and Optimization

• Troubleshoot issues involving Power BI reports, data connections, SQL queries, and data pipelines.

• Improve existing dashboards, queries, and data processes to enhance performance and accuracy.

• Maintain documentation of reports, data sources, and developed solutions.

Required Skills and Qualifications

• Experience developing dashboards and reports using Microsoft Power BI.

• Working knowledge of DAX and Power Query.

• Proficiency in SQL for data extraction, manipulation, and reporting.

• Working knowledge of Python for data processing and automation.

• Basic understanding of REST APIs and data integration.

• Understanding of ETL processes and data pipeline development.

• Strong analytical and problem-solving skills.

• Ability to communicate technical findings to non-technical stakeholders.

• Willingness to learn and explore AI tools and automation technologies.

Preferred Qualifications

• At least 3 years of experience with Microsoft Power BI.

• Familiarity with LMS tools and Student Management System.

• Exposure to AI tools, workflow automation, and predictive analytics.

• Knowledge on creating Data Pipelines.