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:

Power BI and Data Insights Specialist
Location: Woodstock
Salary: R80k - 95k per month
Design clear, usable Power BI dashboards and turn business data into insights that support decisions
2 days ago

Data Engineer
Location: Cape Town
Salary:
We’re Hiring | data Engineer
5 days ago

Data Analyst
Location: Cape Town
Salary:
Love finding the story behind the numbers? We're growing our data Analyst talent pool and looking for analytical thinkers who can transform data into actionable business insights. If you're passionate about solving problems, identifying trends, and helping businesses make smarter decisions, we want to hear from you.
5 days ago

Data Coordinator (Degreed) Hybrid
Location: Stellenbosch
Salary:
An exciting opportunity exists for a technically skilled and detail-oriented data Coordinator to join the Monitoring, Evaluation and Learning (MEL) Department. Reporting to the MEL Manager, the successful candidate will be responsible for managing, maintaining and optimising data systems, impact-tracking tools and reporting dashboards.The role involves ensuring the accurate and timely collection, ...
7 days ago

Data Professional
Location: Cape Town
Salary: Monthly
Knysna, Thesen Island | Office-Based Are you passionate about turning data into meaningful business insights? An established analytics and market intelligence business is looking for a driven data Professional to join its team in the beautiful setting of Thesen Island, Knysna. This is an excellent opportunity for a recent graduate or early-career professional who enjoys working with data...
8 days ago

Senior Data Scientist | Cape Town
Location: Cape Town
Salary: Monthly
We are seeking a highly experienced Senior data Scientist to join a dynamic team based in Cape Town. The ideal candidate will have a strong background in advanced analytics, machine learning, cloud-based data platforms, and business intelligence, with a proven track record of delivering data-driven solutions that create measurable business value.
9 days ago

Data Capturer
Location: Cape Town
Salary: 73.99 per hour
We are seeking a Jarrison Time data Capturer for a 3-month contract in Bellville South. The successful candidate will assist with Jarrison Time administration and capture personnel’s historical working hours.
10 days ago

Finance Data Architect
Location: Northern Suburbs
Salary:
Hybrid Opportunity in Cape TownLeading Insurance Company requires a Finance data Architect to join their team on a contract basis.
11 days ago

Data Professional
Location: Cape Town
Salary: Monthly
Knysna, Thesen Island | Office-Based | Open to Graduates Are you passionate about turning data into meaningful business insights? An established analytics and market intelligence business is looking for a driven data Professional to join its team in the beautiful setting of Thesen Island, Knysna. This is an excellent opportunity for a recent graduate or early-career professional who enjo...
15 days ago

Data Engineer
Location: Cape Town
Salary: R55k - 70k per month
We are seeking a data Engineer to join our team based in Cape Town, this is a contracting role and o
15 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