About the position
My client based in Cape Town (Northern Suburbs) is currently looking for a Data Analyst to join them on a fixed term contract
IT / Finance
Responsibilities
- Data Source Inventory and Mapping
- Identify and document data sources, producing a catalogue of all data sources, including databases, to make a complete data requirement set for data ingestion and modelling
- Create data maps with visual representations of data flows and relationships between different data sources
- Maintain a data inventory to reflect changes in data sources and structures
- Data Gap Analysis
- Assess data availability by evaluating existing data sources to determine if they meet the business and reporting needs
- Identify data gaps by highlighting areas where data is missing or insufficient
- Recommend solutions or methods to fill data gaps, such as data collection initiatives or integrating new data sources
- Compile findings into a comprehensive report for stakeholders
- Data Model Diagrams
- Design Data Models - logical and physical data models to represent data structures and relationships
- Use modelling tools like ERD (Entity-Relationship Diagrams) to visualise data models
- Collaborate with business, database administrators, and developers to ensure data models align with business requirements
- Maintain detailed documentation of data models for reference and future use
- ETL Design Document
- Design Extract, Transform, Load (ETL) processes to move data from source systems to data warehouses
- Define transformation rules that specify how data should be cleaned, transformed, and loaded
- Create and maintain ETL documentation, including data mappings, transformation rules, and load schedules
- Define checks, validations, and reconciliations to ensure data integrity throughout the ETL process
Experience
- Finance Reporting
- Given applicability to finance transformation, the analyst should be well-versed in financial reporting.
- This includes understanding management reporting, planning and forecasting, investor relations, and statutory and regulatory reporting
- Financial Services Industry Knowledge
- Experience within the financial services sector is crucial, specifically insurance, investments, and lending
- The analyst needs to understand industry-specific terminology, regulations, and practices
If you are ready for the next exciting step in your career, and would like to apply, please send us your updated CV to review
Desired Skills:
- Financial Reporting
- Data Analysis
- Data analysis
- Design
- Data Cleansing
- Data Quality
- Business Analytics
