web analytics
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.