We are seeking a detail-oriented and analytical Portfolio Analytics Architect to lead data validation initiatives and ensure the accuracy and reliability of complex financial portfolio data. In this role, you will manage end-to-end data validation processes for conversion projects, developing scalable analytics solutions and automated tools to identify discrepancies and improve data quality. You will work extensively with multi-asset investment datasets, leveraging Python, SQL, Spark, and cloud-based data platforms to investigate anomalies and deliver actionable insights. Collaborating with international project teams, you will help resolve complex data challenges while ensuring projects meet deadlines and quality standards. You will also explore AI-driven automation and large language model (LLM) integrations to streamline workflows and improve operational efficiency. This is an exciting opportunity to combine financial data expertise, technology, and problem-solving in a fast-paced, globally collaborative environment.

Lead and manage end-to-end data validation activities for financial data conversion projects, ensuring accuracy, consistency, and compliance with established quality standards.

Develop scalable data analytics and validation processes using Databricks to support complex financial datasets and multiple concurrent projects.

Design and implement custom Python solutions to detect large-scale data anomalies, automate data checks, and support remediation activities.

Prepare detailed validation findings, discrepancy analyses, progress reports, and project status materials to ensure effective monitoring and timely project completion.

Investigate portfolio data performance discrepancies, identify underlying causes, and recommend appropriate solutions to resolve manual data issues.

Review, compare, and document differences in financial system calculation methodologies to ensure consistency and accuracy across platforms.

Work with complex investment datasets, including multi-asset portfolios, investment performance information,



and market data from multiple sources.

Collaborate with global project teams across different regions and time zones, providing regular updates and maintaining clear expectations regarding project progress and deliverables.

Identify potential project risks, communicate critical blockers, and escalate significant issues to project leads and management when necessary.

Manage competing priorities and multiple projects simultaneously, ensuring timely delivery and maintaining high standards of accuracy.

Identify and implement opportunities for AI-powered automation and LLM integrations to improve data validation processes and streamline project implementation.

Take ownership of assigned deliverables, proactively address technical challenges, and contribute to continuous improvements in data analytics practices.

Bachelor's degree in Finance, Mathematics, Statistics, Engineering, Business, Economics, or a related discipline. Progress toward CFA or FRM certification is an advantage.

At least 2 years of professional experience in technology, finance, consulting, fund accounting, investment operations, or a related field.

Hands-on experience working with complex investment datasets, including multi-asset class portfolios, financial performance data, and market data from various sources.

Robust programming skills in Python, Spark, and/or SQL, with a solid understanding of data processing and ETL fundamentals.

Practical experience with Databricks or other cloud-based distributed data platforms.

Working knowledge of REST APIs and their application in data integration and processing workflows.

Strong understanding of data validation, reconciliation, discrepancy analysis,



and financial data quality management.

Strong organizational and time management skills, with the ability to manage multiple projects and adapt to changing priorities in a fast-paced environment.

Willingness to work the UK-aligned shift schedule of 2:30 PM to 11:30 PM IST.

Legal authorization to work in India from the first day of employment. Ability to work from Pune or willingness to relocate to Pune, as required by the role.

International Collaboration: Work with global project teams and colleagues across multiple regions and time zones.

Professional Development: Expand your expertise in financial analytics, investment data, Python, Spark, SQL, and cloud-based data technologies.

Technology and Innovation: Gain exposure to advanced data platforms, AI-driven automation, and emerging LLM applications.

Career Growth: Develop your technical and analytical capabilities through challenging projects involving complex financial datasets.

Take ownership of end-to-end data validation initiatives and contribute directly to important client deliverables.

Contribute ideas, explore new approaches, and help improve data processes and operational efficiency.

Client Impact: Play a key role in ensuring reliable financial information and helping investment professionals make better-informed decisions.

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. If you would like more information about how your data is processed, please contact us.

📌 SQL Server Architect (India)
🏢 Jobgether
📍 India