SQL Data Analyst
Description
Salary: RM 6,500 – RM 7,500 per month
About the role
Hey, SQL enthusiasts! 👋
If you're confident in SQL, able to independently write queries, and familiar with analysing transaction datasets, we'd love to hear from you!
Key responsibilities
1. Data Analysis & Insights
Analyse user, transaction and alternative data to identify patterns, trends, anomalies and potential issues.
Conduct data and statistical analysis to support operational and risk-related decision-making.
Translate analytical findings into actionable insights and recommendations.
Develop and maintain dashboards to monitor business metrics and performance.
2. Data Pipeline Management
Independently manage and maintain data pipelines to ensure data integrity and efficient data flow.
Monitor data processes and investigate data inconsistencies or pipeline issues.
Perform data extraction, transformation, validation and manipulation using SQL.
Collaborate with data quality teams to strengthen data monitoring and reporting accuracy.
3. Dashboard Development & Reporting
Build, maintain and troubleshoot dashboards using Power BI and/or Tableau.
Generate regular operational reports and ad hoc analytical reports.
Ensure dashboards provide accurate, timely and meaningful business insights.
Improve reporting processes and identify opportunities for automation.
4. Risk Analytics & Management
Analyse transaction patterns, user behaviour and alternative data to identify potential risks.
Support the optimisation and monitoring of risk rules and algorithms.
Monitor key risk metrics and identify emerging trends or anomalies.
Collaborate with stakeholders to support risk-related business decisions.
5. Stakeholder Collaboration
Work closely with Sales, Finance, Marketing, Operations, Risk and other relevant teams.
Understand business requirements and translate them into analytical solutions.
Present data insights and recommendations clearly to stakeholders.
Support ad hoc analytical projects and continuous process improvements.
Requirements
Bachelor's Degree in Computer Science, Computer Engineering, Information Technology, Data Science, Engineering, Science or a related quantitative discipline.
Minimum 3 years of experience in Data Analytics, Business Analytics, Business Intelligence or related analytical roles.
Strong hands-on SQL skills, including data retrieval, querying, manipulation and analysis.
Minimum 1 year of practical experience using Power BI for dashboard development, maintenance and visualisation.
Experience handling large datasets and performing data quality checks.
Good understanding of data pipelines, ETL/ELT processes and data management.
Strong analytical and problem-solving capabilities.
Able to work independently and manage multiple analytical tasks.
Added advantages
Experience with Python, R or other scripting languages.
Experience with Tableau, DAX and Power Query.
Exposure to fraud analytics, risk management, transaction monitoring or payment analytics.
Experience in fintech, banking, SaaS, e-commerce or technology companies.
Knowledge of statistical techniques, experimentation and A/B testing.
Experience automating reporting and data processing activities.