Data-Driven BI & Systems Analyst

Agensi Pekerjaan ASK Resources Sdn Bhd; Petaling Jaya; On-site; MYR 67,000 - 89,000; Full time

Job summary

Agensi Pekerjaan ASK Resources Sdn Bhd is seeking a Business Intelligence & Systems Analyst in Petaling Jaya to bridge systems, data, and BI. You will analyze systems, data flows, APIs, and stakeholder needs to deliver actionable insights and robust dashboards.

The role requires 3–5 years in BI/Data Analysis with strong SQL, databases, and data modelling skills, plus collaboration across multiple teams to improve reporting and data quality.

Qualifications

• Bachelor's Degree in IT, CS, IS, Business Analytics, Data Analytics, or related field.
• 3–5 years of relevant experience in System Analysis, Business Intelligence, Data Analysis, or related roles.
• Strong analytical, logical thinking, and problem-solving skills.
• Good understanding of system workflows, databases, APIs, and system integrations.
• Good SQL skills with the ability to independently query, investigate, and analyze data.
• Good understanding of relational databases such as MySQL, PostgreSQL, SQL Server, or equivalent.
• Understanding of Data Warehouse, ETL/ELT, data pipelines, data marts, and data modelling concepts.

Responsibilities

• Analyze applications, databases, APIs, integrations, and system workflows.
• Understand and document end-to-end system and data flows across different applications and platforms.
• Analyze system behaviour and identify gaps, dependencies, risks, and improvement opportunities.
• Perform system impact analysis for new features, enhancements, and Change Requests (CR).
• Work closely with developers, architects, DBAs, infrastructure, and other technical teams to identify appropriate solutions.
• Assist in analyzing API integrations, data mappings, system interfaces, and dependencies.
• Investigate system issues and work with relevant technical teams to identify root causes.
• Maintain system flows, integration documentation, data flow diagrams, and other relevant technical documentation.
• Analyze business and operational data to identify trends, patterns, anomalies, risks, and opportunities.
• Write and execute SQL queries for data extraction, investigation, reconciliation, and analysis.
• Translate business and management questions into measurable KPIs and analytical requirements.
• Provide meaningful insights and recommendations based on data analysis.
• Perform ad-hoc analysis based on management and business requirements.
• Analyze customer/player behaviour, transaction patterns, conversion, retention, churn, and other relevant business metrics.
• Identify unusual patterns or significant changes in business performance and investigate the underlying causes.
• Work with relevant teams to develop and improve business reports and dashboards.
• Participate in Data Warehouse initiatives, including data mapping, KPI definition, data modelling requirements, and validation.
• Understand data lineage from source systems through databases, ETL/ELT processes, Data Warehouse, and reporting platforms.
• Work with Data Engineers and DBAs to define data requirements and transformation rules.
• Validate data accuracy, completeness, consistency, and integrity across different systems.
• Perform data reconciliation between source systems, databases, Data Warehouse, dashboards, and reports.
• Investigate data discrepancies and identify where issues may have occurred within the data flow.
• Coordinate with relevant system owners and technical teams to resolve data quality issues.
• Maintain documentation for data definitions, business rules, KPIs, data mappings, and data lineage.
• Work with stakeholders to understand reporting and dashboard requirements.
• Support the development and maintenance of management and operational dashboards.
• Define and validate KPIs and reporting metrics.
• Ensure reporting metrics and KPIs are consistently defined across different systems and departments.
• Validate dashboard and report data against source systems.
• Identify opportunities to automate recurring reports and reduce manual reporting.
• Continuously improve dashboards and reports based on business and management needs.

Skills

SQL skills

Data analysis

System analysis

Relational databases

ETL/ELT

Data warehousing

Analytical thinking

Problem solving

Education

Bachelor's Degree in IT/CS/IS

Tools

MySQL

PostgreSQL

SQL Server

Job description

Agensi Pekerjaan ASK Resources Sdn Bhd is seeking a Business Intelligence & Systems Analyst in Petaling Jaya to bridge systems, data, and BI. You will analyze systems, data flows, APIs, and stakeholder needs to deliver actionable insights and robust dashboards.

The role requires 3–5 years in BI/Data Analysis with strong SQL, databases, and data modelling skills, plus collaboration across multiple teams to improve reporting and data quality.