Data Warehouse/ ETL Consultant
⚲ Pendang
Do uzgodnienia
Wymagania
- Security
- QlikView
- ETL
- SQL Server Integration Services (SSIS)
- Data Warehouse (DW)
- DataStage (ETL)
- Business Intelligence (BI)
- Data modeling
- Data security
- SQL
Opis stanowiska
We are seeking a full-time Data Warehouse resource to join our team in Penang.
The ideal candidate will have robust experience in data modeling, ETL development, data governance, and performance tuning, with a strong understanding of business intelligence tools and methodologies.
Profile Overview:
• Data Modeling and Design (30%): Designing and creating data models that facilitate efficient querying and reporting.
• ETL (Extract, Transform, Load) Development (25%): Building and maintaining ETL processes to extract data from various sources, transform it, and load it into the data warehouse.
• Report and Dashboard Development (20%): Creating interactive dashboards, reports, and visualizations for business users.
• Performance Tuning and Optimization (15%): Ensuring BI systems perform efficiently.
• Data Governance and Security (10%): Implementing data governance policies and ensuring data security.
Key Requirements:
• Technical Proficiency in data modeling, ETL processes, BI tools, and database management systems.
• Proficient in writing complex SQL queries using MS SQL/Postgres SQL (Table, View, Functions, Stored procedure).
• Experience with data visualization tools like Power BI, Tableau, or QlikView.
• ETL Development experience in Azure Data Factory, MS SSIS, MS SQL Agents, and MS Database.
• Understanding of data warehousing concepts and architecture, specifically Ralph Kimball methodologies.
• Skills in performance optimization and query fine-tuning.
Other Details:
This is a full-time position based in Penang, Malaysia. The candidate should be adaptable and committed to continuous learning within the evolving BI landscape, working collaboratively with cross-functional teams.
The ideal candidate will have robust experience in data modeling, ETL development, data governance, and performance tuning, with a strong understanding of business intelligence tools and methodologies.
Profile Overview:
• Data Modeling and Design (30%): Designing and creating data models that facilitate efficient querying and reporting.
• ETL (Extract, Transform, Load) Development (25%): Building and maintaining ETL processes to extract data from various sources, transform it, and load it into the data warehouse.
• Report and Dashboard Development (20%): Creating interactive dashboards, reports, and visualizations for business users.
• Performance Tuning and Optimization (15%): Ensuring BI systems perform efficiently.
• Data Governance and Security (10%): Implementing data governance policies and ensuring data security.
Key Requirements:
• Technical Proficiency in data modeling, ETL processes, BI tools, and database management systems.
• Proficient in writing complex SQL queries using MS SQL/Postgres SQL (Table, View, Functions, Stored procedure).
• Experience with data visualization tools like Power BI, Tableau, or QlikView.
• ETL Development experience in Azure Data Factory, MS SSIS, MS SQL Agents, and MS Database.
• Understanding of data warehousing concepts and architecture, specifically Ralph Kimball methodologies.
• Skills in performance optimization and query fine-tuning.
Other Details:
This is a full-time position based in Penang, Malaysia. The candidate should be adaptable and committed to continuous learning within the evolving BI landscape, working collaboratively with cross-functional teams.
🔍 Dekoder Ogłoszenia
🔴
robust experience
Oznacza to, że oczekują od kandydata znaczącego doświadczenia, a nie tylko podstawowej znajomości tematu.
🔴
strong understanding of business intelligence tools and methodologies
Może oznaczać zarówno dogłębną wiedzę, jak i jedynie ogólne pojęcie, w zależności od faktycznych wymagań projektu.
🟡
Data Modeling and Design (30%)
Chociaż jest to 30% obowiązków, może to oznaczać, że jest to główny obszar odpowiedzialności, a pozostałe procenty są rozproszone.
🟡
ETL Development (25%)
Podobnie jak w przypadku modelowania danych, 25% może sugerować, że jest to kluczowy, ale nie jedyny obszar pracy.
🟢
Ralph Kimball methodologies
Wspomnienie konkretnej metodologii jest pozytywne, ale może oznaczać, że firma jest bardzo przywiązana do tego podejścia, co może być ograniczające dla osób preferujących inne metody.