gather and document detailed requirements for data warehouse projects
Reference: BIT002844-MNa-1 A financing house in the heart of the Western Cape Northern Suburbs is looking for a business analyst with around 5 years experience who has proven experience in data warehousing projects and a strong understanding of data modelling concepts and techniques Qualifications:
warehousing, your role will be crucial in supporting warehouse operations and decision-making.
:
The candidate is responsible from Warehouse design to ETL (Extract Transform Load) development till MIS various sources. Transform and load data into data warehouses or data marts for BI purposes. Create interactive handling heterogeneous data sources. Experience with Warehouse modeling, analytics and ETL (Extract, Transform
from various sources into a centralized data warehouse or data lake. Implement data models, schemas, data systems, including database servers, data warehouses, and data processing frameworks. Troubleshoot
Functional design of data-related solutions (Data Warehouse, Reports, Tabular Models, etc.) Pro-actively generate
load data from various sources into the data warehouse or data lake. Design and develop data models and as Azure Synapse Analytics (formerly SQL Data Warehouse). Experience with Azure data services such as
built on the premise of growth as the future data warehouse. Work closely with Business Intelligence, Data cross-functional and Leadership teams to develop a warehouse using data modeling best practices. Managing Integrations expert and drive evolution of Snowflake based Data Warehouse Solutions and workloads. Work across multiple expert and drive evolution of Snowflake based Data Warehouse Solutions and workloads. Work across multiple
development experience
develop and maintain ETL process using SSIS. Data warehouse design, maintenance and re-architecture as required