Data & Analytics Engineer

Role Purpose:

As a Data & Analytic Engineer, your new role will involve driving analysis and providing business insights to support the growth and expansion of the university operation. Once a project is assigned to you, you will be responsible for understanding the requirements, establishing the process, providing a timeline, collaborating with the team and stakeholders, and performing technical functions such as data extraction, cleaning, structuring, massaging, and analysis using primarily the Structured Query Language (SQL) programming language. These activities will result in insights and recommendations that will be presented to the users. Additionally, you will be required to generate reports for the user as needed. You will work with a team to execute assigned projects and report to the project team. If you excel in critical thinking and possess the ability to analyze complex datasets, this role is well-suited for you.

KEY RESULT AREAS / RESPONSIBILITIES

Develop and implement efficient processes for collecting and analyzing both internal and external data, transforming them into actionable operational insights.

Extract and cleanse data from the data warehouse using SQL, applying necessary transformations and formulas to ensure data quality and consistency, followed by comprehensive analysis.

Manage large datasets to generate data-driven insights that support business strategy, operational improvements, and informed decision-making.

Define key performance indicators (KPIs) and establish processes to monitor and evaluate business performance and progress.

Analyze trends, assess current operational strategies, and provide critical insights to identify potential risks and areas for improvement.

Automate reporting workflows to streamline data delivery and enhance team and organizational efficiency.

Collaborate with internal stakeholders to understand business challenges, define problem statements, gather requirements, and prioritize and implement sustainable data-driven solutions that address business needs.

Design, maintain, and automate reports, dashboards, and business processes to meet the reporting needs of various stakeholders across the organization.

Maintain detailed documentation for all tasks, processes, and analytical findings to ensure transparency and knowledge sharing.

JOB SPECIFICATION

MINIMUM ACADEMIC / PROFESSIONAL QUALIFICATION

Candidate must possess at least bachelor’s degree in Data Analytics, Information Technology, or any other similar courses

RELATED EXPERIENCE

At least 3 of relevant experience in data analytics work, creating and implementing effective data visualization, dashboards, and reports.

COMPETENCIES (KNOWLEDGE, SKILLS & ABILITIES)

• Proficiency in accessing relational databases using SQL, with a strong ability to write, modify, and optimize SQL queries.
• Hands-on experience with various database systems (e.g. SQL Server, Oracle, MySQL, PostgreSQL).
• Practical experience with data extraction, transformation, and loading (ETL) tools and platforms. (e.g. Pentaho ETL)
• Experience navigating databases or data warehouses to understand raw data sources, perform data cleansing, and execute dimensional modeling tasks.
• Expertise in using data visualization tools (e.g., Power BI, DAX, D3.js, SAS Viya) to design and deliver interactive reports and dashboards.
• Familiarity with statistical analysis tools and languages such as R or Python is a plus.
• Strong understanding of data analysis methodologies and techniques, with the ability to work with large, complex datasets.
• Proven ability to collaborate effectively with business stakeholders to gather requirements and translate them into actionable solutions.
• Logical, analytical thinker with the ability to understand and connect disparate pieces of information to see the bigger picture.
• Skilled in presenting ideas and solutions in a clear, structured manner.
• Self-motivated and able to work independently, prioritize tasks, and manage time effectively.
• Excellent communication skills, with the ability to present complex data insights to both technical and non-technical audiences, leveraging storytelling techniques to convey key findings.

COMPETENCIES (BEHAVIOURAL)

• Creative thinking & innovation - knows when a new approach may be required.
• Communicating effectively - discusses and presents ideas logically, clearly using facts and appropriate supporting materials.
• Teamwork & collaboration - works harmoniously as a member of a team, sharing knowledge, and information and keeps team members informed and updated about the work of the group.
• Results orientation - Takes personal ownership and completes own work according to established standards in an accurate and timely manner.