Data Modeler
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Dautom is seeking a Data Modeler for a client, Artefact, to design enterprise data models and map source systems into canonical models on an Informatica stack. The role involves implementing data quality measures, developing ETL pipelines, and working with cloud platforms.
Key Skills for This Role
Responsibilities
- Design the enterprise data model and map multiple source systems into a canonical model (UDM/GIM) on an Informatica stack.
- Implement data quality measures including source profiling, transformation rules, and handling granularity mismatches and derived/composite fields.
- Develop and optimize ETL/data pipelines for seamless data movement across systems.
- Design and manage databases, ensuring data integrity and performance.
- Implement data modeling and data architecture best practices.
- Work with cloud platforms to build and deploy scalable data solutions.
- Collaborate with cross functional teams to support data driven initiatives.
- Utilize Spark and Kafka for data processing and analytics.
- Ensure efficient storage, retrieval, and transformation of large scale datasets.
Requirements
- Strong SQL skills
- Strong Data Engineering foundation including medallion architecture and SCDs
- Experience with any cloud platform (Azure, GCP, or AWS)
- Strong understanding of logical and physical data modelling
- Good knowledge of industry modelling like Party/Event/Location/Classification/Resource Item supertypes
- Experience with data modelling tools (Erwin, ER/Studio, PowerDesigner, or SQL Developer Data Modeler)
- Experience with ETL and data pipeline development
- Hands on experience with cloud platforms
- Database management experience
- Experience in canonical/industry reference model (e.g., IBM IIW style supertypes)
- Experience mapping many disparate sources into one enterprise model
- Strong problem solving and analytical skills
Full Job Posting
Who We Are
- Artefact is a new generation of data service providers specializing in data consulting and data driven digital marketing.
- We help organizations transform data into business impact across the entire value chain.
- Our Data Consulting team consists of 400+ consultants working across data marketing, data governance, strategy consulting, product ownership, and more.
What You Will Be Doing
- Design the enterprise data model and map multiple source systems into a canonical model (UDM/GIM) on an Informatica stack.
- Implement data quality measures Source profiling, transformation rules, and handling granularity mismatches and derived/composite fields.
- Develop and optimize ETL/data pipelines for seamless data movement across systems.
- Design and manage databases, ensuring data integrity and performance.
- Implement data modeling and data architecture best practices.
- Work with cloud platforms to build and deploy scalable data solutions.
- Collaborate with cross functional teams to support data driven initiatives.
- Utilize Spark and Kafka for data processing and analytics.
- Ensure efficient storage, retrieval, and transformation of large scale datasets.
Key Requirements
- Strong SQL skills
- Strong Data Engineering (DE) foundation including medallion architecture, SCDs
- Experience with any cloud platform (Azure, GCP, or AWS)
- Strong understanding of logical and physical data modelling (not just star schema)
- Good knowledge of industry modelling like Party / Event / Location / Classification / Resource Item supertypes.
Technical Skills
- Experience with data modelling tools Erwin, ER/Studio, PowerDesigner, or SQL Developer Data Modeler
- Experience with ETL and data pipeline development
- Hands on experience with cloud platforms
- Database management experience
- Good to have: Experience in canonical/industry reference model for e.g. IBM IIW style supertypes; experience mapping many disparate sources into one enterprise model.
Soft Skills
- Strong problem solving and analytical skills
- Excellent communication and stakeholder management skills
- Ability to work in a fast paced, dynamic environment
- Collaborative and solution oriented mindset
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Dautom
Data Engineer
Abu Dhabi Emirate, UAE
Dautom is seeking a Data Engineer for a 3-month contract in Abu Dhabi. The role requires strong SQL skills, data engineering foundation including medallion architecture and SCDs, and experience with cloud platforms. Idea
Senior Software Asset Management (SAM)
Sharjah Emirate, UAE
Dautom seeks a Senior Software Asset Manager for a contract role with a global client. You will lead SAM, licensing, and FinOps initiatives, requiring deep vendor licensing expertise and ServiceNow SAM Pro certification.
Lead Generation Executive
Dubai, UAE
Dautom is hiring a Lead Generation Executive in Dubai to identify and generate qualified B2B leads, primarily targeting the Saudi Arabian market. The role involves outbound prospecting, CRM management, and collaborating
Full Stack Engineer
Dubai, UAE
Dautom is hiring a Full Stack Developer for a 3-month extendable contract in Dubai. The role involves developing scalable web applications, building RESTful APIs, optimizing MS SQL databases, and integrating AI/LLM capab
Senior Java Software Engineer
Sharjah, UAE
Dautom is hiring a Senior Java Software Engineer for a contract role with the Sharjah Digital Department. The position involves designing, developing, and maintaining Java-based applications using Spring Boot and Oracle.
Relationship Manager – Financial Institutions
Dubai, UAE
Dautom seeks a Relationship Manager to build and maintain relationships with correspondent banks, manage nostro/vostro accounts, and support KYC processes. Ideal candidates have 2-3 years of experience in financial insti
Dotnet Developer
Dubai, UAE
Dautom is looking for an experienced Dotnet Developer with 6+ years of experience to analyze requirements, design databases, develop applications and Web APIs independently. Requires strong skills in C#, ASP.NET, SQL Ser
Data Modeler
Abu Dhabi, UAE
Dautom is hiring a Data Modeler for a contract role in Abu Dhabi. You will design enterprise data models, build ETL pipelines, and implement data quality measures using the Informatica stack and cloud technologies.
Data Engineer
Abu Dhabi Emirate, UAE
Senior Software Asset Management (SAM)
Sharjah Emirate, UAE
Lead Generation Executive
Dubai, UAE
Full Stack Engineer
Dubai, UAE
Senior Java Software Engineer
Sharjah, UAE
Relationship Manager – Financial Institutions
Dubai, UAE
Dotnet Developer
Dubai, UAE
Data Modeler
Abu Dhabi, UAE