What are the responsibilities and job description for the Business Analyst position at Aptino?
a. Capital Market experience is a MUST, structured products are optional, candidates without Capital Market experience will be rejected
b. Familiarity with PWC ASAP , or Moody’s WSA / ABS Suite would be great advantage
- Data Analysis & SQL: Ability to query, manipulate, and analyze large datasets using SQL. Familiarity with relational databases (e.g., MS SQL Server, Oracle, MySQL) and data management tools.
- Excel & Financial Modelling: Advanced Excel skills, including pivot tables, VLOOKUPs, and financial modeling techniques (e.g., bond pricing, yield curve calculations, cash flow projections). Ability to use macros (VBA) for automation.
- Business Intelligence (BI) Tools: Experience using BI tools like Tableau, Power BI, or QlikView for reporting and visualization of financial data and portfolio metrics.
- Risk Management Systems: Familiarity with systems used to manage financial risk (e.g., Bloomberg, RiskMetrics, MSCI Barra) and their integration into the business process.
- Requirement Gathering: Ability to work closely with stakeholders (traders, portfolio managers, compliance officers, and risk managers) to gather, document, and prioritize business requirements for systems supporting structured debt products.
- Functional Specifications: Translate business requirements into functional specifications and user stories that guide system development or enhancement.
- Process Mapping & Improvement: Experience mapping business processes (e.g., trade lifecycle, settlement, risk management) and identifying opportunities for automation or efficiency improvements.
- User Acceptance Testing (UAT): Experience in developing test plans, creating test cases, and performing UAT to ensure system enhancements meet business needs and are functioning correctly.
Job Types: Full-time, Contract
Pay: $52.17 - $55.25 per hour
Expected hours: 40 per week
Benefits:
- 401(k)
- Dental insurance
- Health insurance
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Experience:
- Capital Market: 7 years (Preferred)
- Business analysis: 8 years (Preferred)
Ability to Commute:
- East Pittsburgh, PA 15112 (Preferred)
Work Location: In person
Salary : $52 - $55
