About ThoughtFocus

ThoughtFocus is a global IT services and solutions company with deep capabilities across Data & Analytics, Cloud, Modern Engineering, and Financial Services technology. Headquartered in the US with delivery centers in India, we partner with leading enterprises to build scalable, future-ready technology solutions. Our teams are built on a culture of ownership, expertise, and long-term client partnerships — and talent is at the heart of how we grow. - https://thoughtfocus.com/

Work Location: Bangalore

Work Model: Hybrid

Experience: 10+ Years

Domain: Capital Markets | Financial Technology | Data Engineering

RESPONSIBILITIES

Data Management & Reporting

Design and extend capabilities for the client data warehouses, incorporating Large Language Models (LLMs), machine learning automation, and unstructured data integration
Implement and integrate enterprise software solutions, including risk, accounting, and investment pipeline systems
Leverage APIs and web services to load and extract data from third-party platforms
Develop data analysis and ad hoc reporting packs for front-office and middle-office stakeholders

Product Implementation & Development

Collaborate with business users—including portfolio managers, traders, operations, analysts, and finance and compliance professionals—to gather technical requirements and deliver solutions using Python, SQL, and vendor dashboarding tools
Serve as principal technical business analyst and developer on one or more core system implementations
Manage multiple simultaneous large-scale projects, including SaaS implementations, workflow automation, and data warehousing initiatives
Uphold a high standard of SDLC practices, with a focus on automated testing and regression management
Contribute to and align with the overall vision and culture of the technology team

Operations

Provide L2 support for provisioned applications
Ensure the operational stability of data pipelines and reporting infrastructure
Automate routine operational tasks using PowerShell, Power Automate, Power BI, and other tooling
Maintain robust systems documentation

Technology

Stay current with technical best practices and emerging tools
Execute Major Incident and Crisis Management processes during unexpected issues
Support additional core technology projects as needed

QUALIFICATIONS

10+ years of hands-on experience in enterprise financial technology implementations, including financial data warehouses, custom workflow and reporting development, and data integrations—ideally within the private credit domain
Advanced proficiency in MS T-SQL, including stored procedures, functions, and performance/query optimization
Experience integrating complex applications via RESTful APIs
Experience implementing or configuring Portfolio Management, Order Management, or Investment Book of Record accounting systems
Proven ability to develop business-facing dashboards and reports using BI technologies such as Sigma Computing, Power BI, or Tableau
Experience configuring and deploying LLMs and AI/ML technologies preferred
Advanced knowledge of data warehouse platforms (e.g., Snowflake, Databricks, Amazon Redshift, Azure Synapse) and associated tooling preferred
Bachelor's or Master's degree in a relevant technical field
Strong knowledge of buy-side financial services technologies, including trading and portfolio management systems (e.g., Allvue/Black Mountain, BlackRock Aladdin)
Familiarity with alternative asset classes (credit, private equity) and the investment lifecycle
Experience with market data platforms such as Bloomberg, S&P Markit, or Refinitiv
Knowledge of Arcesium Aquata or similar data warehouse platforms preferred
Demonstrated ability to translate business requirements into technical design and deliver end-to-end, from development through user testing and adoption
Excellent problem-solving skills with the ability to prioritize multiple time-sensitive projects simultaneously
Strong verbal and written communication skills; customer-service-oriented mindset
Availability for on-call support outside standard hours for scheduled changes, emergency incident management, and escalated requests

Skills

capital markets domaindata engineering

Data Center Architect