Analyst, E-commerce / Retail Analytics

Fornax; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A leading analytics firm in Singapore is seeking a skilled Analyst to solve business challenges through data analytics. The ideal candidate will have experience in the Retail/D2C domain, with expertise in SQL, Tableau, and data modeling. Responsibilities include stakeholder collaboration, data analysis, and dashboard development. Apply to join a team that drives impactful solutions using analytics.

Qualifications

• 2+ years of analytics experience.
• Proficiency in SQL and database technologies.
• Core expertise with dbt (data build tool).
• Familiarity with cloud platforms (AWS, Google Cloud).

Responsibilities

• Work with data scientists and stakeholders to understand data needs.
• Analyze e-commerce data to identify trends and opportunities.
• Develop and maintain data models for analytics and reporting.
• Design dashboards and visualize data effectively.

Skills

Stakeholder Management

Data Analysis

Data Modeling

Dashboard Development

SQL

Tableau

Power BI

Python

Education

Bachelor's degree in Computer Science, Data Science, Engineering or related field

Tools

Tableau

Power BI

Apache Airflow

Mage

Job description

Who is this for

If solving business challenges drives you, this is the place to be. Fornax is a team of cross-functional individuals who solve critical business challenges using core concepts of analytics.

We are seeking a skilled Analyst with experience in the Retail/D2C domain. The ideal candidate will possess a strong blend of functional and technical expertise.

Key Responsibilities:

1. Stakeholder Management & Collaboration (30%)

• Work with data scientists, analysts, and stakeholders to understand data needs.
• Analyze and interpret e-commerce data to identify trends, opportunities, and areas for improvement.
• Gather customer requirements via workshops, questionnaires, surveys, site visits, workflow storyboards, use cases, and scenario mappings.
• Translate business requirements into functional requirements.
• Create extensive project scope documentation to align project and client teams.
• Collaborate with cross-functional teams to integrate analytics insights into operational processes.

Data Modeling (20%)

• Develop and maintain data models to support analytics and reporting.
• Design dimensional models and star schemas for retail data including sales, inventory, customer behavior, and product performance metrics.
• Translate analytical requirements into efficient data structures, ensuring models align with reporting needs.
• Document data lineage, business rules, and model specifications for knowledge transfer and data governance.

Data Quality Management & Governance (20%)

• Develop and implement data quality frameworks and monitoring systems.
• Lead root cause analysis of data quality issues and implement preventive measures.
• Perform data cleansing and enrichment processes.
• Provide training on data quality best practices.

Dashboard Development & Visualization (30%)

• Design and develop dashboards using tools like Tableau, Power BI, or Looker.
• Implement advanced features such as drill-downs, filters, and dynamic parameters.
• Create standardized templates and style guides.
• Train business users on dashboard usage and data interpretation.

Key Skills & Education:

• Bachelor's degree in Computer Science, Data Science, Engineering, or related field.
• 2+ years of analytics experience.
• Proficiency in SQL and database technologies.
• Core expertise with dbt (data build tool).
• Experience with data pipeline tools like Apache Airflow or Mage.
• Familiarity with cloud platforms (AWS, Google Cloud).
• Knowledge of Python or R.
• Experience with data visualization tools such as Tableau and Power BI.