Portfolio Analytics Architect (Investment Management)

Socket.dev; Salt Lake City (UT); On-site; USD 103,000 - 110,000; Full time

Job summary

Addepar is seeking a Portfolio Analytics Architect to lead end-to-end data validation for client projects, focusing on portfolio data accuracy and scalable analytics in Databricks.

The role requires hands-on data problem solving with Python, Spark, and SQL, plus strong communication to coordinate with internal teams and clients. You will drive AI-enabled automation ideas and ensure timely delivery of complex data initiatives.

Qualifications

• B.S in Finance, Mathematics, Statistics, Business or Economics.
• 2+ years experience in Technology, Finance or Consulting.
• Experience with complex investment datasets and multi-asset data.
• Proficiency in Python, Spark and/or SQL; ETL fundamentals.
• Working knowledge of REST APIs.
• Experience with Databricks or cloud-based data platforms.
• Strong communication and problem-solving skills.

Responsibilities

• Lead the data validation end-to-end with the client and internal project teams.
• Develop scalable data analytics processes for validation in Databricks.
• Write custom Python logic to detect 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 fix issues.
• Review, compare and document system calculation methodologies differences.
• Coordinate across project teams with regular status updates and set expectations.
• Mitigate project risks by escalating impediments to stakeholders and leadership.
• Prioritize and context-switch to complete multiple projects and see them through.
• Identify and implement AI-driven automation and LLM integrations to streamline implementation.

Skills

Python

Spark

SQL

REST APIs

ETL fundamentals

Communication

Problem solving

Education

Bachelor's degree in Finance, Mathematics, Statistics, Business or Economics

Tools

Databricks

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,400 firms in nearly 60 countries use Addepar to manage and advise on nearly $9 trillion in assets. Its open platform integrates with nearly 650 software, data and consulting partners to power end-to-end investment operations across firms of all sizes and complexity. Addepar supports clients worldwide with offices in New York City, Salt Lake City, London, Edinburgh, Pune, Dubai, Geneva, Singapore and São Paulo.

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.

Addepar takes a market-based approach to pay. A successful candidate’s starting pay will be determined based on the role, job-related skills, experience, qualifications, work location, and market conditions.

The range displayed on each job posting reflects the minimum and maximum target base salary for roles in Colorado, California, and New York. The current range for this role is $103,000 - $110,000 (base salary) + bonus + equity + benefits.

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

Who You Are

• 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, 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
• Excellent communication and presentation skills, with proficiency in handling client objections

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.