Data Analyst

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-4 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)
  • , 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