Data Analyst - Johannesburg, South Africa - PBT Group
Description
PBT Group has a vacancy for a BI Data Analyst with at least 3 years relevant experience within the banking industry, to support and maintain the data warehouse in line with the data model; metadata repository and to provide business intelligence analysis through performing strategic and operational support.
Duties:
- Structure data into compliance standards by adhering to metadata governance procedures according to documented standards and formats.
- Assist/govern population of datamart and metadata repository by complying to standards, systems, processes and procedures.
- Support business units by providing consulting services that delivers data and information relevant to their business
- Contribute to internal and external information sharing sessions by attending formal and informal meetings.
- Manage vendor relationship interactions by conforming to vendor management office guidelines and principles.
- Deliver work according to customer expectations by prioritizing; planning and implementing requirements.
- Utilize resources by adhering to standards, policies and procedures.
- Align and continuously improve set processes by identifying innovation opportunities.
- Identify and mitigate risk by executing within governance.
- Resolve incidents by logging and tracking through correct channels
- Keep abreast of legislation and other industry changes that impacts on role by reading the relevant newsletters, websites and attending sessions.
- Improve personal capability and stay abreast of developments in field of expertise by identifying training courses and career progression for self through input and feedback from managers
- Ensure personal growth and enable effectiveness in performance of roles and responsibilities by ensuring all learning activities are completed; experience practiced, and certifications obtained and/or maintained within specified time frames.
- Ensure information is provided correctly to stakeholders by maintaining knowledge sharing knowledge with team.
- Analyse business requirements from documents and enduser discussions.
- Identify and define the security requirements necessary to protect the data items.
- Identify and define the business rules associated with the data; these should include all data integrity / constraint requirements.
- Perform data profiling of data contained in source systems.
- Provide detailed analysis of all data implemented into the database.
- Provide the data mapping and associated transformation rules for each data item.
- Ensure that the business requirements and subsequent development activities are supported by accurate information.
- Assist Data Modelers to draw up detailed data models.
- Assist Data Engineers to draw up data cleansing specifications.
- Present data quality anomalies and problem areas to business users and source system owners.
- Validate data models against the business
- Ensure the quality, accuracy, integrity and conformity to standards of all models.
- Provide accurate metadata, which allows full understanding of the project data components.
- Coordinate and synchronise data models with process and technical models.
- Identify data and data model inconsistencies and conflicts and assist the users in their resolution.
- Transition information and assist the DBA's with physical implementation of the data models.
- Transition information and assist develops with the data mapping and transformation and provide additional data analysis as required during the development phase.
- Communicate project datarelated information to Architects, DBA's, Developers and Users.
- Work with modeling tools and data repository to maintain project deliverables.
Required Skills:
- Meticulous attention to detail.
- Knowledge of data profiling and data profiling tools.
- Experience with data quality management strategies and life cycles.
- 8 years relevant experience of which 35 years' experience in: Banking, Business Intelligence, Finance, Data Warehousing, Data principles, Analytics, Data Management, EDP, RADARR, SQL ETL & Development, Finance Reporting, Regulatory Knowledge, MIS, Dashboarding & Data Quality
Required Qualifications / Training:
- Data Management (DAMA) Certification, Certification/formal training in relevant technology
More jobs from PBT Group
-
Scrum Master
Cape Town, South Africa - 3 weeks ago
-
Data Analyst
Johannesburg, South Africa - 3 weeks ago
-
Java Developer
Cape Town, South Africa - 3 weeks ago
-
Business Intelligence Graduate Program 2025
Johannesburg, South Africa - 1 week ago
-
Front-end Architect
Cape Town, South Africa - 3 weeks ago
-
Data Analyst
Johannesburg, South Africa - 3 weeks ago