직무 설명

About the Role

XCM is seeking a skilled Data Analyst to join their expanding team. The ideal candidate will possess advanced SQL and Excel capabilities with a keen interest in leveraging data to enhance business outcomes. This position involves working across diverse sectors such as Retail, Sports, and Gaming, aiding well-known brands by delivering precise and actionable data insights rapidly.

Key Responsibilities

Manage complete analysis workflows responding to various client and internal tasks, from rapid insights to detailed performance evaluations.
Utilize SQL to extract, verify, and manipulate extensive datasets effectively.
Develop and maintain visual reports and insights via XCM’s Horizon BI tool to enable stakeholders to comprehend trends, performance metrics, and growth opportunities swiftly.
Evaluate the effectiveness and return on investment (ROI) of both online and offline marketing campaigns.
Analyze customer and campaign engagement across multiple channels including Email, Website activity, SMS, Direct mail, and Social media trends.
Report on marketing and customer key performance indicators (KPIs) such as lead generation, conversion rates, website traffic, engagement levels, and revenue impact.
Create insightful recommendations that influence campaign enhancements and strategic decisions.
Support regular business-as-usual (BAU) reporting while also fulfilling urgent, ad-hoc analytical requests with accuracy and speed.
Produce clear and visually engaging outputs like reports, presentations, and dashboards that translate complex data into understandable narratives.
Contribute to and support broader analytical projects and future roadmap initiatives.
Present findings and strategic suggestions effectively to internal teams and clients when needed.

Candidate Requirements

Proven expertise in SQL, adept at constructing queries to work with large, real-world datasets.
Strong proficiency in Excel, including advanced formulas, pivot tables, and handling complex spreadsheets.
Ability to manage multiple tasks and meet deadlines efficiently in a fast-paced environment.
Excellent analytical skills with an aptitude for identifying trends, discrepancies, and commercial prospects.
Capable of communicating insights clearly to audiences without technical backgrounds.
Self-motivated and well-organized with a tendency to take initiative and manage work independently.
Team-oriented with a collaborative approach to achieving common goals.

Preferred Additional Skills

Familiarity with BI and visualization platforms; experience with Superset is a distinct advantage.
Background in marketing, customer relationship management (CRM), ecommerce, or consumer analytics.
Knowledge of big data platforms, data warehouses, or automated reporting systems.

Why Join XCM?

Work fully remotely within a supportive team environment.
Engage with prominent clients across dynamic industries.
Diverse responsibilities including routine reporting, campaign insights, and strategic analytics.
Opportunities to advance your technical expertise and analytical skills.
A workplace culture that prioritizes collaboration, quality work, and ongoing improvement.

Data Analyst