Technical Business Analyst – Capital Markets, strong SQL
(1 opening)
A business analyst with a technology background and strong SQL who can analyze capital
markets data and systems as well as business requirements.
Responsibilities
Gather business requirements and translate them into functional and technical
specifications.
Write complex SQL queries to analyze, profile and validate data across source and
target systems.
Prepare data mapping documents, interface specifications and source-to-target
mappings.
Analyze data flows and system integrations, and investigate data quality issues to
root cause.
Work closely with developers and architects on solution design and impact analysis.
Support system integration and user acceptance testing with SQL-based validation
and reconciliation.
Document data lineage, business rules and transformation logic.
Required skills
Proven experience as a Business Analyst in capital markets.
Strong hands-on SQL: joins, subqueries, aggregations, analytic functions and query
tuning.
Technology background, such as prior development, data analysis or systems analysis
experience.
Good understanding of the trade lifecycle and capital markets data: trades, positions,
securities reference data and pricing.
Experience with relational databases such as Oracle, SQL Server or DB2.
Ability to explain technical detail to business users and business needs to engineers.
Preferred skills
Experience with data warehouse, ETL or reporting projects.
Exposure to APIs, messaging formats (SWIFT, FIX) or file-based interfaces.
Python or Excel / VBA for data analysis.
Experience in custody, fund accounting or asset servicing.