• Collaborate closely with internal technical teams to deliver multiple data initiatives simultaneously. • Design, develop, and optimize scalable data solutions using Python, Snowflake, and SQL. • Review and maintain high-quality code developed by offshore engineering teams. • Lead technical discussions and translate business requirements into scalable technical solutions. • Work directly with Business and IT stakeholders to gather, refine, and validate requirements. • Build data solutions independently whenever rapid execution is required. • Monitor project progress, identify risks proactively, and communicate updates to leadership. • Ensure project deliverables meet quality, performance, and timeline expectations. • Provide technical guidance and mentor team members to achieve successful project outcomes.

Job Title: Data Engineer About Us “Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery. WHY JOIN CAPCO? You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry. MAKE AN IMPACT Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services. #BEYOURSELFATWORK Capco has a tolerant, open culture that values diversity, inclusivity, and creativity. CAREER ADVANCEMENT With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands. DIVERSITY & INCLUSION We believe that diversity of people and perspective gives us a competitive advantage. MAKE AN IMPACT Role Description Experience : 10-12 Years Job Location : Bangalore/Pune/Hyderabad Notice Period: 0 - 30 days JD: Role : - Key Responsibilities · Design, build, and maintain scalable cloud-native data pipelines for trade lifecycle data processing. · Develop and optimize ETL/ELT workflows for ingesting, transforming, and loading high-volume financial datasets. · Create and maintain robust data models and schema designs aligned to trade lifecycle (front-to-back processing). · Onboard and integrate DTCC data sources, including RTTM and Settlement Web, into a Unified Trade Record (UTR) schema. · Design and implement ingestion frameworks using messaging systems (MQ) and API-based data extraction. · Process and normalize financial messages, including ISO 15022 formats. · Populate and maintain Trade Exceptions databases, ensuring accuracy and consistency of exception workflows. · Collaborate with business stakeholders (operations, reconciliation, settlements teams) to align data structures with business processes. · Optimize SQL Server queries, indexing strategies, and database performance. · Work with AWS cloud-native data services (e.g., S3, EKS (Kubernetes/Docker), RDS) for scalable data solutions. · Ensure data quality, lineage, governance, and observability across pipelines. · Troubleshoot complex data issues and provide analytical insights into trade discrepancies and exceptions. Required Skills & Qualifications · 10+ years of experience in data engineering, with a strong focus on capital markets. · Deep understanding of trade lifecycle (execution, clearing, settlement, reconciliation). · Strong experience with ETL/ELT frameworks and large-scale data processing. · Expertise in data modeling and schema design, particularly for trade and transaction data. · Hands-on experience with DTCC data sources, especially RTTM and Settlement Web. · Strong knowledge of ISO 15022 message formats and financial data standards. · Experience building ingestion frameworks using MQ (e.g., IBM MQ, Kafka) and REST APIs. · Advanced SQL skills with strong experience in SQL Server (performance tuning, indexing, stored procedures). · Experience with AWS cloud-native data platforms and services. · Strong analytical, debugging, and problem-solving skills. Preferred Qualifications · Experience with unified data models such as Unified Trade Record (UTR) and Schema development and Trade Exceptions management experience. · Familiarity with data governance, lineage, and cataloging tools. · Experience with real-time or near-real-time data processing frameworks. · Knowledge of regulatory reporting and compliance requirements in capital markets. · Knowing FIX messages and processing FxML messages will be an add-on experience. · Prior consulting or client-facing experience. Soft Skills · Excellent communication and stakeholder management skills. · Strong attention to detail and data accuracy. · Ability to work independently and in collaborative environments. · Proactive approach to problem-solving and continuous improvement. If you are keen to join us, you will be part of an organization that values your contributions, recognizes your potential, and provides ample opportunities for growth. For more information, visit www.capco.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube.

