Data Warehouse Analyst

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

POSITION INFO:
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.

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