Data Analyst

Dexian; Penang; On-site; MYR 120,000 - 180,000; Full time

Job summary

Dexian is seeking a data engineering/AI specialist to analyze large datasets, build Power BI dashboards, and design scalable data models for business reporting. You will develop automation scripts in Python, implement AI-powered solutions with LLMs, and collaborate across IT and business teams to drive automation and AI adoption.

Experience with Databricks and strong SQL skills are required. The role emphasizes data governance, stakeholder communication, and delivery from concept to production,

Qualifications

• Strong Python programming and scripting skills.
• Experience with data analytics, statistical analysis, and data visualization.
• Hands-on experience with Power BI, including DAX and data modeling.
• Experience working with Databricks
• Strong SQL and database knowledge.
• Working knowledge of AI technologies, including:
• Generative AI
• Agentic AI
• Prompt Engineering
• Experience integrating data from multiple enterprise systems.
• Strong problem-solving and analytical thinking skills.
• Good communication and stakeholder management skills.
• Ability to independently drive projects from concept to implementation.

Responsibilities

• Analyze large datasets to identify trends, patterns, and business insights.
• Develop dashboards, reports, and data visualizations using Power BI.
• Design and implement data models to support business reporting and decision-making.
• Develop automation solutions and scripts using Python and other programming languages.
• Build AI-powered solutions utilizing LLMs, Generative AI, Agentic AI, and RAG technologies.
• Work with structured and unstructured data from enterprise systems, knowledge bases, support platforms, and business applications.
• Utilize Databricks for data processing, analytics, and AI solution development.
• Develop proof-of-concepts and production-ready AI solutions.
• Collaborate with business, IT, and technical teams to identify opportunities for automation and AI adoption.
• Support data quality improvement, governance, and validation activities.
• Evaluate and optimize AI solution performance.
• Present findings and recommendations to technical and non-technical stakeholders.

Skills

Python

Data analytics

Power BI

DAX

Data modeling

Databricks

SQL

AI technologies

Generative AI

Agentic AI

Prompt Engineering

Stakeholder management

Project delivery

Education

Bachelor's Degree in Data Science

Bachelor's Degree in Computer Science

Bachelor's Degree in Software Engineering

Bachelor's Degree in Data Analytics

Bachelor's Degree in Information Systems

Tools

Power BI

Databricks

Azure AI Services

OpenAI

LangChain

SQL databases

Job description

• Analyze large datasets to identify trends, patterns, and business insights.
• Develop dashboards, reports, and data visualizations using Power BI.
• Design and implement data models to support business reporting and decision-making.
• Develop automation solutions and scripts using Python and other programming languages.
• Build AI-powered solutions utilizing Large Language Models (LLMs), Generative AI, Agentic AI, and Retrieval-Augmented Generation (RAG) technologies.
• Work with structured and unstructured data from enterprise systems, knowledge bases, support platforms, and business applications.
• Utilize Databricks for data processing, analytics, and AI solution development.
• Develop proof-of-concepts and production-ready AI solutions.
• Collaborate with business, IT, and technical teams to identify opportunities for automation and AI adoption.
• Support data quality improvement, governance, and validation activities.
• Evaluate and optimize AI solution performance.
• Present findings and recommendations to technical and non-technical stakeholders.

Bachelor's Degree in:

• Data Science
• Computer Science
• Software Engineering
• Data Analytics
• Information Systems

Prerequisite

• Strong Python programming and scripting skills.
• Experience with data analytics, statistical analysis, and data visualization.
• Hands-on experience with Power BI, including DAX and data modeling.
• Experience working with Databricks
• Strong SQL and database knowledge.
• Working knowledge of AI technologies, including:
• Generative AI
• Agentic AI
• Prompt Engineering
• Experience integrating data from multiple enterprise systems.
• Strong problem-solving and analytical thinking skills.
• Good communication and stakeholder management skills.
• Ability to independently drive projects from concept to implementation.

Preferred Qualifications

• Experience developing AI copilots or enterprise AI applications.
• Experience with Azure AI Services, OpenAI, LangChain, or similar AI frameworks.
• Experience building automated reporting and analytics solutions.
• Experience handling customer support, operations, or business intelligence data.
• Familiarity with cloud platforms and modern data architectures.