Data Modeler

HR Tech; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

A Data Solutions Company based in Singapore is seeking a Data Integration Specialist to design and implement data models that support business strategies. Candidates should have over 8 years of experience in data integration and database management, with proficiency in tools like Power BI and cloud services such as Azure Data Factory and AWS Glue. This is a vital role to ensure the business's data architecture aligns with its goals.

Qualifications

• 8+ years of hands-on experience with relational, dimensional, and analytic databases.
• Experience with data pipeline implementation using cloud services.
• Strong knowledge of data integration design and development.

Responsibilities

• Translate business needs into data models.
• Implement data strategies and build data flows.
• Optimize logical/physical data models.

Skills

Relational database management

Data integration

Business Intelligence

Data modeling

ETL protocols

Education

Bachelor's or master's in computer/data science

Tools

Power BI

Azure Data Factory

AWS Glue

T-SQL

SSIS

Job description

Overview

The Data Integration specialist is a subject matter expert of data integration solutions and data architecture.

You will be responsible for the technical development of any new data integration solution to be plugged in to the overall enterprise data architecture.

You will be supporting the Data Engineer to organise data at the macro and micro levels, creating data models that enable the implementation of the intended business architecture, key data entity diagrams, and a data inventory to implement the architecture vision.

Responsibilities

• Understand and translate business needs into data models supporting long-term solutions
• Work with teams to implement data strategies, build data flows and develop conceptual data models
• Optimize and update logical/physical data models to support new/existing projects
• Maintain conceptual, logical and physical data models along with corresponding metadata
• Recommend opportunities for reuse of data models in new environments
• Perform reverse engineering of physical data models from databases and SQL scripts
• Evaluate data models and physical databases for variances and discrepancies

Requirements

• Min. 8+ years of experience hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols)
• Expertise in modeled data for investment and fund management domains
• Bachelors or masters degree in computer/data science technical or related experience
• Experience with end-to-end data pipeline implementation with cloud services such as Azure Data Factory/AWS Glue
• Data manipulation, data integration design and development including T-SQL, SSIS and APIs
• Datawarehouse tech: experience developing OLAP cubes and/or in memory data models.
• Business Intelligence technology (e.g., Power BI).
• Good understanding of data lifecycle and architecture best practices.
• Systems integration experience with SAP systems is a bonus.