Data Architect

ThoughtFocus; Bengaluru; On-site; INR 3,500,000 - 5,200,000; Full time

Job summary

ThoughtFocus is seeking an experienced fintech technologist to lead data-heavy implementations in Bengaluru. The role expects 10+ years handling data warehouses, BI dashboards, and integration through RESTful APIs into portfolio, order, and accounting systems.

Strong T-SQL, cloud warehouse experience, and familiarity with buy-side platforms are essential. The ideal candidate translates business requirements into robust technical designs, collaborates across teams, and supports on-call changes

Qualifications

• 10+ years in enterprise fintech implementations and data warehousing.
• Advanced T-SQL, stored procedures, functions and performance tuning.
• Experience integrating via RESTful APIs into complex apps.
• Familiar with portfolio management, order management or OOR systems.
• Proven BI reporting capability with Sigma/Power BI/Tableau.
• Experience with AI/ML deployment and data warehousing tools.
• Knowledge of Snowflake/Databricks/Redshift/Azure Synapse stacks.
• Degree in a relevant technical field (Bachelor/Master).
• Exposure to buy-side tech like Allvue/Black Mountain, Aladdin.
• Experience with Bloomberg/Refinitiv market data platforms.
• Ability to translate business needs into technical design and deliver end-to-end.

Skills

Financial technology

T-SQL

RESTful APIs

Technical design

On-call support

Education

Bachelor's degree in a relevant technical field

Master's degree in a relevant technical field

Tools

Sigma Computing

Power BI

Tableau

Snowflake

Databricks

Amazon Redshift

Azure Synapse

Arcesium Aquata

Bloomberg

Refinitiv

Allvue/Black Mountain

BlackRock Aladdin

Job description

• 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