Investment Banking Financial and Product Regulatory Reporting Analyst
______________________________________________________________________
Location: Glasgow, United Kingdom
Type: Full-time
Department: Technology
_______________________________________________________________________
Summary
eClerx is looking for data analytics professionals with extensive experience in business analysis. The combination of skills means the person should be comfortable querying and analyzing data sets and using that information to write requirements and specifications for project and BAU work.
Duties will include learning complex data schemas and data sets and then supporting stewardship of those databases. Writing specifications of reports and applications based on business needs and on aggressive schedules. Responding to support tickets and user queries on the databases and their data.
Previous experience in investment banking operations or technology support required. Must have experience with regulatory reporting of securities, lending, OTC and listed derivatives.
They should be skilled in Jira and agile methodologies.
Responsibilities:
1. Provide data wrangling services to make data (structured and unstructured), by transformations, normalization, and data mapping, understandable and useable for drafting specifications for project and BAU work
2. Draft report specifications after analyzing and understanding complex database schemas
3. Prepare and communicate through effective presentations and written communications
4. Database support/stewardship, responding to support tickets from end users and developers
5. Query and join multiple tables in SQL Server databases to provide data needed to support business analysis
6. Use analytical tools such as Axiom, Power BI and Alteryx
7. Prepare technical specifications and documentation for technology solutions in order to support downstream uses
Required Skills and Experience:
8. Demonstrable experience in investment banking with regulatory reporting capability
9. Experience developing data models and analytical products for financial services firms with background in finance and/or product control.
10. 4+ years of hands-on experience with SQL
11. 4+ years of Axiom experience and Axiom objects such as Data Source, Data Model, Modify Model, Aggregation, etc.
12. Knowledgeable with Jira and agile methodologies
13. Experience in business analysis and working with diverse teams and competing interests for requirements gathering and analyzing technical trade-offs
14. Strong analytical, problem solving, and troubleshooting abilities
15. Strong oral and written communication skills with the ability to effectively communicate with both technical and non-technical audiences at all levels within technical and business organizations
16. Innovation minded, highly capable of thinking systematically, capable of redefining the solutions to overcome the competitors and solve problems
#LI-Hybrid
About eClerx
eClerx is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law. We are also committed to protecting and safeguarding your personal data. Please find our policy .