Data Engineer

FLINTEX CONSULTING PTE. LTD.; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

A leading consulting firm in Singapore is seeking a Data Engineer specialized in database modeling and ETL processes. The role involves working with Oracle Analytics Cloud to manage data security and collaborate with business counterparts on reporting requirements. This opportunity will challenge your analytical skills and provide a platform for impactful projects in a dynamic work environment.

Qualifications

• Experience in Oracle environment with GCP stack preferred.
• Hands-on experience building database models (star schema).
• Good communication and interpersonal skills.

Responsibilities

• Design and build DWH database models.
• Manage semantic models for unified data views.
• Ensure data quality and compliance.

Skills

Database modelling

Proficiency in SQL

Data warehousing

ETL processes

Analytical thinking

Customer-oriented

Tools

Oracle Analytics Cloud

Tableau

Looker

Job description

Responsibility

• The holder of the position is mainly responsible for the following areas in coordination with his / her superior:
• Design and build the DWH database models (star schema).
• Manage the semantic model in Oracle Analytics Cloud to provide a unified view of our organization's data.
• Manage application roles and access rights for end users including row level security filters, to protect sensitive data.
• Work with ETL specialists, IT business Consulting as well as external vendors to ensure data ingestion and integration into the database model
• Collaborate with Business Controlling and business counterparts on new reporting requirements.
• Ensure data quality, security and compliance with industry standards and internal guidelines.
• Ensure proper documentation of data infrastructure, data models, workflows as well as security concepts in accordance with internal security policies.

Skills

• Looking for a Data Engineer more focused on Database modelling, Currently in Oracle environment and going forward with GCP stack.
• Proficiency in SQL and data warehousing
• Strong understanding of data modelling techniques and hands on experience building database models (star schema).
• Expertise with ETL (extract, transform, load) processes. Familiarity with BI tool integration such as Tableau or Looker
• Strong analytical thinking, problem-solving capability, and ability to translate business needs into technical specifications.
• Customer-oriented with good communication and interpersonal skills.