Data Warehouse Analyst

Psybergate

  • Centurion, Gauteng
  • R15,000-18,000 per month
  • Permanent
  • Full-time
  • 23 days ago
Job Summary 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.PsybergateRecruiter

Job Mail