Data Warehouse Analyst

2 weeks ago


Centurion, South Africa Psybergate (Pty) LTD Full time

What you will be doing: Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements. Data Collection & Preparation: Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity.Data Modeling & Warehousing: Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.ETL Processes: Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.Data Analysis & Interpretation: Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively.Performance Monitoring: Monitor the performance of BI solutions and identify areas for improvement.Documentation: Create and maintain documentation for data sources, ETL processes, reports, and dashboards.Collaboration & Communication: Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.Continuous Learning: Stay up-to-date with the latest BI trends, tools, and techniques.Mentorship: Mentor junior analysts and provide guidance on best practices.What we are looking for:Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.5 - 8 years of experience in Data Warehouse analysis.5 years experience in data modelling in a Data Warehouse.Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.Proficiency in SQL and experience working with relational databases.Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker).Strong analytical and problem-solving skills.Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences. Ability to work independently and as part of a team. Experience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus.Experience with scripting languages (e.g., Python, R) is a plus.Knowledge of statistical methods and techniques is a plus.Please note that if you do not hear from us within 3 weeks, consider your application unsuccessful.



  • Centurion, Gauteng, South Africa Psybergate Full time R1 000 000 - R2 500 000 per year

    Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.We are looking for a Data Warehouse Analyst to join our financial services client based in Centurion. What you will be doing: Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into...


  • Centurion, South Africa Psybergate (Pty) LTD Full time

    SUMMARY : Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to itsclients. We are looking for a Data Warehouse Analyst to join our financial services client based in Centurion. POSITION INFO : What you will be doing : Requirements Gathering : Collaborate with stakeholders to understand business needs and...


  • Centurion, South Africa Psybergate (Pty) LTD Full time

    What you will be doing: Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements. Data Collection & Preparation: Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity. Data Modeling &...


  • Centurion, South Africa Hire Resolve Full time

    Overview Job Title : Data Warehouse Engineer Hire Resolves client is seeking a highly skilled and experienced Data Warehouse Engineer to join their team in Centurion, Gauteng. The ideal candidate will be responsible for designing, developing, and maintaining their data warehousing systems to ensure efficient data storage, retrieval, and analysis for business...


  • Centurion, Gauteng, South Africa Hire Resolve Full time R1 200 000 - R2 400 000 per year

    Job Title: Data Warehouse EngineerHire Resolves client is seeking a highly skilled and experienced Data Warehouse Engineer to join their team in Centurion, Gauteng. The ideal candidate will be responsible for designing, developing, and maintaining their data warehousing systems to ensure efficient data storage, retrieval, and analysis for business...


  • Centurion, South Africa PBT Group Full time

    PBT Group is seeking an experienced Senior Data Warehouse Developer to join our team. This role plays a key part in designing, developing, and maintaining enterprise-level data warehouse solutions — ensuring data integrity, accessibility, and performance across large-scale financial systems.The ideal candidate will have a strong technical foundation in...


  • Centurion, South Africa Psybergate (Pty) LTD Full time

    What you will be doing:Design, develop, and implement scalable data warehouse solutions.Develop, maintain, and optimize ETL/ELT processes for efficient data extraction, transformation, and loading.Build and enhance Power BI solutions from high-level technical and business requirements.Perform quality assurance checks and ensure data accuracy and...


  • Centurion, South Africa PBT Group Full time

    PBT Group is seeking an experienced Senior Data Warehouse Developer to join our team. This role plays a key part in designing, developing, and maintaining enterprise-level data warehouse solutions — ensuring data integrity, accessibility, and performance across large-scale financial systems. The ideal candidate will have a strong technical foundation in...


  • Centurion, South Africa Psybergate (Pty) LTD Full time

    What you will be doing: Design, develop, and implement scalable data warehouse solutions. Develop, maintain, and optimize ETL/ELT processes for efficient data extraction, transformation, and loading. Build and enhance Power BI solutions from high-level technical and business requirements. Perform quality assurance checks and ensure data accuracy and...


  • Centurion, South Africa PBT Group Full time

    Overview PBT Group is seeking an experienced Senior Data Warehouse Developer to join our team. This role plays a key part in designing, developing, and maintaining enterprise-level data warehouse solutions — ensuring data integrity, accessibility, and performance across large-scale financial systems. The ideal candidate will have a strong technical...