Associate Manager - Data Analyst

About The Media Ant:

The Media Ant is an 12-year-old platform for media discovery, planning and execution of marketing campaigns. We aim to disrupt the traditional process of executing ad campaigns through a physical media agency and replace it with a self-serve advertising platform. The platform should work equally well for both online and offline media.

This platform will empower any advertiser, irrespective of their budget and level of marketing understanding, to be able to go ahead and launch a campaign.

The Media Ant is the winner of various startup awards and is used by more than a million users every year. Please visit our website (www.TheMediaAnt.com) to learn more.

Job Description:

We re looking for a Data Analyst to oversee and optimize business data, including website traffic, leads, sales, and P&L. You ll design and maintain scalable data pipelines, build robust infrastructure, and ensure data quality through validation and monitoring. Collaborating with cross-functional teams, you ll develop data models, address bottlenecks, and create dashboards that deliver actionable insights. Join us to transform data into impactful solutions and drive business success.

Education / Job Experience Required:

1. Bachelors or masters degree in computer science, data science, or a related field

Location: Bangalore Onsite

Day-to-Day Work:

1. Responsible for managing all aspects of business data including website traffic, leads, sales & final P&L.

2. Design and develop robust, scalable, and efficient data pipelines and ETL processes to extract, transform, and load data from various sources into data warehouses or data lakes.

3. Build and maintain data infrastructure, including data warehouses and data processing frameworks.

4. Ensure data quality and integrity by implementing appropriate data validation, monitoring, and error handling mechanisms.

5. Develop and maintain data models and schemas to support data analytics and reporting needs.

6. Identify and address data-related issues and bottlenecks, ensuring the smooth operation of data pipelines and systems.

7. Construct and maintain dashboards that allow users to understand performance and generate

Insights.

8. Collaborate closely with cross-functional teams, including engineering, product management, and business stakeholders, to ensure alignment between business objectives and technical solutions.

Must-Have:

1. Must have experience with Google cloud platform (Bigquery, Dataproc, Cloud functions)

2. Solid understanding of SQL and No SQL Databases like Postgresql & MongoDB.

3. Strong proficiency in Python with experience in data manipulation and scripting.

4. Hands-on experience with ETL tools and data integration using third party APIs.

5. Proven experience with data modelling & report automation.

6. Must have experience in designing, building and maintaining database & data warehouses.

7. Any further experience with Google Apps Script and Google AppSheet.

Good to Have:

1. Any prior experience with Power BI.

2. Understanding of real time data streaming technologies.