We’re looking for a Business Systems Analyst with solid technical abilities working with SQL. In this job, you’ll join a newly formed team building trading and compliance applications for a prominent investment company in the Back Bay.

This is a great job for people who want:

• Career growth – the company is updating all of their systems with new, cloud based technology
• Employee benefits – extremely generous
• Work environment – team oriented culture

Major Responsibilities

• Write, review and clarify compliance-related specifications from trade and regulatory compliance, finance, legal, client operations and marketing business users
• Engage in enhancements to existing applications and reports or in migration of such to 3rd party tools by providing analyst and liaison role between business and development team while working closely as part of development team
• Interact with various business teams in establishing automated workflows, monitoring investment guidelines, developing and testing compliance rules, monitoring pre & post trade compliance alerts, and assisting business members in resolving issues related to client guidelines and/or regulatory restrictions imposed by US or foreign regulatory agencies
• Investigate data by writing ad hoc SQL statements
• Test development work to meet functional requirements
• Prepare UAT for user-facing applications and facilitate business users verifying the changes
• Analyze business requirements and suggest enhancements to stored procedures in TSQL for SQL Server databases or in C#, Python, or JavaScript in application layer
• Manage project requirements with an eye toward Test-Driven Development; design, create and review such tests
• Create and manage automated Regression Test suits for various components
• Investigate new technologies and software to make existing systems and processes more robust and meet new business requirements
• Engage in a vendor selection type of projects when a 3rd party tool is needed
• Provide ongoing production support for existing production processes
• Estimate work effort for projects and measure against estimates to develop refinements
• Serve as backup for development manager as needed

Qualifications

• Bachelor’s (Master’s preferred) degree in Computer Science, Engineering, Math, Economics or a related field
• 4-6 years’ proven experience as a business or systems analyst with compliance, auditing and regulatory systems experience in Investment Management Services
• Experience with Charles River Development, Sentinel or comparable compliance system
• Experience and comfort writing SQL code
• Experience developing automated tests and test driven development
• Experience with Python or C#
• High attention to detail, analytical problem solving and strong communication skills
• Experience with any formal project management methodology: six sigma, PMP, or Scrummaster
• Knowledge of financial instruments and securities regulations
• CFA not required but strongly preferred