Marketing Analyst

Designation: business analyst

Company name - promilo.com (sawara solutions pvt ltd)

Experience – 2 - 8 yrs.

Location: Bangalore

Mode – full time / work from office

About us:

Promilo is India’s 1st innovative platform which “pay to browse”

It is a b2b SaaS start-up that enables to accelerate  the business appointment funnel of the

Companies. We’re an SaaS based advertising platform that connects both users & advertisers. Users will be able to book an online appointment based on their interests with the advertiser, without compromising their data privacy and get rewarded for sharing their data and time. We’re registered and recognized by start-up India, start-up Karnataka & MSME companies. Also, the top 100 Google AppScale academy start-up

Job description:

We are looking for an experienced business analyst to join our team. The ideal candidate will have 2-8 years of experience in web & mobile user & client data analyst for start-ups, with a strong passion to help start-ups and a proven track record to bring the strong business insight to improve the sales, marketing, user, client, ui, ux of the organisation.

Responsibilities

• Requirement gathering and analyzing
• Conduct gap analysis, assess scope & suggest solutions
• Responsible for technical proposal writing and time and cost analysis for web and mobile application development
• Preparing rfp/rfq
• Would be involved in presales activities
• Work as liaison between client and technical team
• Create wireframe | prototype | feature list | srs | brd & flow diagrams as per the client's requirement
• High it literacy proven use of web and associated technologies (excel, power point, google apps).
• Previous experience with data visualization tools (tableau, power bi, etc.), is strongly preferred.
• Cleanse and curate sourced data into standardized reporting templates
• Create, document, validate and ensure delivery of ad hoc, daily weekly, and monthly reports to internal stakeholders
• Create, validate and deliver tracking links for the marketing department
• Assist in the creation, qa, validation and reporting of a/b and multivariate tests
• Proactively monitor the marketing kpis and ua data on a daily basis
• Analyze marketing ua performance and conduct deep dive analysis to answer hypotheses and questions posed by the team
• Gather, transform, and analyze digital marketing data, including paid media, search, social, website, and conversion funnel analytics
• Analyze marketing data searching for top of funnel growth opportunities
• Analyze product data searching for insights to increase app engagement, conversion, and retention
• Analyze ltv/cac drivers to support overall business growth
• Partner with marketing, product, and growth teams
• Present findings to stakeholders and make recommendations for spend targets and campaign strategies
• Pov on ios 14 and upcoming android privacy changes and we can navigate tracking in light of these changes
• Pov on transition to skan 4.0
• Working knowledge of statistical techniques (regression, k-means clustering, pca)
• Experience with lift studies and marketing mix modeling working experience with python, r, & dbt
• Experience at a small company
• Experience with a subscription business
• Analyze website and mobile app data on traffic sources and patterns. Provide insight on data trends and anomalies, making recommendations where appropriate to improve business performance.

Qualification

• Master's or bachelor degree in computer science
• Well-versed with its technologies
• 2+ years of business analysis or project analysis experience
• Tech-savvy with proficiency in Microsoft office, google apps, and other web and mobile applications
• Excellent written and verbal communication skills
• Self-motivated, flexible, and comfortable with a fast-paced startup environment
• Advanced experience with Excel, google sheets including an understanding of visualizations, pivot tables, vlookup, and other key functions
• Experience with adobe analytics, google analytics, tableau, SQL, and data grid is a plus.
• Strong analytical and problem-solving skills, with clear attention to detail
• Ability to prioritize and work under tight deadlines
• Fast learner, able to master new concepts, theories, ideas, and processes with ease
• Experience creating user acquisition reports and dashboards
• Deep understanding of mobile attribution, cohort analysis, customer segmentation, and ltv modeling
• Experience pulling data and creating databases using an API of at least one of these ad platforms; Facebook, Snapchat, TikTok, google ads, applovin
• Experience with the architecture and deployment of mobile tracking solutions, including SDK integration, ad platforms APIs, server-postbacks, and mmp providers such as Appsflyer, adjust, kochava

If you are data driven individual with a passion for start-ups and have experience in business analytics, we encourage you to apply for this position. We offer a competitive salary package, flexible working hours, and a supportive work environment that fosters growth and development.

