Bristlecone is Hiring Specialist - Data Engineering & Analysis | Noida/Delhi NCR

Job Description

There's a title-vs-content mismatch worth flagging before anything else: the role is titled "Specialist" — a title that often implies mid-level experience — but the listing includes no explicit years-of-experience requirement anywhere, and the qualifications section (problem-solving with "minimal supervision," stakeholder management with senior leadership) reads like a role expecting genuine independent ownership rather than close guidance. Also worth noting: the job header lists the location as Noida, but the "Locations" field further down states Delhi (NCR) — a minor but real inconsistency worth confirming directly before applying, similar to location mismatches seen on a few other listings.

Bristlecone operates in supply chain technology consulting — a part of the Mahindra Group, ranked among Gartner's top ten supply chain services providers — meaning this data role would apply analytics and dashboarding skills specifically to logistics, procurement, and manufacturing data rather than generic business analytics. For candidates interested in the supply chain/operations domain specifically, this is a more specialized and less commonly available data analytics entry point than typical fintech or e-commerce analytics roles.

The role's real technical center is the combination of SQL, Python automation, and dashboard tooling (Tableau/Power BI) working together — not any one skill in isolation. The listing explicitly wants candidates who can write advanced SQL (window functions, stored procedures), build Python automation for repetitive reporting tasks, and then present findings through dashboards — this three-part combination (query, automate, visualize) is a genuinely complete data analyst skill set, and notably more demanding than roles asking for just one or two of these pieces.

𝐎𝐮𝐫 𝐓𝐚𝐤𝐞:

- 𝐆𝐨𝐨𝐝 𝐟𝐨𝐫: candidates with genuinely strong SQL (beyond basic SELECT statements — window functions and stored procedures specifically) plus Python automation experience, interested in supply chain/operations data specifically

- 𝐍𝐨𝐭 𝐢𝐝𝐞𝐚𝐥 𝐟𝐨𝐫: those with only basic SQL/dashboarding skills — the "advanced querying" and "automation scripting" requirements suggest a real technical bar despite no explicit experience number stated

- 𝐒𝐞𝐥𝐞𝐜𝐭𝐢𝐨𝐧 𝐝𝐢𝐟𝐟𝐢𝐜𝐮𝐥𝐭𝐲: moderate-to-high given the breadth of required technical depth (advanced SQL + Python automation + AWS Redshift + dashboarding) — this combination is uncommon among true freshers, so relevant internship or strong project experience would meaningfully help

- 𝐂𝐚𝐫𝐞𝐞𝐫 𝐭𝐫𝐚𝐣𝐞𝐜𝐭𝐨𝐫𝐲: commonly leads into Senior Data Analyst, Analytics Engineer, or BI Lead roles, with supply chain domain expertise being a valuable specialization for future roles at logistics, manufacturing, or procurement-focused companies

𝐂𝐨𝐦𝐩𝐞𝐧𝐬𝐚𝐭𝐢𝐨𝐧 𝐂𝐨𝐧𝐭𝐞𝐱𝐭: Bristlecone hasn't disclosed pay for this role. Data Analytics/Data Engineering specialist roles at supply chain-focused IT consulting firms in Delhi NCR typically range around ₹5–8 LPA depending on actual experience level, based on general market data for comparable analytics roles at mid-to-large consulting firms — this is a broad estimate given the ambiguity around whether this role is truly fresher-accessible or expects some prior experience.

𝐀𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐒𝐭𝐫𝐚𝐭𝐞𝐠𝐲: Given the emphasis on AWS Redshift and stored procedures specifically (rather than generic "SQL knowledge"), if you have any academic or personal project involving cloud data warehousing or writing stored procedures, highlight it explicitly — this is more specialized than typical fresher SQL exposure, and demonstrating it directly addresses the listing's specific technical requirements rather than general database familiarity.

Roles & Responsibilities

The responsibilities span the full analytics workflow — from raw data querying through automation to final stakeholder-facing dashboards — meaning this role isn't narrowly focused on just one part of the pipeline.

- Design, develop, and maintain interactive dashboards and reports using Tableau or similar tools

- Write complex SQL queries to extract, transform, and validate data from databases and warehouses

- Develop Python-based automation scripts for repetitive reporting, processing, and reconciliation tasks

- Track analytics tasks, sprints, and documentation using JIRA and Confluence

- Identify trends, patterns, and anomalies in large datasets, presenting findings to technical and non-technical audiences

Qualifications & Eligibility

No explicit degree or years-of-experience requirement is stated in this posting — eligibility is framed entirely around demonstrated skill and working style rather than formal credentials.

- Ability to solve complex business problems with minimal supervision

- Proven stakeholder communication ability across leadership, product, and operations audiences

- Strong written and verbal communication with an ownership-driven mindset

- Comfort working in fast-paced, agile environments managing multiple priorities

Skills Required

All listed as "must-have," reflecting a genuinely full-stack data analytics skill set rather than a narrow specialization.

- Advanced SQL: complex querying, joins, window functions, stored procedures

- Python (Pandas, NumPy) with Git, for automation scripting and data wrangling

- AWS Redshift: data warehousing, cluster management, query optimization

- Automation: scripted pipelines, scheduled jobs, ETL automation

- Tableau/Power BI: dashboard design, KPI tracking, report publishing

- Confluence for documentation