Portfolio Analytics Architect
The Portfolio Analytics Architect leads end-to-end data validation for investment clients, using Python, Spark, and Databricks to automate data remediation and analytics. The role involves collaborating with internal teams and clients to ensure data accuracy and performance across complex multi-asset portfolios.
- Compensation
- $103K–$129K / yr
- Location
- Salt Lake City, UT
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 2+ years
- Category
- Architecture
- Posted
Skills
Must have
- B.S in Finance, Mathematics, Statistics, Business or Economics
- 2+ years experience working in Technology, Finance, or Consulting
- Hands-on experience working with complex investment datasets
- Proficiency in Python, Spark, and/or SQL
- Familiarity of ETL fundamentals
- Working knowledge of REST APIs
- Experience with Databricks and/or a cloud-based distributed data platform
- Excellent communication and presentation skills
Full 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 with clients for data conversion projects. The ideal candidate will have a strong understanding of financial portfolio data, a motivation to work on data problems, outstanding communication skills and the ability to deliver results in adherence with project deadlines while meeting high quality standards. They are passionate about understanding our clients needs, take a hands-on approach to solving problems, work collaboratively with internal teams and take ownership of our clients success.
Applicants must be legally authorized to work in the United States for any employer without requiring current or future visa sponsorship (for example, employment-based visas such as H-1B, F-1/OPT, or similar), and must be authorized to begin work in the U.S. on their first day of employment.
What You’ll Do
- Lead the data validation process end-to-end with the client and internal projects teams
- Develop scalable data analytics processes for validation in Databricks
- Write custom Python logic to detect large-scale data anomalies and automate remediation
- Facilitate recurring client sessions to track progress and steer the data validation project through to completion.
- Support clients with researching and identifying portfolio data performance discrepancies and make recommendations on how to best fix manual data issues
- Review, compare and document system calculation methodologies differences
- Coordinate across project teams communicating regular status updates for assigned data projects and while effectively setting expectations
- Mitigate project risks by effectively escalating key impediments to stakeholders and executive leadership.
- 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