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 Engineer with Snowflake/Matillion
Location: Cape Town
Salary: Hourly
An established enterprise organisation is investing heavily in its modern data platform and is looking for an Intermediate data Engineer to help build and optimise scalable data solutions that support analytics, reporting, and business decision-making.
1 day ago

Lead Data Scientist
Location: Cape Town
Salary: Annually
A leading organisation is seeking an experienced and innovative Lead data Scientist to drive the development and delivery of advanced analytics, machine learning solutions, and data-driven products that create measurable business value. This role offers the opportunity to lead complex data science initiatives, influence strategic decision-making, and mentor a high-performing team of data professio...
1 day ago

Data Engineer
Location: Cape Town
Salary:
Join Our data Engineering Talent Network data Science Engineers (3+ Years Experience)Are you a data professional who thrives on solving complex problems and working with large-scale datasets? We’re building a pipeline of exceptional Senior data Engineers and data Science Engineers to connect with future opportunities across leading organisations.If you’re open to exploring your ne...
1 day ago

Data Analyst
Location: Cape Town
Salary: 65000 Monthly
data Analyst: Finance - Mid CareerWe are looking for a data Analyst with 4-6 years of experience to join our Client in the Manufacturing in the Western Cape.
1 day ago

Lead Data Scientist
Location: Cape Town
Salary:
Ready to turn complex data into powerful business impact? Join a high-performing team where innovation, strategy, and advanced analytics come together to shape the future of a large-scale, fast-moving organisation.
1 day ago

Data Integration Specialist (Customer Success Focused)
Location: Cape Town
Salary: Monthly
Our client, a global leader in financial and insurance services, seeks to employ a technically minded and client-focused data Integrations Specialist to join their growing Customer Success team. Reporting to the Head of Customer Success, this role sits at the intersection of people, data and systems, acting as a key link between clients, internal technical teams and third-party companies...
1 day ago

Data Visualisation Specialist
Location: Cape Town
Salary: R85k - 120k per month
We are looking for a strong Tableau Report Developer / data Visualisation Specialist.
1 day ago

Data Product Owner
Location: Cape Town
Salary: R95k - 110k per month
Product Owner to own a retail AI-powered app from a business and customer value perspective
1 day ago

Data Analyst
Location: Stellenbosch
Salary: TBC Annually
An exciting opportunity for a data-driven professional with a strong finance background to join a leading analytics environment. If you enjoy uncovering insights from complex datasets and influencing strategic decisions, this role is for you.
4 days ago

Lead Data Scientist
Location: Cape Town
Salary:
Ready to turn complex data into powerful business impact? Join a high-performing team where innovation, strategy, and advanced analytics come together to shape the future of a large-scale, fast-moving organisation.
4 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