06/20/2026 updated
VG
100 % available
Business Analyst | Data Analyst | Ecommerce & Growth Analytics
Yamuna Nagar, India
Only remote
Bachelor of Technology (B.Tech) in Electronics and Communication EngineeringExcel Pivot TablesPython (Programming Language)SQL Databases
SQL & Data Querying
Expertise in writing optimized SQL queries using joins, CTEs, window functions, and aggregations to extract, clean, transform, and analyze large datasets from multiple data sources.
Business Analytics & KPI Reporting
Comprehensive knowledge in business performance analysis, ecommerce analytics, pricing analysis, funnel analysis, conversion analysis, customer lifecycle analysis, GMV analysis, margin analysis, and KPI reporting.
Dashboard Development with Power BI & Excel
Proficiency in building and maintaining daily and weekly dashboards for sales, conversion, customer acquisition, and operational KPIs using Power BI and Advanced Excel including Pivot Tables, VLOOKUP, and XLOOKUP.
Python for Data Analysis
Application of Python with Pandas for data cleaning, data transformation, data modeling, and reporting automation to improve operational efficiency.
Marketing Analytics
Analysis of marketing campaign performance, acquisition channels, CAC, customer quality, and ROI to support business growth initiatives.
Reporting Infrastructure & Automation
Development of reporting infrastructure and automated reporting workflows using Python, SQL, and Excel, improving reporting efficiency by 35%.
Customer Funnel & Conversion Analysis
End-to-end customer lifecycle and funnel analysis to identify user drop-offs, conversion bottlenecks, and revenue improvement opportunities.
Sales Analytics
Conducting sales analytics including pipeline tracking, conversion analysis, performance monitoring, and business trend analysis.
Data Validation & Data Integrity
Performance of data validation, consistency checks, and data cleaning to ensure reporting accuracy and data integrity across datasets.
Expertise in writing optimized SQL queries using joins, CTEs, window functions, and aggregations to extract, clean, transform, and analyze large datasets from multiple data sources.
Business Analytics & KPI Reporting
Comprehensive knowledge in business performance analysis, ecommerce analytics, pricing analysis, funnel analysis, conversion analysis, customer lifecycle analysis, GMV analysis, margin analysis, and KPI reporting.
Dashboard Development with Power BI & Excel
Proficiency in building and maintaining daily and weekly dashboards for sales, conversion, customer acquisition, and operational KPIs using Power BI and Advanced Excel including Pivot Tables, VLOOKUP, and XLOOKUP.
Python for Data Analysis
Application of Python with Pandas for data cleaning, data transformation, data modeling, and reporting automation to improve operational efficiency.
Marketing Analytics
Analysis of marketing campaign performance, acquisition channels, CAC, customer quality, and ROI to support business growth initiatives.
Reporting Infrastructure & Automation
Development of reporting infrastructure and automated reporting workflows using Python, SQL, and Excel, improving reporting efficiency by 35%.
Customer Funnel & Conversion Analysis
End-to-end customer lifecycle and funnel analysis to identify user drop-offs, conversion bottlenecks, and revenue improvement opportunities.
Sales Analytics
Conducting sales analytics including pipeline tracking, conversion analysis, performance monitoring, and business trend analysis.
Data Validation & Data Integrity
Performance of data validation, consistency checks, and data cleaning to ensure reporting accuracy and data integrity across datasets.
Experience
Professional experience0 - 5 years
Freelancer since2026
Languages
EnglishFluent
Project history
Built and maintained daily and weekly dashboards for sales, conversion, customer acquisition, operational KPIs, and business performance tracking using Power BI and Excel. Performed end-to-end customer lifecycle and funnel analysis. Conducted sales analytics including pipeline tracking and conversion analysis. Analyzed marketing campaign performance, CAC, and ROI. Wrote optimized SQL queries to extract and analyze large datasets. Developed reporting infrastructure and automated reporting workflows using Python, SQL, and Excel, improving reporting efficiency by 35%. Collaborated with cross-functional teams and presented analytical findings to stakeholders and leadership.
Analyzed complete customer lifecycle funnels to identify high drop-off stages and conversion gaps. Conducted conversion analysis and recommended optimization strategies to improve customer engagement and conversion rates. Built KPI dashboards to track funnel performance, customer behavior, and business metrics.
Evaluated acquisition channels and marketing campaigns to identify high-performing customer sources. Analyzed CAC, ROI, sales conversion trends, and business performance metrics to improve decision-making. Built dashboards and reports for sales pipeline tracking, business visibility, and operational reporting.