Job Description

Job Purpose

We are seeking for a self-motivated Data Analyst with data analytics experience to support the Data team to uncover insights and trends that can inform business decisions and support the Sales team to drive new client acquisition and increase revenue potential with the holistic media assets.

Responsibilities

• Assist Sales team on sales packages and pre and post campaign analysis for end clients
• Prepare standard ratings, pre-campaign, post-campaign, and ad-hoc reports as required
• Run optimized pre-buy reports based on either GRP target, Reach target, Daypart Split, etc
• Collect, import, and manage data from various sources, such as databases, surveys, and API\'s
• Clean and prepare data for analysis using tools such as Excel, SQL, and Python
• Conduct secondary research to gain a broad understanding for a project, or to understand industry trends and competition
• Identify gaps in existing research, macroeconomic and industry landscape knowledge
• Perform statistical analysis and create data visualizations to identify patterns and trends
• Prepare reports and dashboards to the head of insights and stakeholders
• Collaborate with other teams and departments to understand their data needs and assist in problem-solving

Qualifications & Work Experience

• Degree/ Diploma holder with relevant experience
• Able to do raw data mining using SQL script and/or Python
• Proficient in PowerPoint (charting and reporting) and Excel (advanced Excel and VBA)
• 1-2 year working experience with business intelligence tools (e.g., Power BI, Tableau)

Retail and Advertising Solutions & Services Partner

Stellar Lifestyle is the largest managing agent of retail and advertising spaces in Singapore\'s rail network. We create vibrant transit destinations through continuous innovation and a desire to make our everyday touchpoints better. Our expertise also includes retail mall management, outdoor media & digital advertising solutions, and digital engagement platforms.

About SMRT Corporation

SMRT Corporation Ltd (SMRT) is a public transport services provider. Our primary business is to manage and operate train services on the North-South Line, the East-West Line, the Circle Line, the new Thomson East-Coast Line and the Bukit Panjang Light Rail Transit. This is complemented by our bus, taxi and private hire vehicle services.

An exciting and rewarding career is waiting for you at SMRT. Join us and embark on a journey that matters. You Matter \xe2\x80\x93 we take care of you and your well-being. Your Work Matters \xe2\x80\x93 your ideas and contributions work towards building the future of our transport system and create positive impacts to the community. Your Development Matters \xe2\x80\x93 we offer diverse careers and learning opportunities for our people to grow you to the fullest of your potential.

Come onboard the SMRT journey today.

Vision
Moving People. Enhancing Lifestyles

Core Values
Respect, Integrity, Service & Safety, Excellence

SMRT Corporation