Business Systems Analyst (Capital Markets & SQL)
Info Way Solutions LLC
Job Description
Job Description
Job Title: Business Systems Analyst (Capital Markets & SQL)
Location: Boston, MA
We are seeking an experienced Business Systems Analyst (BSA) with a strong background in Capital Markets and SQL to bridge the gap between business stakeholders and technology teams. The ideal candidate will gather and analyze business requirements, create functional specifications, perform data analysis using SQL, and support the delivery of technology solutions for trading, settlements, securities processing, and regulatory reporting.
Key Responsibilities- Collaborate with business users, product owners, and technology teams to gather, analyze, and document business and functional requirements.
- Translate business needs into detailed Functional Requirement Documents (FRDs), Business Requirement Documents (BRDs), and user stories.
- Perform data analysis and validation using SQL to support business processes, testing, and production support.
- Analyze trade lifecycle processes including trade capture, confirmation, settlement, reconciliation, and reporting.
- Work closely with development and QA teams throughout the SDLC to ensure successful solution delivery.
- Conduct impact analysis for system enhancements and production changes.
- Create process flows, workflow diagrams, and functional specifications.
- Support User Acceptance Testing (UAT), defect triage, and production releases.
- Coordinate with cross-functional teams to resolve production issues and identify root causes.
- Participate in Agile ceremonies, including sprint planning, backlog grooming, and retrospectives.
- Prepare project documentation, release notes, and business process documentation.
- Ensure compliance with regulatory and audit requirements in financial systems.
- 5 years of experience as a Business Systems Analyst or Business Analyst.
- Strong experience in Capital Markets , Investment Banking, or Financial Services.
- Advanced SQL skills, including:
- Complex joins
- Stored procedures
- Views
- Common Table Expressions (CTEs)
- Aggregate and analytical functions
- Data validation and reconciliation
- Experience with requirements gathering and stakeholder management.
- Strong knowledge of SDLC and Agile/Scrum methodologies.
- Experience with Jira, Confluence, and Microsoft Office tools.
- Excellent analytical, problem-solving, and communication skills.
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Business Systems Analyst (Capital Markets & SQL) in Boston, MA vacancy
- ...Investments, Portfolio Management and/or Capital Markets Exposure.Understanding of portfolio... ...analytics.Experience translating functional business requirements to technical specifications... ...JS, Node JS) alshighly desirableStrong SQL skills with considerable experience in Oracle...SQLFull timeH1b
Sonsoft
Boston, MA4 days ago $144.6k - $265.1k
Position Summary Manager - Capital Markets Surveillance Technology &... ...by optimizing “heart of the business” operations. We leverage deep... ...design, implement, and manage systems and processes to detect and... ...trading and market data using SQL, Python, Databricks, Informatica...SQLDeloitte
Boston, MA2 days ago- ...global settings. Monitor system performance and... ...training materials. Business Systems Analyst Responsibilities Partner... ...construction, engineering, or capital project organizations... ...BI, SharePoint, SQL, and Power Platform... ...regularly to reflect market trends.About...SQLTemporary workFor contractorsWork at office
Suffolk Construction
Boston, MA5 days ago - Business Systems Analyst - Client & Reporting Platforms Perm The Role This role sits within a client... ...platform used across client service, marketing, product, and investment teams. The work... ...relational data Working knowledge of SQL; VBA or basic scripting is a plus...SQLPermanent employment
$90k - $150k
...positioned to solve them. RA Capital has done exactly... ...who think in systems and act with urgency.... ...Capital is seeking a Business Systems Analyst Scientific & Venture... ...automate workflows; use SQL to query and validate... ...qualifications and current market conditions. In...SQLFull timeWork at office- ...solutions company in Boston seeks a qualified candidate to provide technical consultation on Salesforce Marketing Cloud. The ideal candidate will possess strong skills in SQL and documentation, validate technical designs, and manage work packages effectively. This position...SQL
$115k - $150k
...Boston, MA BAIN CAPITAL OVERVIEW With approximately... ...investors, teams, businesses, and the... ...Capital’s Private Markets and Corporate Technology... ...will focus on the systems and processes that... ...business analyst to apply deep partnership... ...skills with SQL and Excel; Python...SQLFull timeBain & Company
Boston, MA1 day ago$70k
...Description See how Epsilon powers connected marketing by unlocking the full potential of... ...Epsilon is seeking an Associate, Business Systems Analyst (ABSA) to join a team that is focused... ...experience Experience working with data and/or SQL is a plus Additional Information When...SQLTemporary workWork experience placementFreelanceWork at officeLocal areaFlexible hours2 days per week$109.65k - $135.45k
...raised over $160M in venture capital, serve thousands of... ...development. We are seeking a Business Systems Analyst to join our Enterprise Applications... ...database concepts, some SQL programming experience ~ Some... ...centers on 5 principles: Market-driven - We anchor pay...SQLBase plus commissionFull timeWork experience placementFlexible hours$145k - $175k
...daily lives.WHOOP is hiring a Senior Business Systems Analyst to support the growth and operational... ...B channels. As WHOOP expands into new markets and customer segments, this role will... ...personal contributions.BONUSExperience with SQL, reporting, or data analysis tools....SQLFull timeWork at officeRelocationWHOOP
Boston, MA5 days ago$115k - $150k
TITLE: Senior Business Systems AnalystLOCATION: Boston, MABAIN CAPITAL OVERVIEWWith approximately $225 billion of assets under... ...at Bain Capital. The Senior Analyst will play a hands-on role in Salesforce... ...analysis.Experience working with SQL for data extraction,...SQLFull timeBain Capital
Boston, MA4 days ago- ...FocusKPI is looking for a Marketing Operations Analyst to join one of our clients, a high-tech SaaS company... ...governance and consistency across systems, enabling effective audience targeting... ...problems. The role involves writing complex SQL to access data in our warehouse, while...SQLFull time
FocusKPI
Cambridge, MA3 days ago $59.5 - $85 per hour
...to the Private Credit business, advancing the platforms... ...applications, analyze data using SQL, troubleshoot complex... ...stabilization, mentor analysts, establish delivery... ...and data solutions.Systems, Data and DeliveryConfigure... ...working with private markets, leveraged finance or...SQLYoh
Boston, MA1 day ago- ...Studio, and Content Builder.Develop and troubleshoot AMPscript, SQL queries, automations, and dynamic content.Create and manage Data... ...practices and governance standards.Required Skills3 years of Salesforce Marketing Cloud experience.Strong hands-on experience with: Journey...SQL
Kasmo
Boston, MA7 hours ago $111.2k - $126.9k
Sr. Business Analyst, Capital One Shopping (Remote-Eligible) This is your opportunity... ...various lending products Marketing: Support direct-to-consumer... ...engineering, Information Systems or a related quantitative... ...1 years of experience in SQL querying 2 years of experience...SQLRemote jobFull timeTemporary workPart timeLocal area- Santander Holdings USA, Inc. in Boston is seeking a Senior Analyst to support day-to-day Capital Planning operations and provide senior analysis for... ...and budget in collaboration with finance partners. Strong SQL and Excel skills are required; Power BI is a plus. The role...SQL
- ...SummaryLeads the Quantitative Capital Insights team in making risk-based... ...Mutual`s most consequential business decisions-capital deployment,... ...across underwriting, reserve, market, credit, catastrophe, and... ...tools including Excel; Python/R/SQL capabilities valued.11) Strong...SQLLocal areaShift work
Liberty Mutual
Boston, MA4 days ago - ...Vice President of Marketing Analytics About the Company Financial... ...building scalable analytics systems to measure and optimize... ...segmentation models, translating business needs into technical specifications... ...tracking, exceptional SQL skills, and practical scripting...SQL
- ...Vice President of Portfolio Marketing About the Company Leading application security platform protecting software throughout development... ...application risk intelligence application security sql injection cross site scripting software vulnerabilities...SQL
$80k - $100k
...created a significant market shift. In July 2026, new... ...across all our products and business lines. Juno sends at... ...Segment logic, Liquid, SQL, copy variants, post-... ...deeper on data, or an analyst/ops person who wants to... ...what it did You think in systems: You'd rather build the...SQLShift workJuno Inc
Boston, MA3 days ago- ...Vice President of Software Engineering, Marketing Technology About the Company Rapid-... ...and scale engineering teams, contribute to system design and development, drive... ...experience in Java, TypeScript, Node.js, and SQL is required, as is a proven track record...SQL
- RTK Tickets in Boston is seeking a Data Analyst to design and maintain data pipelines, develop predictive models, and ensure data quality... ...experience in data science, strong proficiency in Python, and SQL skills. Benefits include competitive salary, health insurance, and...SQL
- ...Citizen or GC Permanent Resident) General Summary The Clinical Business System Analyst is responsible for business process analysis and the... ...Required proficiency in: Microsoft Office, Microsoft Access, SQL, data centric environments and Microsoft Excel (pivot tables...SQLPermanent employmentContract workWork at officeVisa sponsorship
- ...Vice President of Product Marketing About the Company Leading application security platform protecting software throughout development... ...application risk intelligence application security sql injection cross site scripting software vulnerabilities...SQL
$230k - $275k
...management as well as capital markets and insurance solutions... ...is regarded as a key business enabler at KKR and is... ...initiatives to enhance system performance, user experience... ...tools (e.g., Python, SQL, Power BI, Sigma,... ...product managers, business analysts, scrum masters,...SQLLocal area- ...rotational initiative enables Analysts to enhance both technical and... ...power the global financial markets by providing critical infrastructure... ..., you will learn how your business area contributes to that... ...business analysis, information systems, technology delivery, operations...Full timeWork experience placementInternshipWork at officeRemote work
DTCC
Boston, MA5 days ago - ...) team in Private Markets, driving design and... ...enhance reporting systems & processes across... ...directly with the business, choose the tools... ...secured web apps).Help analysts take AI-generated... ...plus.Strong SQL skills required. Experience... ...fund structures, capital calls and...SQLWork at officeLocal area3 days per week
Liberty Mutual
Boston, MA3 days ago - ...Job Summary We’re looking for a Lifecycle Marketing Manager to lead our consumer retention... ...preferably in consumer SaaS or subscription businesses. Strong track record of working cross‑... ..., cohort analysis, experimentation, and SQL (or a willingness to get scrappy)....SQLFlexible hours
Deleteme Inc
Boston, MA4 days ago - Job Title: Associate Business Systems Analyst Job Summary As an Associate Business Systems Analyst, you are early in your career and build your skills... ...Kyruus product suite. Skills: basic HTML, basic CSS, basic SQL, and basic JSON. Tools: familiarity with, or ability to...SQLInternship1 day per week
$132.23k - $176.31k
...The Role The Senior Lead Marketing Data Platform Architect is responsible... ..., Adobe, Salesforce, and business stakeholders to ensure the... ...guidance to engineers, analysts, and cross-functional stakeholders... ...~ Advanced data modeling, SQL, and data architecture expertise...SQLFull timeTemporary workLumen
Cambridge, MA5 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Business Systems Analyst (Capital Markets & SQL). Be the first to apply!
