About the role
This role is foundational to building out our India-based data operations function. While you will start as a senior individual contributor, there is a clear path to growing and leading a team of 3-5 analysts as we scale.
Reconciliation & Validation
- Compare outputs from dbt borrowing base pipelines against counterparty reports to identify discrepancies in loan-level data, collateral values, and portfolio metrics
- Investigate and document the root cause of variances, distinguishing between data quality issues, pipeline logic errors, and legitimate counterparty differences
- Develop and maintain reconciliation checklists and validation procedures for each borrowing base facility
- Resolve straightforward data issues independently, including minor data corrections and known edge cases
- For complex issues, prepare detailed documentation of findings and escalate to Analytics Engineers with clear context and recommendations
- Over time, contribute minor fixes and pull requests to dbt models as you develop deeper pipeline familiarity
- Monitor dbt pipeline runs and flag failures or anomalies to the appropriate team members
- Triage pipeline errors by reviewing logs and test failures, providing initial diagnosis before escalation
- Maintain clear records of reconciliation results, discrepancy resolutions, and recurring issues
- Communicate findings to Analytics Engineers, Operations, and other stakeholders in a clear, structured manner
- Coordinate with external counterparties as needed to resolve data-related questions
RequirementsWhat we are looking for:
- 4+ years of experience in data analysis, data quality, reconciliation, or a related role
- Advanced SQL skills with experience querying complex data sets and troubleshooting data issues
- Experience working with financial data sets (lending, FinTech, financial services, or related industries)
- Strong analytical and problem-solving skills with keen attention to detail
- Excellent written and verbal communication skills, with the ability to document findings clearly and explain technical issues to non-technical stakeholders
- Self-directed with the ability to work independently and manage priorities across multiple facilities
- Familiarity with dbt (Data Build Tool) or willingness to learn quickly
- Experience with Snowflake or similar cloud data warehouses
- Exposure to Git workflows and version control basics
- Understanding of borrowing base mechanics, collateral management, or warehouse lending
- Python proficiency (Pandas or similar) for ad-hoc analysis
- Experience in a reconciliation, audit, or data quality assurance function