Data Center Architect

ThoughtFocus; Bengaluru; Hybrid; INR 4,000,000 - 7,000,000; Full time

Job summary

ThoughtFocus is seeking a senior Data Management & Reporting expert to join the Bengaluru hybrid team. You’ll design and extend data warehouses, enabling LLM-driven automation and scalable data solutions for capital markets.

You will work with portfolio managers, traders, and finance professionals to translate business needs into robust data architectures, dashboards, and automated pipelines, following strong SDLC practices.

Qualifications

• 10+ years of hands-on enterprise financial technology implementations.
• Experience with financial data warehouses and data integrations.
• Proficient in MS T-SQL with performance optimization.
• Experience integrating applications via RESTful APIs.
• Experience with Portfolio Management, Order Management, or Investment Book of Record systems.
• Proven ability to develop dashboards and reports using BI tools (Sigma/Power BI/Tableau).
• Familiarity with Snowflake, Databricks, Redshift, or Synapse.
• Bachelor’s or Master’s in a relevant technical field.
• Knowledge of buy-side financial services technologies and investment lifecycle.

Responsibilities

• Design and extend data warehouses, incorporating LLMs, ML automation, and unstructured data integration.
• Implement and integrate enterprise software solutions (risk, accounting, investment pipelines).
• Leverage APIs to load and extract data from third-party platforms.
• Develop data analysis and ad hoc reporting packs for front-, middle-, and back-office stakeholders.
• Uphold SDLC practices with automated testing and regression management.
• Collaborate with business users to gather requirements and deliver data-driven solutions.

Skills

Data engineering

Financial technology knowledge

Problem solving

Communication

Education

Bachelor’s or Master’s degree in a relevant technical field

Tools

MS T-SQL

REST APIs

Power BI

Snowflake

Databricks

Azure Synapse

Sigma Computing

Tableau

Job description

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 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