Performance Marketing Data Analyst

**Performance Marketing Data Analyst**
- ___________________________________

Location: Singapore

Type: Full-time

Department: Digital
- ___________________________________

**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.

**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 3-4 years of relevant experience
- Hands-on experience in digital marketing and/or 1:1 marketing in any channel; expert level
- knowledge in database marketing and CRM
- Strong analytical and storytelling skills; ability to derive relevant insights from large reports and
- piles of disparate data
- 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
- concepts in plain English
- Working knowledge in data visualization tools (Power BI)
- Ability to manage multiple priorities and projects, aligning teams to project timelines and
- ensuring quality of deliverables
- 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.
- Knowledge on analyzing digital campaigns and the tools/technologies of performance marketing
- Experience with Google sheet/Excel
- Education: BS/BA degree or equivalent professional experience required Degree
- Experience: Minimum 8-10 years’ professional experience in advanced analytics for a Fortune 500-scale
- company or a prominent consulting organization
- Tools: Reporting -Data Extraction tools, Advanced Excel, CRM Analytics, Campaign Marketing, Analytics
- knowledge - Campaign Analytics

**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

**About eClerx**

eClerx is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law. We are also committed to protecting and safeguarding your personal data. Please find our policy here