Data Modeler

Recruiter:

PBT Group

Job Ref:

357815238

Date posted:

Thursday, June 2, 2022

Location:

Cape Town, South Africa

SUMMARY:
-

JOB DESCRIPTION:

Data Modeler required for a vacancy at PBT Group.

Duties:

Create and implement comprehensive logical and physical data models.
Perform detailed data analysis in order to develop the data warehouse’s / BI solution’s data model.
Involved in the requirements definition process.
Assist the ETL Analysts / Business Analysts with the specification of the source to target mappings.
Participate in the business requirements definition activities in a secondary role, for which a good understanding of business rules is essential.
Work closely with Business Analysts, ETL Analysts, Solution Architects and Database Administrators to perform all tasks.
Review models designed by other DBA’s and relate the activities of other modeling efforts to the model under review.

Required Skills:

Knowledge about existing corporate data models, as well as knowledge of the business, is extremely important.
Strong conventional (normalised) data modeling skills are beneficial, as the Data Modeler often has to be able to read and understand existing data models. However, the Data Modeler should be able to break away from traditional OLTP and E/R design practices and embrace the new data warehouse design techniques such as Dimensional models or multi-dimensional models.
Experience working on other data warehousing projects is essential (full life cycle).
Understanding of data warehousing and data mart architectures.
An exposure to end-user reporting tools and their capabilities is useful.
Have a quick grasp and understanding of data models, be able to see things abstractly, for example to derive the common model and represent related business concepts generically.
Be very meticulous, as the data warehouse data model should be exact and complete – attention to detail is a very important characteristic.
Well versed in conceptual and logical data modeling.
Understand advanced analytical data requirements.
Understand the data requirements of front-end (reporting, dashboarding and analysis tools.)

Required Qualifications / Training:

Data warehouse design methodology training.
Normalised and dimensional data modeling training.
Must have worked with industry standard data modeling tools.
Strong experience working with a range of DBMS’s.
Strong experience with SQL query and DBMS tuning.
B.Sc. or related degree is advantageous.

NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

Data Analyst / Data Scientist - Cape Town or Durban
Location: Capetown
Salary: Market related
Calling all data Analysts/ data Scientists in Cape Town or Durban
Today

Data Scientist
Location: Stellenbosch
Salary: 1 000 000
LADIES AND GENTLEMEN OF THE data JURY,My client presents before you a critical case — one that demands precision, foresight, and a mind trained in the intricate art of risk analysis. A position of trust. Of consequence. And only the most experienced candidate — with prior convictions in the Fintech industry — will be considered.This isn’t a trial for just anyone. The eviden...
3 days ago

Data Engineer
Location: Stellenbosch
Salary: 1 000 000 Annually
Ladies and gentlemen, data wranglers and pipeline virtuosos...The spotlight is on YOU!My client the hottest number in the industry, is searching for a headliner — a Senior data Engineer — to take center stage in their next big production. This isn't just any role — this is your chance to architect the data magic that powers every scorecard and every credit model that hits the sta...
3 days ago

Vice President - Healthcare Operations Management (Clinical Data Abstraction)
Location: Cape Town
Salary: Hourly
An established and innovative global services company is seeking a senior leader to drive excellence in healthcare operations within a fast-paced, data-driven environment. The role focuses on ensuring seamless service delivery, optimising operational efficiency, and managing high-performing teams to deliver exceptional results in clinical data abstraction and healthcare process management. The suc...
4 days ago

Data Coordinator
Location: Century City
Salary: R15 000
We are looking for a detail-oriented data Co-Ordinator to join a fast-growing B2B services company. The ideal candidate will be responsible for managing and optimising CRM data, supporting sales campaigns with accurate contact information, and driving data-led strategies. They will work closely with the sales team to build targeted audiences and ensure the CRM system runs at peak accuracy.This is ...
4 days ago

Data Engineer (Python)
Location: Cape Town
Salary:
4 days ago

Junior Data Scientist
Location: Cape Town
Salary:
Are you ready to kick-start your career in data science and make an impact in the world of sustainable credit and capital solutions? Do you thrive in fast-paced environments where innovation, learning, and collaboration drive real business outcomes?
6 days ago

Junior Data Scientist â Machine Learning & AI
Location: Cape Town
Salary:
Calling all data-driven problem solvers ready to make their mark in the world of sustainable credit and capital solutions! A leading financial solutions company is on the hunt for a young, passionate, and driven data Scientist to join their high-performance analytics team. If you love working with big data, have a knack for machine learning, and thrive in fast-paced environments, then this could b...
6 days ago

Data Scientist
Location: Stellenbosch
Salary:
FIND YOUR INNER DRAGON WARRIOR: data SCIENCE MASTERS WANTED!Are you a data Science expert who believes the secret ingredient is... no secret ingredient?Journey to the Valley of Peace where data is the flow of the universe, patterns hold ancient wisdom, and predictive power is the ultimate dragon scroll! Our clients are seeking data Science Masters to achieve enlightenment throu...
10 days ago

AI Data Scientist
Location: Cape Town
Salary:
GET OUT OF MY LAB: AI & ML OGRES WANTED!Are you an AI & Machine Learning expert with more layers than an onion?Welcome to the swamp where data dragons need taming, neural networks are magic spells, and fairy tale problems meet brutally effective solutions! Our clients are on the hunt for AI Ogres to build intelligent kingdoms, slay algorithmic beasts, and make magical system...
10 days ago

Data Modeler

Similar jobs you might be interested in:

Create a free job alert for Data Modeler in Cape Town

Jobseekers

Recruiter

General