Job Description

Perform data requirement gathering, analysis and documentation
• Interpret use case requirement and design of target data model/ data mart
• Interpret data, analyze results using statistical techniques and provide ongoing reports by
stakeholders
• Set up and implement enhancements to automate and simplify data reporting process
• Train and support users in using the reporting tools
• Maintain the data warehouse system to ensure system performance
• Troubleshoot, debug when data is found to be inaccurate
Work Functions, Key Tasks
• Work with management and stakeholders to prioritize business and information needs
• Transform business requirement to data requirement, data analysis and profilingDesign data models for use cases and data warehousing
• Perform data cleaning and ensure data quality and integrity in data warehouse
• Root cause analysis of data issues and coming up with stable long terms solutions
• Support data store’s inbound and/or outbound development
• Perform data acceptance testing
• Support SIT and UAT
Key Performance Expectations
• Implement and build a reliable data warehouse which meets the business needs of all stakeholders
and according to data warehouse architecture guidelines
• Identify data from different source systems and build the target data models
• Ensure business rules and data definition are standardised across users and reports/dashboards
• Produce professional quality reports, presentations and analysis with insights
• Responsible for business analysis, user coordination and some implementation of business
initiatives
• Perform data analysis and compile daily, weekly and monthly user reports
• Ensure company’s data policy, data security standard and data governance guidelines are adhered
to

Job Requirements

• Technical expertise regarding data models, database design development, data mining and segmentation techniques
• Strong knowledge of and experience with visualization tools (Qliksense, Tableau, Power BI etc),
databases (MSSQL, MYSQL etc), programming (SQL, Python, Java, R)
• Running and maintaining large ETL/ELT jobs to ingest and process data
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant
amounts of information with attention to detail and accuracy
• Adept at queries, report writing and presenting findings
• Preferably have statistical skills

Work Location (MRT)