Data & Analytics Engineer

About the role

As a Data & Analytic Engineer, your 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.

Key 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.

About you

• Bachelor's degree in Data Analytics, Information Technology, or any other similar courses
• At least 3 years of relevant experience in data analytics work, creating and implementing effective data visualization, dashboards, and reports.
• 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.
• 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.
• Excellent communication skills, with the ability to present complex data insights to both technical and non-technical audiences.