Senior Data Analyst

Focal Consulting; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Benefits offered by this job

13-Month Salary

Yearly Performance Bonus

Monthly Transport Allowance

Monthly Rental Subsidies

Job summary

Focal Consulting is seeking a data analytics professional to transform raw data into reliable models and deliver actionable dashboards. You will work with Power BI, Tableau, and Metabase to translate business needs into visual insights.

The role emphasizes data quality, governance, and collaboration with product, operations, and management. A strong ownership mindset and independent work style are valued, in a dynamic startup-like environment.

Qualifications

• Education: Bachelor's Degree in Computer Science, Information Systems, Data Analytics, or related field.
• 3–6+ years of proven experience in data analysis, BI, or analytics engineering roles with large-scale datasets.
• Advanced SQL (joins, aggregations, window functions, optimization), strong data modeling (star schema), and BI dashboarding.
• Preferred: dbt (or similar transformation frameworks), ClickHouse, basic Python for data processing, startup environment experience.
• Candidate profile: strong ownership mindset, highly independent, able to turn messy data into a reliable analytics layer.

Responsibilities

• Data Transformation & Modeling: Clean, standardize, and transform raw data into reliable models (fact/dimension tables).
• Dashboard & Reporting: Design and build dashboards (Power BI, Tableau, Metabase) to translate business needs into visual insights.
• Data Quality & Governance: Identify inconsistencies and resolve upstream issues with Data Engineers, implement data validation checks.
• Stakeholder Collaboration: Partner with product, operations, and management to translate questions into data solutions.
• Data Strategy & Ownership: Define metric definitions, drive data reliability, and shape data structuring and consumption company-wide.

Skills

Advanced SQL

Data modeling

BI dashboarding

Education

Bachelor's Degree in Computer Science, Information Systems, Data Analytics

Tools

dbt

ClickHouse

Python

Job description

Role Summary

Transform raw data into structured models and actionable dashboards to drive business decisions.

Roles & Responsibilities

• Data Transformation & Modeling: Clean, standardize, and transform raw data into reliable models (fact/dimension tables) as a single source of truth.
• Dashboard & Reporting: Design and build intuitive, performant dashboards (Power BI, Tableau, Metabase) to translate business needs into visual insights.
• Data Quality & Governance: Identify inconsistencies, collaborate with Data Engineers to resolve upstream issues, and implement data validation checks.
• Stakeholder Collaboration: Partner with product, operations, and management teams to translate ambiguous business questions into structured data solutions.
• Data Strategy & Ownership: Define key metric definitions, drive best practices for data reliability, and shape how data is structured and consumed company-wide.

Requirements

• Education: Bachelor’s Degree in Computer Science, Information Systems, Data Analytics, or a related field.
• Experience: 3–6+ years of proven experience in data analysis, BI, or analytics engineering roles working with large-scale datasets.
• Technical Skills: Advanced SQL (joins, aggregations, window functions, optimization), strong data modeling (star schema), and BI dashboarding.
• Preferred Skills: Experience with dbt (or similar transformation frameworks), ClickHouse, basic Python for data processing, and fast-paced startup environments.
• Candidate Profile: Strong ownership mindset, highly independent, and capable of turning messy, evolving data into a structured and reliable analytics layer.

Benefits

• 13-Month Salary: Guaranteed additional month of base salary.
• Yearly Performance Bonus: Rewarded annually based on individual and company achievements.
• Monthly Transport Allowance: Financial support to cover daily commuting expenses.
• Monthly Rental Subsidies: Monthly allowance provided to support your housing and accommodation needs.