Job Description

Location Singapore, Central Singapore

Planning Area
OUTRAM

Job Type
Full Time

Salary
$8,000 - $12,000 Per Month

Date Posted
6 hours ago

Expiry Date
19-Jul-2022
Additional Details


Job ID
260012

Job Views
18

Roles & Responsibilities Responsibilities

• Participate in projects covering full data lifecycle, end-to-end, from design, implementation and testing, to documentation, delivery, support, and maintenance.
• Gather business and functional requirements and translate these requirements into robust, scalable and operable solutions that work well within the overall data architecture
• Develop processes of the ingestion of data using various programming languages, techniques and tools from systems implemented using Oracle, Teradata, SAP, Hadoop technology stack
• Evaluate and make decisions around dataset implementations designed and proposed by peer data engineers.
• Build large database models for FP&A including Balance Sheet, PnL, Cost Analytics and Related Ratios
• Use Dataiku to develop ETL, real time and batch data processes feeding into in-memory data infrastructure.
• Perform and document data analysis, data validation, and data mapping/design
• Optimize Exasol data infrastructure using partitions, sorting and virtualized views accelerate query times by reducing query planning and reading times
• Conduct unit tests and develop database queries to analyse the effects and troubleshoot any issues
• Use query job analytics to analyse BI query plans to optimise execution times irrespective of the size of the underlying data set
• Develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions
• Conduct research via focus groups, usability test or other related tools
• Create tools to store data within the organization
• Evaluate and make decisions around the use of new or existing software products and tools
• Participate in data driven user experiences design process
• Mentor junior data engineers

• 7+ years of commercial project implementation experience( Database | Data warehousing | ETL | BI | Big Data | Data Science )
• Proficiency in SQL ( DML | DDL | DCL | TCL )
• Commercial experience working on database/data warehouse projects ( Oracle | Exasol | SAP BW | Teradata)
• Commercial experience creating ETL processes using data integration tools ( Dataiku | Informatica | Oracle DI | Talend | Pentaho DI | IBM DataStage)