Data Science & Analytics

Roles and Responsibilities

1Analyse data and marketing datasets to identify trends and opportunities.2Use advanced Google Sheets and Excel capabilities (formulas, macros, Pivot Tables) for data management and reporting.3Query and manage large datasets using MongoDB for actionable insights.4Track and measure key KPIs related to operations and marketing performance.5Develop and maintain dashboards to visualize and communicate data.

Eligibility Criteria / Who are we looking forSkills required (technical/soft)

Proficiency in Google Sheets and Excel (advanced formulas, macros, Pivot Tables).
Strong knowledge of MongoDB for querying and managing datasets.

Good to have skills/industry experience (not must knowledge)Knowledge of SQL for database management and analysis.
Experience with Power BI or similar data visualization tools.
Familiarity with performance marketing platforms like Google Ads and Facebook Marketing.

Years of exp

Minimum of 2 years of experience in a similar role, particularly in data analysis.

Educational qualification

Bachelors degree in data Analytics, Marketing, Computer Science, or a related field.

About House of Edtech

Welcome to House Of Ed-Tech (Goenka Kachave LLP), the leading ed-tech company in India.
Join our community of 350-plus employees who are upskilling and educating ambitious learners and take control of your professional growth with confidence.
Our diverse portfolio includes brands such as SPRINGPAD, be10x, Profit Uni, OFFICE MASTER, Mad About Sports, and Dr. Finance, showcasing our ability to cater to various educational niches.
Website House of EdTech

Screening Assignment

1. Which of the following tools is best suited for creating advanced formulas, macros, and pivot tables?
A) Google Ads
B) MongoDB
C) Google Sheets/Excel
D) Power BI2. What is MongoDB primarily used for?
A) Managing relational data
B) Storing and querying large unstructured datasets
C) Creating data visualizations
D) Tracking marketing KPIs3. Which formula would you use in Excel/Google Sheets to look up data in a table based on a key?
A) SUMIF
B) VLOOKUP
C) COUNTIF
D) CONCATENATE4. What does ROAS stand for in performance marketing?
A) Return on Average Sales
B) Revenue on Ad Spend
C) Return on Ad Spend
D) Reach on Audience Segments5. Which of the following skills is NOT mandatory for this role?
A) MongoDB
B) SQL
C) Power BI
D) Google Sheets6. In MongoDB, which command is used to retrieve data from a collection?
A) SELECT
B) FETCH
C) FIND
D) QUERY7. Which visualization tool is good to have but not mandatory for this role?
A) Tableau
B) Power BI
C) Google Data Studio
D) All of the above8. What function would you use in Google Sheets to filter rows that meet specific criteria?
A) FILTER
B) SORT
C) INDEX
D) MATCH9. Which KPI is most relevant for evaluating ad campaign efficiency?
A) Bounce Rate
B) ROAS (Return on Ad Spend)
C) DAU (Daily Active Users)
D) Churn Rate10. Which database structure is MongoDB based on?
A) Relational
B) NoSQL Document
C) Hierarchical
D) Columnar