Data Analyst

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.