Data Analyst (0-2 years experience)

eClerx; Singapore; On-site; SGD 80,000 - 100,000; Full time

Job summary

A leading analytics firm in Singapore is seeking a Data Analyst to manage the end-to-end delivery of analytics projects. The role requires advanced SQL skills and the ability to provide insights from large data sets. The ideal candidate has 1-3 years of relevant experience, strong analytical skills, and knowledge of data visualization tools such as Power BI. This position offers competitive compensation and flexible working hours.

Benefits

Competitive salary and performance bonuses

Flexible working hours

Career growth opportunities and ongoing training

Inclusive, supportive company culture

Qualifications

• Very strong advanced SQL skills for analyzing and optimizing the query.
• Minimum 1-3 years of relevant experience.
• Strong analytical and storytelling skills; ability to derive insights from large reports.

Responsibilities

• Understand business models and clarify questions.
• Coordinate with business stakeholders for campaign objectives.
• Enhance existing SQL queries for optimization.
• Set up Power BI dashboards and data pipelines.
• Analyze campaign data and provide insights.
• Develop analytical projects and communicate details.

Skills

Advanced SQL skills

Analytical skills

Data visualization tools knowledge

Communications skills

Numerical skills

Numerical skills

Education

BS/BA degree or equivalent professional experience

Tools

Power BI

Google Sheets

Excel

Python

Power BI

Job description

Job Description

Data Analyst

Location: Singapore

Type: Full-time

Department: Digital

Job Summary

This is an individual contributor role responsible for the end-to-end delivery of analytics projects, which demands the ability to perform analysis directly for the client.

The successful candidate will have an extensive knowledge in the digital and database marketing operations of large brands, particularly in the use of data and analytics contributing to day-to-day operations.

Responsibilities

• Understand the business model on why things are the way they are, ask relevant questions and get them clarified
• Coordinate with business stakeholders to understand the campaign objective by participating in regular sync up calls
• Understand and follow the campaign roadmap, plan data availability and coordinate with the campaign execution team to ensure a successful campaign launch
• Enhance / optimize existing SQL queries which have been created for data optimization
• Setup data pipelines for migrating the data from one platform to another
• Set up Power BI dashboards based on the requirements and priorities provided by business stakeholders
• Prescribe suitable solutions with an understanding in limitations of toolsets and available data
• Manage procurement of data from various sources and perform data audits
• Fetch and analyze Campaign data from disparate sources and drive meaningful insights on customer behavior supported by appropriate statistical summaries
• Visualize Campaign performance and provide recommendations on the business rules for effective campaign targeting
• Interpret analytical results and provide insights; present key findings and recommended next steps to clients
• Develop tangible analytical projects; communicate project details to clients and internal delivery team via written documents and presentations, in forms of specifications, diagrams, and data/process models
• Audit deliverables ensuring accuracy by critically examining the data and reports against requirements
• Collaborate on regional/global analytic initiatives and localize inputs for country campaign practices
• Actively work on audience targeting insights, optimize campaigns and improve comm governance

Eligibility Requirements

• Must Have
  • Very strong advanced SQL skills for analyzing and optimizing the query
  • Minimum 1-3 years of relevant experience
  • Strong analytical and storytelling skills; ability to derive relevant insights from large reports and
  • Comfortable working autonomously with broad guidelines
  • Passion for data and analytics for marketing and eagerness to learn
  • Excellent communications skills, both written and spoken; ability to explain complex technical
  • Working knowledge in data visualization tools (Power BI)
  • Ability to manage multiple priorities and projects , aligning teams to project timelines and
  • Strong in numerical and analytical skills.
  • Participate in initiatives including campaign tracking, test-and-learn recommendations to improve performance of solutions delivered to the business.
  • Manage regular reporting and ad-hoc data extract from other departments.
  • Experience with Google sheet/Excel
• Good to have
  • Working knowledge of analytical/statistical techniques
  • Experience in Hadoop environment – Hive, Presto is a plus
  • Experience in Python / Airflow
  • Previous consulting experience is a definite plus
  • Education: BS/BA degree or equivalent professional experience required Degree
  • Tools: Reporting –Data Extraction tools, Advanced Excel, Python, PowerBI
• Education: BS/BA degree or equivalent professional experience required Degree
• Tools: Reporting –Data Extraction tools, Advanced Excel, Python, PowerBI

What We Offer

• Competitive salary and performance bonuses
• Flexible working hours
• Career growth opportunities and ongoing training
• Inclusive, supportive company culture