Data Modeller

Three Across; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

A leading data solutions company is seeking a Data Modeler / Data Analyst in Singapore. The ideal candidate should possess extensive experience in data modeling, cloud platforms, and ETL processes. You will be designing and maintaining scalable data models while collaborating with various teams to optimize data solutions. If you have a passion for data architecture and a strong SQL background, this role is for you.

Qualifications

• 11-16 years of experience as a Data Analyst and Data Modeler in IT.
• Proficiency in data modeling tools like Erwin.
• Strong knowledge of RDBMS and data warehousing concepts.

Responsibilities

• Design and implement enterprise data architecture.
• Lead data modeling and ETL specifications.
• Collaborate with stakeholders for data optimization.

Skills

Data Modeling

SQL

ETL processes

Data Analysis

Cloud platforms (AWS, Azure, GCP)

Data Warehousing

Tools

Erwin

Snowflake

Teradata

Oracle

Job description

Job Title: Data Modeler / Data Analyst

Location: PAN India

Experience: 11-16 Years

Notice Period: Max 30 Days

Employment Type: Full-Time

Industry: IT Services / Data Engineering / Analytics

Job Overview

We are seeking an experienced and detail-oriented Data Modeler / Data Analyst to join our data architecture team. This role involves designing and maintaining data models that underpin enterprise-wide data solutions. The ideal candidate will have expertise in data modeling principles, ETL processes, cloud platforms, and data warehousing technologies.

Key Responsibilities

1. Gather and analyze business requirements to design data solutions.
2. Lead the design, development, and implementation of enterprise data architecture for structured and unstructured data.
3. Build data models using tools like Erwin.
4. Ensure seamless data flow across teams, including API delivery.
5. Perform data analysis, profiling, cleansing, migration, validation, auditing, and manipulation.
6. Design ETL workflows and specifications, collaborating with ETL teams.
7. Develop and manage database objects such as tables, stored procedures, and triggers.
8. Utilize cloud platforms (AWS, Azure, GCP) for data integration and modeling.
9. Implement best practices for naming, metadata, and design standards.
10. Ensure data consistency, reusability, and compliance with governance frameworks.
11. Evaluate and enhance existing data systems.
12. Collaborate with stakeholders to optimize data warehouse and big data platforms.
13. Maintain data dictionaries and model documentation.

Minimum Qualifications

• Experience as a Data Analyst and Data Modeler in IT.
• Proficiency in data modeling tools like Erwin.
• Knowledge of RDBMS such as Teradata and Oracle, and concepts like OLTP, OLAP, Star, Snowflake schemas.
• Hands-on experience with Snowflake.
• Strong SQL skills and data warehousing knowledge.
• Experience with ETL processes and large data volumes.

Preferred Qualifications

• Experience with Teradata utilities (Mload, Tpump, Fastload, FastExport).
• Knowledge of cloud services (Azure, AWS, GCP) and related certifications.
• Understanding of data governance and metadata management.
• Ability to troubleshoot SQL performance issues.
• Experience with metadata repositories and data dictionaries.
• Strong communication skills for stakeholder engagement.

If you are passionate about data architecture and cloud platforms, and eager to build scalable data models, apply now to join our team transforming enterprise data strategy.