Analyst - Funds Context Enablement

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

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

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

· 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).

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

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

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

Disclaimer : Unsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position.

Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.