Data Analyst

Job Description

Company: AdMax Local

About the job

About Us:

How would you like to work for a fast-growing, international company in one of the hottest spaces on the Internet? AdMax Local is the world’s first fully automated SEM, Social and website platform that enables resellers to price, build, manage, optimize and report on high quality, hyper-local search campaigns and websites for multiple businesses at scale. Available in the European and Asian Pacific markets since 2009 AdMax Local has been deployed with tens of thousands of international clients, driving returns that far exceed the industry average for large-scale local search & social campaigns. AdMax Local launched in the US market in 2013.

Designed for marketing agencies, media resellers, franchisors and other businesses looking to add Search and Social marketing to their service portfolio or improve the performance and profitability of their existing Search & Social business, AdMax Local frees businesses from being forced to choose quality search campaigns over profitable campaigns. For the first time, US businesses have an alternative to the traditional Agency model, and are now able to automate all aspects of a Search & Social marketing –from sales, deployment and account creation, to bidding and management—while still running high-quality, hyper-local campaigns.

About the Opportunity:

You will be joining our Bangalore hub and will be primarily responsible for managing reporting needs for our managed services customers. This position requires an experienced Data Analyst professional, with Digital marketing experience, and has advanced Excel, SQL, BI Tools & Python Skills. The right candidate must have strong US English language capabilities, strong math, be able to build positive relationships with co-workers, be digitally savvy, detail-oriented, and a hardworking professional able to work well in a team-oriented, client-focused and ROI-focused environment.

What you will be doing:

• Data Engineering and ETL process using Python and Shell script
• Managing Reports which are required to be communicated to client on daily, weekly and Monthly Basis
• You will extract data from multiple data sources such as AdWords, Bing Ads, Facebook, internal database and other reporting interfaces and compile these data using Excel to produce Error free Client facing reports.
• Strong Advanced Excel skills for Data cleansing & Manipulation to get the outcome required for Reports.
• Creating and Maintaining Zoho Analytics Dashboards which involves creating SQL Query Tables, Reports and Charts as part of Dashboard.
• Creating and Maintaining Looker Studio Dashboards.
• Able to assist team whenever there is demand for Ad-hoc reports.
• Look for ways to improve the existing process.
• Should be open to learning new technologies required for the process.
• Collaborate with Account manager, Tech ops, Editorial team, and other reporting resources to deliver client success.
• Be responsible for maintaining work integrity and accuracy.

What you will bring to the team:

• Excellent understanding of Internet Marketing practices with minimum 2-3 years of experience handling Reports and Dashboards.
• Knowledge of Advanced Excel skills, SQL, Python & BI Tools is a must.
• Hands on experience on any of BI Tools such as Looker Studio, Zoho Analytics, Power BI, MicroStrategy.
• Familiarity with Digital marketing KPIs, Statistical knowledge is an added advantage.
• Good Email etiquette and communication skills.
• Exceptional time management skills, including the ability to handle multiple projects and ongoing work items, while effectively managing changing priorities
• Ability to analyze data and make recommendations.
• Proficiency with Microsoft Office products
• Sharp focus on client service and satisfaction
• Keen attention to detail and consistent ability to meet deadlines.
• Strong written and oral communication skills