Senior Data Warehouse Developer

Psybergate · Centurion, Gauteng

Stop applying one at a time.

JobAlertsZA auto-applies to South African jobs like this one for you, overnight. Upload your CV once — we do the applying.

Start free — we apply for you →

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.

Auto-apply to this jobView original posting ↗