Specialist, Finance Data

TNG Digital Sdn Bhd; Kuala Lumpur; Hybrid; MYR 80,000 - 120,000; Full time

Job summary

TNG Digital Sdn Bhd in Kuala Lumpur invites a Finance Data Specialist to build and maintain the harmonized Finance Data Warehouse. The role focuses on data modeling, table/view development, and translating ERP feeds into standardized schemas to enable accurate financial dashboards.

You will write and optimize SQL/ETL scripts, perform data quality checks, and document data flows. Collaboration with the Data/BI team and ERP project stakeholders is essential for successful data ingestion.

Qualifications

• Familiarity with data analytics, data engineering or related roles.
• Experience in data warehousing concepts and ETL/ELT processes preferred.
• Proficiency in SQL and Python for data wrangling and analysis.
• Understanding of financial data (GL, AP/AR) is a plus.
• Able to document data flows and support dashboards/BI reporting.

Responsibilities

• Build and maintain fact/dimension tables in MaxCompute to support the FDW.
• Translate ERP/source data into standardised schemas with accurate mappings.
• Develop and optimize SQL/ETL scripts; ensure data quality before release.
• Create and maintain data dictionaries, lineage docs, and change logs.
• Support dashboards and finance applications with reliable datasets.

Skills

SQL

Python

BI tools

Data modeling

Data wrangling

Data quality

Data lineage

ETL/ELT

Education

Data Analytics/IS degree

Tools

MaxCompute

Job description

Specialist, Finance Data##### Contact usLoginBack# Specialist, *Finance Data*NEWKuala Lumpur, MalaysiaPermanent#### Duties & Responsibilities* 1. Data Modeling & Table/View Development* Build and maintain fact and dimension tables in Ali Cloud (MaxCompute) supporting the harmonised Finance Data Warehouse (FDW), under the data architecture and mapping logic defined by the Senior Manager* Translate source data from Sage ERP, Oracle Fusion ERP, and business-unit non-financial feeds into standardised, harmonised schemas* Write, test, and optimise SQL (and where applicable Python-based ETL scripts) to extract, transform, and load data into the warehouse* Perform data quality checks — completeness, referential integrity, duplicate detection, reconciliation against source systems — before tables/views are released for downstream use* 2. Documentation* Maintain data dictionaries, table/column-level documentation, source-to-target mapping documents, and lineage records for every table and view built* Document ETL logic, transformation rules, and refresh schedules so pipelines are auditable and can be handed over or reconfigured by others* Keep a change log of schema/logic changes, including business rationale, to support audit and continuity* 3. BI & Reporting Support* Build and maintain views/datasets that feed dashboards and finance applications* Perform reconciliation between source data and output data, ensuring data quality and completeness at every stage* Support ad hoc data extraction requests from FIT and other Finance stakeholders once base tables are in place* 4. Cross-Functional Coordination* Liaise with the Data/BI team and the ERP Project Team on data ingestion scope, field mapping, and integration touchpoints* Escalate data gaps, source system limitations, or ingestion blockers to the Senior Manager with supporting evidence#### Requirements* Education & Experience* Diploma/Degree in Data Analytics, Information Systems, or related field. Relevant academy qualifications for Finance and Accounting will be an added advantage.* At least 1–2 years of relevant experience in data analytics, data engineering, or a similar data-handling role* Technical Skills* Working proficiency in SQL (joins, aggregations, window functions); willingness/ability to work in MaxCompute specifically* Basic to intermediate Python, with relevant skills for data wrangling, cleaning, and analytics (e.g. pandas or equivalent)* Familiarity with dashboard/BI tools, including building datasets/data models for dashboards, not just consuming them* Understanding of data warehouse concepts: fact/dimension modeling, ETL/ELT, data lineage* Comfortable using AI coding/analysis assistants (Claude, Copilot, etc.) as part of daily workflow* Domain & Soft Skills* Basic understanding of finance/accounting data (GL, AP/AR, trial balance) is a strong advantage — helps the analyst sanity-check what they're modeling* High attention to detail and comfort with \"unglamorous\" ground work: data cleaning, documentation, reconciliation* Strong written documentation habits — this role exists partly because documentation must be thorough and consistent* Able to work independently on defined tasks while escalating ambiguity rather than guessing* Growth mindset — this is a hands-on build role with a well-defined data architecture to work within, not undefined strategic work