Business Intelligence Analyst

C. K. Tang Limited; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A leading retail company in Singapore seeks a Business Intelligence Analyst to support data-driven decision-making. The successful candidate will collaborate with stakeholders to create interactive dashboards and generate key reports. Applicants should possess a relevant Bachelor's degree and experience in the retail sector with strong proficiency in AWS QuickSight and SQL. This role requires strong analytical skills, effective communication, and the ability to adapt in a dynamic environment.

Qualifications

• Bachelor’s degree in a related field.
• Proven experience as a Business Intelligence Analyst in retail.
• Strong understanding of retail business processes.
• Proficiency in AWS QuickSight and Snowflake.
• Skilled in SQL and advanced Excel.

Responsibilities

• Collaborate with stakeholders for data needs.
• Design and maintain KPIs.
• Create interactive dashboards in AWS QuickSight.
• Generate automated and ad-hoc reports for management.
• Ensure data accuracy and enforce governance standards.

Skills

Business Intelligence

Data Analysis

SQL

Data Visualization

Problem-Solving

Communication Skills

Collaboration

Education

Bachelor’s degree in Business Analytics, Data Science, Statistics, Information Systems, Economics, or Accounting

Tools

AWS QuickSight

Snowflake

Advanced Excel

Python

Job description

Business Intelligence and Reporting

• Collaborate closely with stakeholders to understand and fulfil data needs, providing actionable insights.

• Design and maintain Key Performance Indicators (KPIs) to evaluate and monitor business metrics.

• Create and optimize interactive dashboards in AWS QuickSight, transforming complex data into accessible visualizations for decision-makers.

• Generate automated and ad-hoc reports for management to track and analyse critical metrics.

• Customize dashboards to meet specific reporting requirements across business units, ensuring they are user-friendly and provide comprehensive views of key performance metrics.

Data Collection and Integration Planning

• Collaborate with the IT Team to plan and coordinate data collection and integration efforts, ensuring data from various sources, such as sales transactions, customer interactions, and inventory records, is effectively captured and managed.

• Support the development and maintenance of data pipelines to ensure accurate and timely data availability for analysis.

Data Quality and Governance

• Ensure data accuracy, completeness, and consistency across all datasets.

• Implement and enforce data governance standards and policies.

Cross-Functional Collaboration

• Act as a bridge between technical and non-technical teams, translating business needs into technical requirements.

• Collaborate with various departments to gather requirements and develop effective data solutions.

Ad-Hoc Analysis & Support

• Provide ad-hoc analysis and insights as needed to address specific business challenges or support key initiatives.

• Troubleshoot and resolve data issues, queries, and discrepancies in reports or visualizations.

• Any adhoc tasks as and when assigned by immediate superior.

Requirements

• Bachelor’s degree in Business Analytics, Data Science, Statistics, Information Systems, Economics, Accounting, or a related field.

• Proven experience as a Business Intelligence Analyst, ideally in the retail industry, with a focus on business intelligence and dashboard creation.

• Strong understanding of retail business processes and trends.

• Proficiency in AWS QuickSight and Snowflake, or equivalent cloud-based BI and data warehouse platforms.

• Proficiency in Advanced Ms. Excel formula and data model.

• Proficiency in SQL for querying and managing data is essential.

• Experience with Python is advantageous, particularly for data manipulation, automation, and machine learning.

• Strong analytical and critical thinking skills with a problem-solving mindset.

• Effective communication and collaboration skills.

• Ability to work independently in a fast-paced and dynamic environment.