Open to opportunities

Ankit Yadav

@ankityadav16

Message

I build trustworthy analytics pipelines, metrics, and dimensional data models.

India

Message

What I'm looking for

I'm seeking Data Analyst and Product Analyst opportunities where I can write SQL, design reliable metrics, build dimensional models, and create analytics pipelines that make data trustworthy for dashboards and business decisions.

I'm an AI and Data Science graduate in Mumbai seeking Data Analyst and Product Analyst opportunities where analytics meets engineering.

I built an end-to-end Instagram Analytics Pipeline from real performance data across 79 posts, using SQL, dbt, DuckDB, and Power BI. I designed a Star Schema data warehouse to analyze engagement metrics before they reached dashboards and decisions.

As a self-employed content creator and digital media manager, I've grown an Instagram content brand to 21M+ reach over 17 months of daily operations. I also wrote automated dbt schema tests to identify NULL values that were silently inflating engagement rates.

Experience

Work history, roles, and key accomplishments

Current

Content Creator & Digital Media Manager

Current

Self-employed

Oct 2024 - Present (1 year 11 months)

• Managed and grew my Instagram content brand to 21M+ reach across 17 months of daily operations
• Earned revenue through digital design commissions (logo work)
• Engineered a Star Schema data warehouse using the page's raw operational data to analyze engagement metrics, built with SQL, dbt Core, DuckDB, and Power BI
• Wrote automated dbt schema tests (not_null, unique, referential integrity) to

SQL DuckDB Power BI Data Warehouse Star Schemas Digital Design

Education

Degrees, certifications, and relevant coursework

Vasantdada Patil Pratishthan’s College of Engineering and Visual Arts (VPPCOEVA)

Bachelor of Engineering - BE, Artificial Intelligence and Data Science

2022 - 2026

University of Mumbai

Bachelor of Engineering - BE, Artificial Intelligence and Data science

2022 - 2026

Vasantdada Patil Pratishthan’s College of Engineering and Visual Arts

Bachelor of Engineering, Artificial Intelligence and Data Science

2022 - 2026

Pursuing a Bachelor of Engineering in Artificial Intelligence and Data Science from Vasantdada Patil Pratishthan’s College of Engineering and Visual Arts.