Data Warehouse Analyst

1 week ago

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 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.

  • Data Warehouse Engineer

    4 days ago

    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...

  • Data Warehouse Manager

    4 days ago

    Centurion, Gauteng, South Africa ABC Worldwide Full time R120 000 - R180 000 per year

    Role PurposeData Warehouse Manager manages the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and projects. Oversees data design and the creation of database architecture and data repositories. The Data Warehouse Manager must also establish and lead a world class data...

  • Senior Data Warehouse Developer

    2 days ago

    Centurion, Gauteng, South Africa Psybergate Full time R400 000 - R700 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 Senior Data Warehouse Developer to join our financial services client based in Centurion. What you will be doing:Design, develop, and implement scalable data warehouse solutions.Develop, maintain, and optimize ETL/ELT...

  • Data Warehouse Manager

    4 days ago

    Centurion, Gauteng, South Africa ABC Worldwide Full time R60 000 - R120 000 per year

    Data Warehouse Manager Job DescriptionJob Responsibilities:Design and implement data warehouse solutionsManage and oversee all data warehouse activitiesEnsure data quality and accuracy within the data warehouseDevelop and implement data security and compliance measuresCollaborate with stakeholders to understand data requirementsCreate and maintain...

  • Data Analyst

    1 week ago

    Centurion, Gauteng, South Africa Zealhr Full time R200 000 - R240 000 per year

    Job Description Data AnalystLocation: CenturionCompany overview:Our client is an intelligent solutions company with strong, industry-specific expertise and core capabilities in data management, GIS, analytics and software development. They specialise in delivering integrated, online knowledge solutions, batch and real-time data quality solutions, and a broad...

  • Data Analyst

    4 days ago

    Centurion, Gauteng, South Africa Hire Resolve Full time R600 000 - R1 200 000 per year

    Hire Resolves client is seeking a Data Analyst who will be delivering comprehensive data analysis solutions through regular and ad-hoc projects. The Data Analyst will implement and maintain data sourcing and transformation processes using SQL, collaborate with clients and stakeholders to define requirements, and perform data extraction and manipulation. Key...

  • Warehouse Manager

    1 week ago

    Centurion, Gauteng, South Africa Nile Fresh (Pty) Ltd Full time R40 000 - R120 000 per year

    As the Warehouse Manager at Nile Fresh (Pty) Ltd, you will be responsible for overseeing the daily operations of the warehouse, ensuring that all processes are executed smoothly and efficiently. Your role will be critical in managing inventory, coordinating shipping and receiving, and leading a team to maintain high standards of storage and distribution.Key...

  • Senior Data Analyst

    4 days ago

    Centurion, Gauteng, South Africa Metamorphosis Integrated Solutions Full time R250 000 - R500 000 per year

    Location: CenturionA Senior Data Analyst to join our data analyst team to deliver data driven products and insights to internal and external stakeholders through the professional implementation of designing, developing, testing, and presenting data products, models, and insights. To work closely with the data engineering team and business development, while...

  • Data Engineer

    1 week ago

    Centurion, Gauteng, South Africa MOMENTUM LIFE Full time

    IntroductionThrough our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations.We help people grow their savings, protect what...

  • Senior Data Business Analyst

    2 weeks ago

    Centurion, Gauteng, South Africa Momentum Investments Full time R600 000 - R1 200 000 per year

    IntroductionThrough our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations. We help people grow their savings, protect...