ShepHertz - Senior Data Analyst - Python / SQL / ETL
SHEPHERTZ TECHNOLOGIES PRIVATE LIMITEDDelhi, IN30+ days ago
Job descriptionDevelop and manage Power BI dashboards with role-level security that provide real-time visibility into order journeys, operational performance, and category-level growth. Continuously improve dashboard usability, performance, and accuracy. Deliver automated insights mails and reports summarizing trends, anomalies, and action points for leadership and network participants. Monitor and analyze key operational metrics : TAT breach, fill rate, cancellations, delivery aging, and SLA adherence. Work with API-based logs and event-driven datasets to understand order lifecycle behavior, identify drop-offs, and ensure log compliance across buyer and seller platforms. Build data frameworks (e.g., NP Scorecards) to evaluate participant performance across order fulfillment, SLA compliance, and customer issue resolution. Partner with category pods to identify order journey drop-offs, catalogue visibility issues, and growth opportunities in supply-demand alignment. Collaborate with internal teams to solve operational and strategic challenges through data. Work closely with Buyer Apps, Seller Apps, and Logistics Partners to identify and address data-driven challenges in catalogue onboarding, product discovery, order flow, and fulfillment. Present insights and recommendations to senior leadership and network participants in a clear and business-focused manner. Masters degree in Computer Science,Statistics, Data Science, Economics, or a related quantitative field. 5+ years of experience in data processing and building data pipelines based on business logic. Should have worked on DAX queries or creating data pipelines for a BI tool. Preferably atleast 2 years in e-commerce, retail, or logistics analytics. And strong understanding of the digital commerce funnel : catalog ingestion, search & discovery, cart & checkout, order confirmation, fulfillment SLAs, and post-purchase resolution. Proficiency in SQL ,PostgreSQL for advanced querying, data modeling, and ETL. Strong experience with Power BI (dashboarding, role-level security, optimization). Hands-on experience in Python for data processing, automation, and statistical analysis. Advanced user of Excel for ad-hoc analysis and modeling. Familiarity with analyzing transactional or API-driven datasets (e.g., order lifecycle events, SLA tracking, compliance logs). Business-first mindset with strong problem-solving orientation. Ability to own datasets and dashboards end-to-end with accountability for accuracy and reliability. Strong communication skills to translate data into actionable business insights. Comfortable collaborating with cross-functional stakeholders in a fast-evolving environment. Understand and analyze end-to-end e-commerce order flows. Interpret ONDCs API-driven retail and logistics contracts. Identify potential drop-off points or operational bottlenecks in the order journey. Present insights and recommendations in a clear, business-focused manner. Visit the ONDC GitHub page. Review the latest retail and logistics contract specifications. Understand the APIs, endpoints, and workflows for order lifecycle events. Stitch together the full order journey : product discovery ? search ? selection ? cart ? checkout ? order confirmation ? fulfillment ? delivery. Highlight interaction points between Buyer Apps, Seller Apps, and Logistics Partners through APIs. Identify potential drop-off points or failures that could affect the order flow. Prepare a PowerPoint presentation covering : Diagram of the end-to-end order journey with API interactions. Potential drop-off points or operational challenges. Recommendations or insights for improving efficiency, visibility, and network performance. 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. Practicality and creativity of recommendations. Use diagrams, flowcharts, or visuals to illustrate the journey. Emphasis should be on business impact and operational insight, not just technical details. Focus on end-to-end visibility from product discovery to post-order resolution.
Job Title : Senior Data Analyst
Day-to-Day Responsibilities :
Data Ownership & ETL :
- Take end-to-end ownership of high-frequency datasets including seller discoverability, catalogue quality, order funnels, SLA / TAT adherence, and compliance datasets.
- Build and maintain automated ETL pipelines using SQL, Python, and Power Automate, ensuring reliability, accuracy, and timely refresh.
- Proactively validate and optimize datasets so that stakeholders can trust them as single sources of truth.
Dashboarding & Reporting :
Operational, API & Growth Analytics :
Stakeholder Engagement :
Ideal Candidate Profile :
Education & Experience :
Technical Skills
Behavioral & Soft Skills :
Instructions :
Explore ONDC GitHub :
Map the End-to-End Order Journey :
Deliverable :
Evaluation Criteria :
Candidates will be evaluated on :
Optional Guidance :
(ref : hirist.tech)
Create a job alert for this search
Senior Data Analyst • Delhi, IN
Related jobs
![Senior Analyst - DLP [T500-21382]](https://cdn-logos.talent.com/v1/logo/image?feedcode=jobrapido-pms&company_name=MUFG)
- Promoted
Senior Python Developer
Huptech HR SolutionsDelhi, IN Job Post : - Senior Python Developer.Software Development : Write clean, scalable, and efficient Python code to develop software applications.
Backend Development : Design, develop, and maintain server...Show moreLast updated: 6 days ago
- Promoted
- New!
Data Analyst
Amicon Hub Servicesgurgaon, haryana, in Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or a related field.Proficiency in SQL and query optimization for complex data sets.
Experience with BI tools such as P...Show moreLast updated: 4 hours ago
- Promoted
Senior Analyst
Branch InternationalGhaziabad, IN Branch is a leading AI-based lending fintech with 50M+ downloads across India and Africa.We use alternative data to reach millions of people that are largely excluded from the financial sector.Head...Show moreLast updated: 6 days ago
- Promoted
Senior Data Analyst
Ruder Finn IndiaGhaziabad, IN Ruder Finn is seeking a Senior Data Analyst (Data Analyst III) to join its award-winning Emerging Technology & Analytics team.
The chosen candidate will support the agency’s new business efforts by ...Show moreLast updated: 17 days ago
- Promoted
Senior Data Engineer
SAIVA AIDelhi, IN We are building the future of healthcare analytics.Join us to design, build, and scale robust data pipelines that power nationwide analytics and support our machine learning systems.Our goal : pipel...Show moreLast updated: 30+ days ago
- Promoted
- New!
Lead Databricks Analyst
RialtesDelhi, IN Rialtes is seeking a Databricks Support Analyst to manage platform operations, ensure reliability of clusters and jobs, and support development of data workflows.
Role requires hands-on experience w...Show moreLast updated: 8 hours ago
- Promoted
Senior Python Developer
Intellify SolutionsDelhi, IN We are looking for an experienced.The ideal candidate should have a solid understanding of modern backend systems, architecture design, and performance optimization.
The role involves working on sca...Show moreLast updated: 4 days ago
- Promoted
Senior Python Developer
Cactus Communicationsnarela, delhi, in You will be a part of Cactus Labs which is the R&D Cell of Cactus Communications.Cactus Labs is a high impact cell that works to solve complex technical and business problems that help keep us stra...Show moreLast updated: 30+ days ago
- Promoted
- New!
Senior Data Analyst
DataVinci Analytics AgencyDelhi, IN Job Role : Senior Data Analyst.Work closely with the data lead to prepare, clean, and transform backend data for reporting and automation use cases.
Build visually clean, client-facing dashboards (L...Show moreLast updated: 8 hours ago
- Promoted
Senior Data Engineer
IntelliasDelhi, IN Apache Flink / Apache Spark (Streaming).Data Engineer or similar role, with hands-on expertise in large-scale, production-grade data pipelines.
Kafka + Flink / Spark Streaming).Python for data engin...Show moreLast updated: 6 days ago
- Promoted
Senior Python Developer – API & Data Connectivity (Freelance)
KeyrusDelhi, IN Keyrus is an international consulting firm, specializing in the integration of data intelligence and Digital solutions.With over 3,500 employees spread across 27 countries, Keyrus continues to deli...Show moreLast updated: 6 days ago
- Promoted
- New!
Senior Analyst - DLP [T500-21382]
MUFGfaridabad, haryana, in Japan’s premier bank, with a global network spanning in more than 40 markets.Outside of Japan, the bank offers an extensive scope of commercial and investment banking products and services to busin...Show moreLast updated: 4 hours ago
- Promoted
- New!
Senior Python Developer
Recrofaridabad, haryana, in You’re eager to build products from scratch, own an entire product line, and lead a small but growing engineering team.You balance technical rigor with the pragmatism required to ship quickly, and ...Show moreLast updated: 4 hours ago
- Promoted
- New!
Senior Python Developer
N2S.Globalfaridabad, haryana, in We are seeking a skilled and motivated.The ideal candidate will be responsible for designing, developing, and maintaining scalable Python applications.
You will work closely with cross-functional te...Show moreLast updated: 4 hours ago
- Promoted
Senior Python Developer
IntelliasDelhi, IN We seek a Senior Python Software Engineer to join our Recommendations team and bring new features to life, and support our products' move to modern architecture.
You will work closely with the produ...Show moreLast updated: 6 days ago
- Promoted
- New!
Senior Analyst
PCR Financial Aggregationfaridabad, haryana, in Operations - Enrollment Analyst.Who is Private Client Resources (PCR)?.PCR is a fast growing, dynamic, global FinTech company focused on changing the way wealthy families and their advisors view th...Show moreLast updated: 4 hours ago
- Promoted
Senior Data Analyst
HISH IT SERVICESGhaziabad, IN We’re looking for a Data Analytics Specialist (Power BI + Databricks) with 5+ years’ experience in Sales / Finance / Supply Chain domains.
We are seeking an experienced Data Analytics Specialist with st...Show moreLast updated: 4 days ago
- Promoted
- New!
Senior Data Analyst
Innover Digitalnarela, delhi, in Proven experience using Power BI, (Tableau or other reporting suites beneficial but not essential).Proficient in Power BI architecture, Power Query , DAX, Power BI Service, Power BI Desktop , and P...Show moreLast updated: 4 hours ago