• Developing Python scripts for data extraction from sources, loading into a PostgreSQL data warehouse in collaboration with the data engineer.• Utilising dbt for the ELT process, transforming raw data, running data quality checks to ensure the accuracy, reliability, and completeness of data for analytics-ready models.• Designing DAGs in Astro (Apache Airflow) to automate data workflows, including Python and dbt tasks.• Setting up alerts and monitoring using Astro to ensure smooth pipeline operation and quick issue resolution.• Deploying pipeline components using Docker and Docker Compose for consistent environments and easy scaling.• Creating interactive dashboards and reports in Metabase, providing insights from transformed data and automate weekly report generation and distribution to stakeholders via email.• Using Metabase to visualize data and automate weekly report generation and distribution to stakeholders via email.

- Utilized Excel for data entry and organisation of student data.- Maintained spreadsheets for storing and managing student enrollment data and results.- Monitored and maintained department’s computer systems.- Conducted routine hardware and software maintenance tasks, including system updates andbackups.- Assisted department and staff with technical issues and provided IT support as needed.- Ensured compliance with department’s IT policies and security standards.

- Managed the CEO's daily schedule, travel arrangements, and correspondence.- Coordinated executive meetings and ensured timely follow-up on action items.- Facilitated effective communication between the CEO and clients.- Cleaned raw survey data collected from field works to be plotted with AutoCAD.