Duties & Responsibilities
Key Job Outputs:
Data Management
- Maintaining our data dictionary (a reference document containing all available fields together with mappings between different data tables) in conjunction with our data stewards.
- Responsible for providing the necessary insights to our data stewards so that they can improve the quality of our data.
- Ensure that the necessary data is provided in the agreed format to the reporting and analytics teams and that any changes in the production data model are managed and documented well including ensuring that our data lake is maintained.
- Agreeing with the analytics teams on the necessary data elements.
- Maintain a Data Dictionary and Business Glossary.
- This individual will be able to translate that meaning and right context to the teams providing reporting and analysis across the business with particular emphasis on Credit and Sales.
- Deep understanding of the Production system mechanics of each of our product flows.
- Understand how Salesforce is implemented.
- Database Objects, Fields, and Records Their relationships and how data is created and modified in the system.
- Provide detailed information on database changes.
- Object, field and records updates.
- Object relationships.
Stakeholder communication and change management
- Ensuring that the requirements of the data consumers are clearly understood by the technology teams.
- Ensuring that any changes to production data are clearly understood by the data consumers before they are made and that the impact of the change is managed well.
- Communicating across all departments within the company: Especially Credit and Technology Teams – Development, Operations and Delivery.
Data lake/warehousing management
- Understand how system enhancements, new features and bug fixes will impact the data warehouse.
- Implement new solutions and flows.
- Extracting and transforming data from different systems.
- Qualify and score data providing quality and accuracy reports on key data elements.
- Monitor the data warehouse ensuring all data flows are running as scheduled.
Data Quality Management
- Moving data if required for updates on the system.
- Updating records with external data.
- Providing data stewards with agreed quality metrics on the elements for which they are responsible.
- Cleaning bad data when identified or working with the data stewards to do so.
Data lake maintenance
- Agreeing with the analytics teams on the necessary data elements.
- Ensuring these elements are consistently updated from production.
Core Competencies:
- Technical
- Java-script
- ETL experience
- SQL
- Knowledge of the business analysis process
Communication
- Clear, structured written communication.
- Ability to communicate with senior and junior people across the business.
- Presents ideas in a clear and concise manner to individuals or groups.
- Maintains discretion and confidentiality in communications with others.
- Actively listens to others, gives appropriate feedback, and makes them feel comfortable.
Problem Solving Ability
- A structured approach to problem solving and delivery.
- Interpersonal Skills.
- Serves as a “resources person” on whom others rely on for advice.
- Use all the resources at your disposal to be able to answer questions and deliver on promises.
- Strong interpersonal skills with individuals and groups.
Planning and Organising
- Organizes activities to ensure proper completion in a timely manner.
- Effectively schedules time by assigning priorities to daily/weekly/monthly work activities.
- Avoids crises through systematic planning and follow through.
Service Delivery and Excellence
- Completes work appropriately to meet the needs of internal colleagues and external clients.
- Demonstrates a commitment to consistent excellence.
- Ensures that service meets quality expectations of the company and clients.
- Keeps up-to-date with field of expertise, and uses such knowledge effectively.
Self-Management
- A high degree of self-management and initiative is expected.
Desired Experience & Qualification
Qualifications:
- Post-matric technology qualification.
- 3 - 6 years Data engineering and BI experience, this must include data extraction, transformation, and loading.
Experience:
- 2 years of data dictionary development and maintenance.
Package & Remuneration
Salary: Market related.
Should you not hear from us within 2 weeks, kindly consider your application as unsuccessful.
All personal information received will be processed in accordance with The Protection of Personal Information Act No. 4 OF 2013.
#J-18808-Ljbffr