Analyst - Funds Context Enablement

CO_AFATI Apex Fund Services LLP; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Apex Group is hiring an Associate – Funds Context Enablement to drive automation across Trade Processing, Pricing, and middle-office workflows in Pune or Bengaluru.

You will build and optimize ETL integrations, reduce manual touchpoints, and collaborate with Operations, Fund Accounting, and Technology teams to enable straight-through processing.

The role requires 3+ years in ETL automation and a solid understanding of capital markets data.

Qualifications

• Mandatory hands-on experience with an ETL tool (Informatica, Alteryx, SSIS or Talend).
• Strong SQL, VBA, and Advanced Excel.
• Experience in automation projects (macros, workflow automation or scripting).
• Understanding of market data platforms (Bloomberg, Refinitiv).
• Exposure to Fund Accounting systems such as Geneva / Paxus preferred.

Responsibilities

• ETL Development & Integration: Design, develop, and enhance ETL processes for operational data flows (trade files, price files, security masters, positions, reconciliations).
• Integrate client-provided trade/price files into internal systems using ETL tools.
• Implement and test new integrations based on business and client requirements.
• Monitor ETL workflows, handle failures, and ensure timely delivery of critical data.
• Automation & Process Improvement: Automate repetitive operations tasks using SQL, VBA, Advanced Excel, macros, scripts, or ETL workflows.
• Build reusable data pipelines to reduce manual intervention across trade and pricing workflows.
• Identify process gaps and deliver scalable automation solutions.
• Operations Support (Trade, Pricing & Middle Office): Support day-to-day trade and price data processing activities; resolve breaks and exceptions.
• Collaborate with Fund Accounting teams (Geneva / Paxus) for data validation and troubleshooting.
• Stakeholder Collaboration & Documentation: Gather requirements from Operations, Product, and Integration teams; translate into technical solutions; maintain docs.

Skills

ETL automation

SQL

VBA

Advanced Excel

Automation scripting

Market data platforms

Geneva/Paxus exposure

Tools

Informatica

Alteryx

SSIS

Talend

Job description

The Apex Group was established in Bermuda in 2003 and is now one of the world’s largest fund administration and middle office solutions providers. Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.

Your career with us should reflect your energy and passion. That’s why, at Apex Group, we will do more than simply ‘empower’ you. We will work to supercharge your unique skills and experience. Take the lead and we’ll give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities. For our business, for clients, and for you.

Associate – Funds Context Enablement (Trade / Price / Data Integrations)

Location: Pune / Bengaluru

Experience: 3+ years

Role Type: Associate

Apex Group Ltd is hiring an Associate – Funds Context Enablement to drive automation across Trade Processing, Pricing, and broader middle-office operational workflows. The role focuses on building, supporting, and optimising ETL integrations, reducing manual touchpoints, improving data quality, and enabling straight-through-processing (STP) across internal systems. You will partner with Operations, Fund Accounting, and Technology teams to automate processes related to trade files, price feeds, reconciliations, market data, and system integrations.

Key Responsibilities

• ETL Development & Integration
  • Design, develop, and enhance ETL processes for operational data flows (trade files, price files, security masters, positions, reconciliations).
  • Integrate client-provided trade/price files into internal systems using ETL tools.
  • Implement and test new integrations based on business and client requirements.
  • Monitor ETL workflows, handle failures, and ensure timely delivery of critical data.
• Automation & Process Improvement
  • Automate repetitive operations tasks using SQL, VBA, Advanced Excel, macros, scripts, or ETL workflows.
  • Build reusable data pipelines to reduce manual intervention across trade and pricing workflows.
  • Identify process gaps and deliver scalable automation solutions.
• Operations Support (Trade, Pricing & Middle Office)
  • Support day-to-day trade and price data processing activities.
  • Work to resolve breaks, mismatches, and exceptions across trade, position, and pricing workflows.
  • Collaborate with Fund Accounting teams (Geneva / Paxus) for data validation and troubleshooting.
• Stakeholder Collaboration & Documentation
  • Gather requirements from Operations, Product, and Integration teams.
  • Translate functional needs into technical ETL/automation solutions.
  • Maintain documentation, SOPs, workflow diagrams, and technical user guides.
  • Communicate clearly with non-technical users.

Required Skills & Expertise

• Technical
  • Mandatory hands-on experience with an ETL tool (Informatica, Alteryx, SSIS, Talend, etc.).
  • Strong SQL, VBA, and Advanced Excel.
  • Experience in automation projects (macros, workflow automation, scripting).
  • Understanding of market data platforms (Bloomberg, Refinitiv).
  • Exposure to Fund Accounting systems such as Geneva / Paxus (preferred but not mandatory).
• Domain
  • Good understanding of trade lifecycle workflows (trade capture, affirmation, settlement).
  • Understanding of pricing workflows (security pricing, market data validation, price exceptions).
  • Familiarity with capital markets instruments (equities, fixed income, derivatives, OTCs, private markets).
  • Background in Fund Administration or Middle Office operations preferred.
• Soft Skills
  • Strong analytical and problem-solving ability.
  • Good communication and stakeholder-management skills.
  • Ability to work under pressure and adapt to shifting priorities.
  • Collaborative team player with ownership mindset.

Candidate Profile (Ideal Fit)

• 3-5 years of experience in ETL automation, trade/price operations, or middle-office technology roles.
• Hands-on automation mindset rather than pure operational processing.
• Capable of building workflows to reduce manual tasks across trade, price, and reconciliations.
• Strong data handling and troubleshooting skills.

About Apex Group

We are dedicated to driving positive change in financial services while fuelling the growth and ambitions of asset managers, allocators, financial institutions, and family offices. Established in Bermuda in 2003, the Group has continually disrupted the asset servicing industry through our investment in innovation and talent. Today, we set the pace in asset servicing and stand out for our unique single-source solution and unified cross asset-class platform which supports the entire value chain, harnesses leading innovative technology, and benefits from cross-jurisdictional expertise delivered by a long-standing management team and over 13,000 highly integrated professionals.

We’re a people-powered business, and our people are full of ambition. Together, we’re inspired to lead the new era of data and tech enabled service. Bringing new products and services to market. Sharpening our client focus. Disrupting the market to exceed expectations. Innovating across a range of specialisms. With our focus on making a difference to our people, our planet and our society, you’ll experience more here than you would at most other companies. Prepare to accelerate. We’re expanding globally and offering more to our clients. This means you get more opportunities to grow with us. So prepare to accelerate. We’ll make sure the time and effort you put in takes you further, faster. Positive change starts with you. We’re expanding globally and offering more to our clients. This means you get more opportunities to grow with us. So prepare to accelerate. We’ll make sure the time and effort you put in takes you further, faster. The journey is yours to own. When you stretch yourself, you grow. We want you to explore ways of working that will see you thrive as part of something bigger. We’ll help you with a solid structure, challenging projects, vibrant networks, supportive colleagues and approachable leaders. All the things you need to own your unique journey.