Job Purpose:
The Business Intelligence Analyst uses data to figure out market and business trends for iCar Asia to increase profits and efficiency. The Analyst works with cross-functional teams across Malaysia, Indonesia, and Thailand and gathers data through various means, including mining iCar Asia's computer data and analyzing industry trends to develop a comprehensive picture of the company's standing in the industry and areas for improvement.
Job Responsibilities:
Design and maintain data warehouse and data marts.
Translate requirements from the business and analysts into technical code.
Build complex queries to meet specific business requirements.
Identify and test for bugs and bottlenecks in the ETL solution.
Ensure optimal performance and data quality.
Utilize ad-hoc techniques for on-the-fly data analysis.
Maintain and update business intelligence tools by validating data accuracy.
Provide technical support for existing dashboards and reporting/visualization.
Create and maintain documentation, including requirements, design, and user manuals.
Prepare dashboard reports by analyzing and summarizing information and trends.
Requirements:
Bachelor's degree in IT, Computer Science, Information System Management, or equivalent.
At least 3-5 years of experience in data warehousing and business intelligence projects.
Good working experience with Microsoft BI tools, QlikView, Pentaho BI, and MicroStrategy.
Knowledge and experience in Tableau and Google Analytics.
Experience with ETL tools: Pentaho, DataStage, SSIS, Informatica.
Hands-on experience with SQL and Google BigQuery, including query tuning, data analysis, and integration.
Familiarity with technologies like Redshift, Linux, and Google Cloud Computing is desired.
Strong analytical skills.
Strong problem-solving skills.
Solid experience working for a multinational organization where English is the primary business language, ideally based abroad.
Experience in the automotive or e-commerce industry.#J-18808-Ljbffr