Senior Data Engineer - Capital Market Domain
First seen by Alion on Oct 28, 2026.
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.
Work Location : Bangalore.
Work Model : Hybrid.
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
Data Management, Data Engineering, Data Warehousing, Data Integration, T-SQL, Power BI, Tableau, LLM, Snowflake DB