Portfolio Analytics Architect
Lead end-to-end data validation for investment portfolios, building scalable analytics in Databricks and writing Python logic to detect anomalies. Requires 2+ years in tech/finance/consulting and hands-on experience with complex investment datasets.
About the job
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
Skills
Python, Spark, SQL, Databricks, ETL, REST APIs, Data Validation, Data Analytics, LLMs, AI Automation
Similar jobs
Data Analytics jobs
Check
United States
The Risk Analyst conducts company reviews, monitors payroll activity, investigates fraud, and analyzes emerging risk signals. The role requires 1–3 years of risk or fraud investigation experience, strong case-management and communication skills, and sound judgment in ambiguous situations.
Coinbase
New York, NY
Summer intern supporting payment fraud risk management through SQL analysis, dashboards, control evaluation, and actionable recommendations. Requires current study in a relevant field, hands-on SQL experience, and familiarity with dashboarding tools.
Coinbase
New York, NY
Supports People Analytics through employee-lifecycle analysis, dashboards, reporting automation, and executive insights. The internship requires analytical study, spreadsheet-based data analysis, clear communication, and responsible handling of confidential data.
Lyft
Nashville, TN
Investigates fraud, analyzes emerging patterns and false positives, and develops operational and analytical controls to reduce financial and reputational risk. The role requires a bachelor's degree, 1–2 years of fraud or risk monitoring experience, strong analytical judgment, and basic SQL knowledge.
Valon
New York, NY
Own end-to-end data analytics and infrastructure projects for SaaS customers, including migrations, reporting pipelines, dashboards, and business analysis. Requires 2–4+ years of analytics experience, expert SQL, dbt, BI tooling, and strong customer-facing skills.