Senior Data Analyst

As a Senior Data Analyst, your primary responsibility will be to take ownership of various high-frequency datasets such as seller discoverability, catalogue quality, order funnels, SLA/TAT adherence, and compliance datasets. You will be required to build and maintain automated ETL pipelines using SQL, Python, and Power Automate to ensure reliability, accuracy, and timely data refresh. Proactively validating and optimizing these datasets is crucial to establish them as trusted sources of truth for stakeholders. In addition, you will be responsible for developing and managing Power BI dashboards with role-level security to offer real-time visibility into order journeys, operational performance, and category-level growth. It will be essential to continuously enhance the usability, performance, and accuracy of these dashboards. You will also need to deliver automated insights mails and reports summarizing trends, anomalies, and action points for leadership and network participants. Monitoring and analyzing key operational metrics such as TAT breach, fill rate, cancellations, delivery aging, and SLA adherence will be part of your day-to-day tasks. Working with API-based logs and event-driven datasets to understand order lifecycle behavior, identifying drop-offs, and ensuring log compliance across different platforms will also be crucial. Building data frameworks to evaluate participant performance and partnering with category pods to identify drop-offs, catalogue visibility issues, and growth opportunities will be essential for aligning supply and demand. Furthermore, your role will involve collaborating with internal teams to solve operational and strategic challenges through data-driven insights. Working closely with Buyer Apps, Seller Apps, and Logistics Partners to address data-driven challenges in catalogue onboarding, product discovery, order flow, and fulfillment will be key. Presenting insights and recommendations to senior leadership and network participants in a clear and business-focused manner will also be part of your responsibilities. The ideal candidate for this role should possess a Master's degree in Computer Science, Statistics, Data Science, Economics, or a related quantitative field, along with at least 5 years of experience in data processing and building data pipelines based on business logic. Strong technical skills in SQL, PostgreSQL, Power BI, Python, and Excel are required. Additionally, having experience in e-commerce, retail, or logistics analytics and a solid understanding of the digital commerce funnel will be advantageous. Moreover, you should demonstrate a business-first mindset, strong problem-solving orientation, ability to own datasets and dashboards end-to-end, accountability for accuracy and reliability, strong communication skills to translate data into actionable business insights, and comfort collaborating with cross-functional stakeholders in a fast-evolving environment. Before your interview, it is recommended that you familiarize yourself with how the ONDC protocol functions and how data is stitched together, understand and analyze end-to-end e-commerce order flows, interpret ONDC's API-driven retail and logistics contracts, and identify potential drop-off points or operational bottlenecks in the order journey. You should also prepare a PowerPoint presentation covering the end-to-end order journey, potential drop-off points or operational challenges, and recommendations or insights for improving efficiency, visibility, and network performance. Candidates will be evaluated based on their understanding of e-commerce order flows and network operations, ability to interpret API contracts and event-driven workflows, analytical thinking in identifying bottlenecks or drop-offs, clarity, structure, and business focus in the presentation, as well as the practicality and creativity of recommendations. It is advised to use diagrams, flowcharts, or visuals to illustrate the journey and focus on business impact and operational insights rather than technical details. Remember, your role as a Senior Data Analyst will be critical in driving data-driven decision-making and operational efficiency within the organization.,