Other
23 Aug 2019
Job Opportunity : Data Warehouse Assistant Manager ( 80 - 100 K )
Position
Data Warehouse Assistant Manager ( 80 - 100 K )
Our Client
A leading company in clothing fashion
Location
Bangkok
Report to
Merchandise Planning Director
Responsibilities :
- Define/Manage data collection, data stores, data structure and build data warehouse.
- Manage data authorization control and data security.
- Manage all data in the company and create data pipeline in all systems for data integration.
- Apply BI expertise and Service Management best practices to ensure the systems provide best service and delivery for good quality of reporting and sources data for analytics.
- Acquire data in source systems from primary and secondary data sources into data warehouse.
- Ensure Data quality by performing data preparation (ETL), data cleansing and provide the required data for Business Data Analyst.
- Manage and ensure the data to provide on a timely basis to responsible teams and stakeholders with accuracy for BI integration, dashboard and adhoc reports.
- Maintain Data Warehouse operation and ensure the data generation properly.
- Maintain Data Warehouse operation and ensure the data generation properly.
- Solving the issue/incident on the Data Warehouse system and finding the permanent fix solution
Qualification :
- Age 28 - 35
- In-depth understanding of database structure principles, database design, interfaces and query languages.
- Experience with Data warehousing & ETL techniques that enable data ingestion, data blending, and data integration.
- At least 3 years of Data Warehouse ETL workflow design, development and maintenance with successful implementation of large Enterprise BI solutions.
- Experience in Data Warehouse operation.
- Strong understanding of Business Intelligence and Data Warehousing.
- Demonstrated knowledge of database concepts of data modeling and mapping including normalization/demoralization, dimensionality, referential integrity, star and snowflake schemas, master data and metadata.
- Ability to integrate various data sources including Transactional databases, MS Excel, Web Services, external social media data, and unstructured data sources.
- Experience in Cloud processing is a plus.
- Experience in using BI tools such as Tableau, Power BI, Quik sense, etc
- Strong analytical skills with ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Strong expertise SQL command & queries
- Graduated in MIS, Computer Science, Computer Engineer or relevant field.
- Able to remote/stay on mission some nights/weekends for production support in case of emergency incident.