Data Warehouse Analyst

Psybergate (Pty) Ltd; Gauteng; On-site; ZAR 500 000 - 700 000; Full time

Job summary

An IT services company in South Africa is looking for a Data Warehouse Analyst. In this role, you will collaborate with stakeholders to gather requirements, design data models, and develop ETL processes. The ideal candidate must possess a Bachelor's degree in a quantitative field and have 5-8 years of relevant experience. Strong skills in SQL and proficiency with BI tools like Tableau or Power BI are essential. This position requires a solid analytical background and excellent communication skills.

Qualifications

• 5-8 years of experience in Data Warehouse analysis.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.
• Proficiency in SQL and experience working with relational databases.
• Experience with cloud-based data warehousing solutions is a plus.
• Experience with scripting languages (Python, R) is a plus.

Responsibilities

• Collaborate with stakeholders to understand business needs and translate them into data requirements.
• Identify, collect, and clean data from various sources.
• Contribute to the design and maintenance of data models and data warehouses.
• Develop and maintain ETL processes to move data to the data warehouse.
• Conduct in-depth data analysis to identify trends and insights.

Skills

ETL

SQL

Power BI

Data analysis

Education

Bachelor's degree in a quantitative field

Tools

Tableau

Power BI

Looker

Job description

Data Warehouse Analyst

JoinPsybergate (Pty) Ltd as a Data Warehouse Analyst.

Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.

You will work with a financial services client based in Centurion.

What You Will Be Doing

• Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into data and reporting requirements.
• Data Collection & Preparation: Identify, collect, and clean data from various sources, 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 inform business decisions.
• Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools such as Tableau, Power BI, Looker to visualize data and communicate findings.
• 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.

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 (Tableau, Power BI, Looker).

Strong analytical and problem-solving skills.

Excellent communication and presentation skills; 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 (Snowflake, BigQuery, Redshift) is a plus.

Experience with scripting languages (Python, R) is a plus.

Knowledge of statistical methods and techniques is a plus.

Desired Skills

• ETL
• SQL
• Power BI
• Data analysis