Job Title: Data Engineer About Us “Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery. WHY JOIN CAPCO? You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry. MAKE AN IMPACT Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services. #BEYOURSELFATWORK Capco has a tolerant, open culture that values diversity, inclusivity, and creativity. CAREER ADVANCEMENT With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands. DIVERSITY & INCLUSION We believe that diversity of people and perspective gives us a competitive advantage. MAKE AN IMPACT Role Description Experience : 5-8 Years Job Location : Bangalore/Pune/Hyderabad Notice Period: 0 - 30 days JD: Role : - Key Responsibilities · Design, build, and maintain scalable cloud-native data pipelines for trade lifecycle data processing. · Develop and optimize ETL/ELT workflows for ingesting, transforming, and loading high-volume financial datasets. · Create and maintain robust data models and schema designs aligned to trade lifecycle (front-to-back processing). · Onboard and integrate DTCC data sources, including RTTM and Settlement Web, into a Unified Trade Record (UTR) schema. · Design and implement ingestion frameworks using messaging systems (MQ) and API-based data extraction. · Process and normalize financial messages, including ISO 15022 formats. · Populate and maintain Trade Exceptions databases, ensuring accuracy and consistency of exception workflows. · Collaborate with business stakeholders (operations, reconciliation, settlements teams) to align data structures with business processes. · Optimize SQL Server queries, indexing strategies, and database performance. · Work with AWS cloud-native data services (e.g., S3, EKS (Kubernetes/Docker), RDS) for scalable data solutions. · Ensure data quality, lineage, governance, and observability across pipelines. · Troubleshoot complex data issues and provide analytical insights into trade discrepancies and exceptions. Required Skills & Qualifications · 10+ years of experience in data engineering, with a strong focus on capital markets. · Deep understanding of trade lifecycle (execution, clearing, settlement, reconciliation). · Strong experience with ETL/ELT frameworks and large-scale data processing. · Expertise in data modeling and schema design, particularly for trade and transaction data. · Hands-on experience with DTCC data sources, especially RTTM and Settlement Web. · Strong knowledge of ISO 15022 message formats and financial data standards. · Experience building ingestion frameworks using MQ (e.g., IBM MQ, Kafka) and REST APIs. · Advanced SQL skills with strong experience in SQL Server (performance tuning, indexing, stored procedures). · Experience with AWS cloud-native data platforms and services. · Strong analytical, debugging, and problem-solving skills. Preferred Qualifications · Experience with unified data models such as Unified Trade Record (UTR) and Schema development and Trade Exceptions management experience. · Familiarity with data governance, lineage, and cataloging tools. · Experience with real-time or near-real-time data processing frameworks. · Knowledge of regulatory reporting and compliance requirements in capital markets. · Knowing FIX messages and processing FxML messages will be an add-on experience. · Prior consulting or client-facing experience. Soft Skills · Excellent communication and stakeholder management skills. · Strong attention to detail and data accuracy. · Ability to work independently and in collaborative environments. · Proactive approach to problem-solving and continuous improvement. If you are keen to join us, you will be part of an organization that values your contributions, recognizes your potential, and provides ample opportunities for growth. For more information, visit www.capco.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube.

Role Description As a Senior Software Engineer specializing in Python and the Data Ecosystem , you'll be a core contributor owning and evolving critical parts of ClickHouse's data engineering ecosystem. This role sits at the intersection of high-performance database engineering and developer experience. You'll craft tools that enable Data Engineers and Data Scientists to harness ClickHouse's speed and scale in the frameworks they already use. We're looking for someone who has lived the Data Engineer or Data Scientist experience firsthand. The data practitioner's world is shifting rapidly: - Databases are no longer just query targets. - They are becoming active participants in AI-powered workflows. - They serve as vector stores for RAG pipelines, backends for LLM-powered agents, and real-time feature stores for ML inference. You understand these workflows not from the outside, but because you've operated within them. You don't just build integrations; you bring product-level insight into what we should build and why. You'll own the full lifecycle of key Python integrations, driving architecture, performance, and feature direction across: - Orchestration Platforms: Apache Airflow, Dagster, Prefect - Transformation Tools: dbt, SQLMesh - AI & LLM Ecosystem: LangChain, LlamaIndex, n8n, and broader AI tooling. Your job is to make ClickHouse's potential real by building the robust, production-ready connectors that make ClickHouse the natural choice when data practitioners design their next-generation AI and data systems. What you'll do: - Own and evolve ClickHouse's Python connector and SDK ecosystem, raising the bar on performance, reliability, and API design. - Build and maintain integrations with orchestration platforms (Airflow, Dagster, Prefect) and transformation tools (dbt) to enterprise-grade quality standards. - Drive the AI/LLM integration strategy: designing connectors and patterns that make ClickHouse a natural fit in RAG architectures, ML feature pipelines, and LLM-powered data applications. - Engage actively with the open-source community: triage issues, support contributors, advocate for users, and shape the roadmap based on real-world feedback. - Collaborate with Product, Cloud, and other engineering teams to align integration work with broader platform priorities. - Bring a practitioner's perspective to roadmap decisions, grounding prioritization in genuine Data Engineer and Data Scientist workflows. Qualifications - 7+ years of software development experience, including hands-on time as a Data Engineer, Data Scientist, or ML Engineer. - Deep, proven experience designing, building, and maintaining production-grade Python connectors, SDKs, or integrations for at least one major platform (orchestration, BI, MLOps, or data transformation). - Hands-on experience applying AI/ML in production data-engineering contexts: embedding generation, vector search, feature pipelines, or LLM-powered tooling that shipped and ran in production. - Solid experience with the Python data ecosystem: Pandas, NumPy, Pydantic, and related libraries. - Strong database fundamentals: SQL, data modeling, query optimization, and familiarity with OLAP/analytical databases. - Solid experience with concurrent Python: threading, multiprocessing, and async patterns. - Outstanding written and verbal communication; comfortable collaborating across engineering functions and with open-source communities. Requirements - Prior experience as a Data Engineer or Data Scientist in a product-facing or platform role. - Familiarity with ClickHouse or similar high-performance OLAP platforms. - Familiarity with the JVM ecosystem. - Experience deploying AI/ML models in production, including inference APIs and vector databases. Benefits - Flexible work environment - ClickHouse is a globally distributed company and remote-friendly. - Healthcare - Employer contributions towards your healthcare. - Equity in the company - Every new team member who joins our company receives stock options. - Time off - Flexible time off in the US, generous entitlement in other countries. - A $500 Home office setup if you’re a remote employee. - Global Gatherings - Opportunities to engage with colleagues at company-wide offsites. - Culture - As part of a rapidly scaling startup, you will be instrumental in shaping our culture.