Responsibilities 

• Identify, analyze, and interpret trends or patterns in complex data sets to develop a thorough understanding of users, and acquisition channels.
• Run exploratory analysis uncover new areas of opportunity, generate hypotheses, and quickly assess the potential upside of a given opportunity.
• Help execute projects to drive insights that lead to growth.
• Work closely with marketing, design, product, support, and engineering to anticipate analytics needs and to quantify the impact of existing features, future product changes, and marketing campaigns.
• Work with data engineering to develop and implement new analytical tools and improve our underlying data infrastructure. Build tracking plans for new and existing products and work with engineering to ensure proper
• Analyze, forecast, and build custom reports to make key performance indicators and insights available to the entire company.
• Monitor, optimize, and report on marketing and growth metrics and split-test results. Make recommendations based on analytics and test findings.
• Drive optimization and data minded culture inside the company.
• Develop frameworks, models, tools, and processes to ensure that analytical insights can be incorporated into all key decision making.
• Effectively present and communicate analysis to the company to drive business decisions.
• Create a management dashboard including all important KPIs to be tracked on a company and department level

• Establish end to end campaign ROI tracking mechanism to attribute sales to specific google and Facebook campaigns

Skills and Experience

• Minimum 1-2 years of proven work experience in a data analyst role.
• Excellent analytical skills and problem-solving ability; the ability to answer unstructured business questions and work independently to drive projects to conclusion.
• Strong analytical skills with the capacity to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Experience extracting insights using advanced SQL or similar tool to work efficiently at scale. Advanced expertise with commonly used analytics tools including Google Analytics, studio and Excel.
• Strong knowledge of statistics, this includes experimental design for optimization, statistical significance, confidence intervals and predictive analytics techniques.
• Must be self-directed, organized and detail oriented as well as have the ability to multitask and work effectively in a fast-paced environment.
• Active team player, excellent communication skills, positive attitude and good work ethic.

Work closely with Product Managers to drive product improvements through data driven decisions.

Conduct analysis to determine new project pilot settings, new features, user behaviour, and in-app behaviour.

Present insights and recommendations to leadership using high quality visualizations and concise messaging.

Own the implementation of data collection and tracking, and co-ordinate with engineering and product team.

Create and maintain dashboards for product and business teams.

Requirements

1+ years’ experience in analytics. Experience as Product analyst will be added advantage.

Technical skills: SQL, Advanced Excel

Good to have: R/Python, Dashboarding experience

Ability to translate structured and unstructured problems into analytical framework

Excellent analytical skills

Good communication & interpersonal skills

Ability to work in a fast-paced start-up environment, learn on the job and get things done.

• Possess strong domain knowledge - Digital Analytics (Google Analytics, App Analytics (Firebase/AppsFlyer/Branch/MixPanel), CRO, Media Analytics 

• Ability to handle Google Analytics clients end-to-end  

• Contribute to building effective process management, mentoring teammates, reducing product & execution inefficiencies 

• Be responsible for day-to-day Google Analytics operations and performance of client accounts, requiring interaction with both internal and external stakeholders.   

• Own, manage and grow digital analytics strategies for clients.   

• Be responsible for all regular (and ad hoc) reporting and analysis of digital activity providing crucial insights, and effectively communicating this to the client.   

What you need to have:

• Minimum 2 years of data analytics and interpretation experience
• Proven experience to show how data analytics shaped strategy, marketing and product. Should have multiple examples of this based on current and past experience
• Strong Data Engineering skills using tools like SQL, Python, Tableau, Power BI, Advanced Excel, PowerQuery etc
• Strong marketing acumen to be able to translate data into marketing outcomes
• Good understanding of Google Analytics, Google AdWords, Facebook Ads, CleverTap and other analytics tools
• Familiarity with data sources like Branch/ Clevertap / Firebase, Big Query, Internal Tables (User/ Click/ Transaction/ Events etc)    

• Proficiency in shell scripting
• Proficiency in automation of tasks
• Proficiency in Pyspark/Python
• Proficiency in writing and understanding of sqoop
• Understanding of CloudEra manager
• Good understanding of RDBMS
• Good understanding of Excel