This job offer is not available in your country.
ShepHertz - Senior Data Analyst - Python / SQL / ETL
SHEPHERTZ TECHNOLOGIES PRIVATE LIMITEDDelhi, IN7 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
- Promoted
Data Analyst - Python / SQL
PLEXO HR SolutionsGhaziabad, IN Seeking experienced Data Analyst to join our analytics team! Work with cutting-edge tools and technologies.Perfect opportunity for data enthusiasts to make strategic impact through insights and ana...Show moreLast updated: 2 days ago
- Promoted
Senior Analyst-Enterprise SaaS
Mercados Energy Markets IndiaDelhi, India, India We are seeking a highly skilled and experienced ‘Senior Analyst-Enterprise SaaS’ to join our team, specializing in the Indian power sector.
The ideal candidate will have a robust background in optim...Show moreLast updated: 30+ days ago
- Promoted
Senior Data Analyst / Engineer
Milestone Technologies, Inc.Ghaziabad, IN This role will ensure data ingested from manufacturing systems into Client's data lake and downstream applications (e.The successful candidate will work directly with.
Identify gaps, missing values,...Show moreLast updated: 4 days ago
- Promoted
Senior Data Engineer
Manuh TechnologiesGhaziabad, IN Strong proficiency in Python programming (Pandas, NumPy, PySpark, or similar).Hands-on experience with Dask for large-scale distributed data processing.
Proven expertise as a Data Modeler (conceptua...Show moreLast updated: 30+ days ago
- Promoted
Senior Data Engineer
Deltacubesdelhi, delhi, in Build and maintain scalable ETL / ELT pipelines.Work with Snowflake and BigQuery for data storage.Implement orchestration with Airflow or Prefect.
Integrate data workflows with Python.Optimize data pi...Show moreLast updated: 12 days ago
- Promoted
Senior Data Engineer
EXLfaridabad, haryana, in We are seeking a highly skilled.You will work closely with cross-functional teams to provide thought leadership deliver robust, secure, and high-performance data solutions that empower analytics an...Show moreLast updated: 22 days ago
- Promoted
Senior Manager - Data Engineering Lead
DIAGEO Indianarela, delhi, in Senior Manager - Data Engineering Lead.Bachelor’s or master’s degree in computer science, Data Engineering, or related field.
Experience in data engineering.Proven experience in cloud platforms (AWS...Show moreLast updated: 23 days ago
- Promoted
Data Analyst
Smart Moves Consultantsnarela, delhi, in We are looking for a Content Automation Specialist with strong Python and Data Engineering skills to help streamline and scale our content operations.
This role focuses on automating workflows, mana...Show moreLast updated: 2 days ago
- Promoted
ETL LEAD with IBM DataStage experienced
IntraEdgeDelhi, IN ETL Developer – DataStage, AWS, Snowflake.We are looking for a talented and motivated ETL Developer / Senior Developer.You will work on building scalable and efficient data pipelines using.IBM Data...Show moreLast updated: 30+ days ago
- Promoted
Senior Data Analyst - Python / SQL / ETL
Delphie Consulting servicesDelhi Role Overview : We are looking for a Senior Data Analyst with strong computer science fundamentals and expertise in SQL,...Show moreLast updated: 17 days ago
- Promoted
Senior Data Engineer
CoreTek Labsfaridabad, haryana, in We’re Hiring for Top MNC –Senior Data Engineer! 📢.Notice Period : immediate to October joiners.Skill : Python, Pandas, Snowflake, SQL & Pytest(senior Data Engineer).
Do not go for data bricks or dat...Show moreLast updated: 3 days ago
- Promoted
Senior Data Analyst
Elife TransferGhaziabad, IN At Hoppa & Elife, we’re unifying all ground transportation into one powerful marketplace, giving travellers the freedom to book airport transfers, ride-hailing, shared shuttles, private cars, and t...Show moreLast updated: 5 days ago
- Promoted
Senior Analyst E-Commerce
NuvoRetailDwarka, Delhi, India Position : Senior Analyst -E-Commerce.Please Note : Only Candidates with 0.We are only looking for candidates who have worked in E-Commerce Agencies.
This is a Delhi-based position and work from offic...Show moreLast updated: 30+ days ago
- Promoted
Senior Data Engineer
Straivefaridabad, haryana, in The ideal candidate is a strong software engineer with hands-on experience in Spark (3.You'll be responsible for designing and implementing ETL / ELT solutions, collaborating with teams to deliver da...Show moreLast updated: 1 day ago
- Promoted
Senior Data Engineer
Otomeyt AInarela, delhi, in We are seeking a highly skilled 7+.The ideal candidate will have strong technical expertise in Azure, Data Engineering tools, and advanced ETL design along with excellent communication and problem-...Show moreLast updated: 15 days ago
- Promoted
Senior Data Engineer
Prudent Technologies and Consulting, Inc.faridabad, haryana, in Snowflake Instance Management : Set up, configure, and manage between three to four new Snowflake data warehouse instances per quarter, tailored to support emerging products and analytics requiremen...Show moreLast updated: 30+ days ago
- Promoted
Senior Data Engineer
Tredence Inc.gurgaon, haryana, in Design, build, and maintain scalable data pipelines using DBT and Airflow.Develop and optimize SQL queries and data models in Snowflake.
Implement ETL / ELT workflows, ensuring data quality, performan...Show moreLast updated: 28 days ago
- Promoted
Senior Data Engineer
SAIVA AIGhaziabad, 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: 4 days ago