Portfolio Analytics Architect

Addepar1; Pune District; On-site; INR 1,500,000 - 2,800,000; Full time

Job summary

Addepar seeks a Portfolio Analytics Architect in Pune to lead end-to-end data validation for portfolio data conversion projects and build scalable analytics in Databricks using Python, Spark and SQL. You will collaborate across regions to deliver high-quality results on tight deadlines.

The role requires hands-on data experience with multi-asset portfolios, strong communication skills, and a proactive, problem-solving mindset in a fast-paced environment.

Qualifications

• Bachelor's degree in Finance, Mathematics, Statistics, Engineering, Business, Economics or related field; CFA or FRM progress is a plus.
• 2+ years experience in Technology, Finance, Consulting, fund accounting or investment operations.
• Hands-on experience 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.

Responsibilities

• 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

Skills

Python

Spark

SQL

REST APIs

Databricks

Cloud-based data platform

Education

Bachelor’s degree in Finance, Mathematics, Statistics, Engineering, Business, Economics or related field

CFA or FRM progress

Tools

ETL fundamentals

Job description

Who We Are

Addepar is a global data and AI platform empowering investment professionals to turn complex financial information into actionable intelligence. Addepar unifies portfolio, market and client data in a total portfolio view and delivers AI-powered insights within investment and client workflows. More than 1,500 firms in 60 countries use Addepar to manage and advise on nearly $10 trillion in assets. Its open platform integrates with 650 software, data and consulting partners to power end-to-end investment operations across firms of all sizes and levels of complexity. Addepar supports clients worldwide with offices in New York City, Salt Lake City, São Paulo, London, Edinburgh, Geneva, Warsaw, Dubai, Pune and Singapore.

The Role

A Portfolio Analytics Architect is responsible for leading the data validation process end-to-end for data conversion projects. The ideal candidate will have a strong understanding of financial portfolio data, a motivation to work on data problems, strong analytical and communication skills and the ability to deliver results in adherence with project deadlines while meeting high quality standards. They take a hands‑on approach to solving problems, build scalable and automated solutions, work collaboratively with project teams across regions and take ownership of the outcomes our clients depend on. 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.

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

Who You Are

• Bachelor’s degree in Finance, Mathematics, Statistics, Engineering, Business, Economics or a related field; CFA or FRM progress is a plus


• 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


• Solution-oriented approach and a passion for problem solving


• Proven ability to research, design and implement solutions for complex problems


• Positive attitude, strong work ethic, proactive and a high contributing team player


• Independent, adaptable and can thrive in a fast-paced environment


• 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

Our Values

• Act Like an Owner - Think and operate with intention, purpose and care. Own outcomes.


• Build Together - Collaborate to unlock the best solutions. Deliver lasting value.


• Champion Our Clients - Exceed client expectations. Our clients’ success is our success.


• Drive Innovation - Be bold and unconstrained in problem solving. Transform the industry.


• Embrace Learning - Engage our community to broaden our perspective. Bring a growth mindset.

In addition to our core values, Addepar is proud to be an equal opportunity employer. We seek to bring together diverse ideas, experiences, skill sets, perspectives, backgrounds and identities to drive innovative solutions. We commit to promoting a welcoming environment where inclusion and belonging are held as a shared responsibility. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.