Portfolio Analytics Architect

Overview

Lead end-to-end data validation for data conversion projects, working on financial portfolio data and building scalable, automated validation solutions.

What you'll do

• Develop scalable data analytics processes for validation in Databricks
• Write custom Python logic to detect large-scale data anomalies and automate remediation
• Build and maintain reusable validation tools, runbooks and documentation that scale across projects
• Prepare validation findings, discrepancy analysis and status materials that keep each data validation project on track through to completion
• Research and identify portfolio data performance discrepancies, determine root causes and recommend how best to fix manual data issues
• Review, compare and document system calculation methodologies differences
• Coordinate across global project teams and time zones, communicating regular status updates for assigned data projects while effectively setting expectations
• Mitigate project risks by effectively escalating key impediments to project leads and management
• Prioritize and context-switch effectively to complete simultaneous projects, seeing each through to the finish line
• Identify and implement AI-driven automation and LLM integrations to streamline implementation

What you'll need

• Bachelor's degree in Finance, Mathematics, Statistics, Engineering, Business, Economics or a related field
• 2+ years experience working in Technology, Finance, Consulting, fund accounting or investment operations
• Hands-on experience working with complex investment datasets, including multi-asset class portfolios, performance data, and market data from various sources
• Proficiency in Python, Spark, and/or SQL with familiarity of ETL fundamentals
• Working knowledge of REST APIs
• Experience with Databricks and/or a cloud-based distributed data platform
• Proven ability to research, design and implement solutions for complex problems
• Clear written and verbal communication skills, with the ability to document complex findings and work effectively with colleagues across time zones
• Able to work hours that regularly overlap with teams in the US and UK
• Independent, adaptable and able to thrive in a fast-paced environment
• Solution-oriented approach and a passion for problem solving
• Positive attitude, strong work ethic, proactive and a high contributing team player

Nice to have

• CFA or FRM progress

Details

• Location: Pune, India
• Applicants must have legal authorization to work in the country where this role is based on the first day of employment
• Visa sponsorship is not available for this position