Data & Business Intelligence Engineer Ahmedabad (India)

Data & Business Intelligence Engineer – Investment Technology India (Remote) Full time Permanent Venture Capital / Investment Tech Placed by Hotsourced – connecting top Indian talent with world-class global companies Our client is a venture capital firm that has built a proprietary data infrastructure — a custom Airtable-based CRM feeding into a BigQuery data warehouse — to track deal flow, portfolio performance, and investment decisions. The core engineering foundation is already in place; this role is about operating, extending, and unlocking insight from that system, working closely with a non-technical investment team. This is a high-autonomy, high-trust role. You'll be the primary point of contact translating ambiguous business questions from investment professionals into accurate, reconciled answers — while also identifying prospects to enrich and improve the underlying data using AI and automation. Company Overview Our client is a venture capital firm modernizing how deals are sourced, tracked, and evaluated. Their data stack — Airtable as the CRM/source of truth, BigQuery as the data warehouse, with lightweight automation layered on top — supports an investment team that needs fast, accurate answers to questions about their deal pipeline and portfolio. Role Overview As Data & BI Engineer, you'll own the day-to-day health and usability of an existing Airtable → BigQuery data pipeline. The majority of your work will involve writing and reasoning about SQL queries against BigQuery, reconciling data discrepancies, and translating ambiguous requests from non-technical stakeholders into accurate, correct answers. A smaller but growing part of the role involves using AI/automation to enrich data where high-quality external datasets (e.g., Crunchbase, PitchBook) aren't practically accessible. This is not a greenfield \"build everything from scratch\" engineering role — the core pipeline architecture already exists. Success looks like: stakeholders get acc