Job Title: Senior Data Analyst
Location: Kuala Lumpur, Malaysia
Responsibilities:
- Collaborate with the Data Engineer and Data Modeller to understand data sources, transformation logic, and business requirements for the project
- Develop conceptual, logical, and physical data models aligned with the project’s data architecture, ensuring consistency across bronze and gold layers
- Document and maintain metadata, including data dictionaries, field definitions, business rules, and transformation mappings, within Data Hub or other metadata management tools.
- Analyse source-to-target data mapping to ensure accuracy and completeness of transformation logic.
- Work with stakeholders to capture business definitions, KPIs, and data usage requirements.
- Conduct data profiling and quality analysis to identify gaps, inconsistencies, and anomalies
- Partner with data governance teams to ensure compliance with data privacy, anonymization, and classification standards
- Support testing and validation of transformed datasets to ensure they meet business and technical specifications
- Provide ongoing updates and clear documentation to ensure transparency across the project lifecycle
Required Technical Skill Set:
- Proven experience in data analysis, data modelling, and metadata management.
- Strong ability to create ER diagrams, star/snowflake schemas, and dimensional models.
- Proficient in metadata documentation using tools such as Data Hub, Collibra, or Alation.
- Solid understanding of data warehousing concepts and data lakehouse architectures.
- Experience in source-to-target mapping and documenting transformation logic.
- Knowledge of data governance and compliance best practices.
- Strong SQL skills for data analysis and validation.
- Excellent communication skills to bridge technical and business requirements
Desired Competencies:
- Familiarity with Azure Data Lake Storage (ADLS), Azure Data Factory (ADF), and Databricks environments.
- Experience in business glossary creation and data lineage documentation.
- Exposure to ETL testing and validation processes.
- Understanding of BI tools (e.g., Power BI, Tableau) for data consumption
- Experience in data modeling data solutions including but not limited to Erwin Data modeler data Warehouse or equivalent knowledge.
Good to have:
- Experience in working with large customers in enterprise application development in the specified skillsets
- Experience in Agile based development
