BI Technical Analyst

Location: Bangkok Province, Thailand
Job Type: Permanent
Salary Negotiable
Specialization: Production Engineering / Process Engineering / Manufacturing Technology
Sub Specialization:
Contact: Kannavasorn Konkla
Reference: JO-1903-414841

Roles & Responsibilities:

  • Developing ETL & ELT processes to support key business data flow using, Microsoft SQL Server and Microsoft SQL Server Integration Service (SSIS).
  • Developing .NET, C# inside SSIS component as required.
  • Developing Cube to handle high volume of the data by using, Microsoft SQL Server Analysis Service (SSAS)
  • Developing Report to support business requirement by using, Microsoft SQL Server Reporting Service (SSRS), QlikView.
  • Developing advanced T-SQL to manipulate data with very good performance.
  • Tuning, debugging & solving of complex T-SQL, SSIS data transformation (ETL), SSAS data analysis & SSRS Reporting service.
  • Designing and Developing multi-dimensional data models to store key business data and enable
  • BI reporting and high order analytics in Microsoft SQL Server.
  • Designing Staging Areas, ODS Areas, Data Warehouses and Data Marts.
  • Administering BI ETL/ELT & Staging Area Systems and Providing/Delegating for these Systems.
  • Coordinating solution designs incorporating input from Supply Chain Team Solutions team in accordance with agreed engagement processes and methodologies.
  • Coordinating the preparation of relevant documentation and manage associated peer review processes.
  • Support all technical issues related to the development from the team.

Qualifications:

  • Bachelor and/or Master Degree in Information System, Computer Science or any equivalent fields.
  • At least 5 years experiences with MS BI Stack including SSIS, SSMS, SSRS, SSAS.
  • Ability in Programming Languages: SQL (> 5 years), BI Scripting (i.e. C#, VB, etc.) > 2 years) .
  • Experience working with Business Intelligence tools (SSIS (Integration Service), SSAS (Analysis Service), SSRS (Reporting Service), Qlikview, Netezza).
  • Detailed knowledge of core BI Fundamentals (Multi-Dimensional, Star Schemas, Cubes, Data Flows and Schemas).
  • Experience with ETL or ELT from too many source a plus.
  • Demonstrated ability to analyze and plan viable BI solutions as required.
  • Demonstrated project implementation experience within supply chain environment a plus.
  • Well adapt to the multinational working and dynamic environment.
  • Good command in English skills.



The successful candidate will be provided a promising career opportunity and attractive compensation package. To submit your application, in strict confidence, please send your full resume in Word format by click "Apply Now"

For a confidential discussion please call 02-106-8600 and ask to speak to the Technology Team.
Your application will be treated with strict confidential.

en world Recruitment (Thailand) Co., Ltd.
Athenee Tower, 12th Floor, Unit 1201-1202
63 Wireless Road, Lumpini, Pathumwan, Bangkok 10330 Thailand
Tel: +66 (2) 106 8600 | Fax: +66 (0) 2654 0901
www.enworld.co.th