About the position
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.
Desired Skills:
- ETL
- SQL
- Power BI
- data analysis
