IT - Technical Business Analyst - Investments Data Platform | Holmdel, NJ - 2 days onsite

SGA Inc.

Holmdel, NJ

JOB DETAILS
SALARY
$50–$58 Per Hour
SKILLS
Acceptance Testing, Agile Programming Methodologies, Amazon Web Services (AWS), Analysis Skills, Application Programming Interface (API), Asset Management, Atlassian JIRA, Automation, Backlog Prioritization, Bug Tracking/Defect Management, Business Analysis, Business Skills, Business Transformation, Cash Flow, Cloud Computing, Communication Skills, Computer Science, Consulting, Continuous Improvement, Cross-Functional, Customer Support/Service, Data Analysis, Data Management, Data Profiling, Data Quality, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Documentation, Finance, Financial Services, Fixed Income Investments, Genetics, Information Technology & Information Systems, Insurance, Investment Analysis, Investment Charting and Technical Analysis, Investment Management, Investment Reporting, Metadata, Microsoft Windows Azure, Multiplatform/Cross-Platform, Pricing, Problem Solving Skills, Python Programming/Scripting Language, Quality Assurance, Reconciliation, Requirements Management, Requirements Validation/Verification, Risk, Root Cause Analysis, SQL (Structured Query Language), Scrum Project Management and Software Development, Sprint Planning, Staff Development, Technical Delivery, Technical Support, Technical/Engineering Design, Test Design, Traceability, Trading/Stockbroking
LOCATION
Holmdel, NJ
POSTED
1 day ago

SGA is seeking a Technical Business Analyst – Investments Data Platform for a long-term consulting assignment with one of our premier insurance clients. This is a hybrid opportunity based in Holmdel, NJ, requiring onsite presence two days per week (Wednesday and Thursday).
In this role, you will partner with Product, Investments, Risk, Operations, and Engineering teams to gather, analyze, and translate complex investment data requirements into scalable technology solutions. The ideal candidate will bring strong investment domain knowledge, hands-on data analysis experience, and the ability to bridge business and technical teams while supporting data platform modernization, automation, and reporting initiatives.
Responsibilities
Investment Data Requirements & Analysis
  • Partner with Product Managers, Product Owners, portfolio teams, risk teams, and operations stakeholders to gather and document business requirements.
  • Translate investment workflows into functional specifications, data mappings, and system requirements.
  • Analyze investment datasets including holdings, trades, issuer/security master, pricing, ratings, and cash flow data.
  • Identify upstream and downstream dependencies across data pipelines, reporting platforms, and consuming applications.
Data Analysis & Data Quality
  • Perform data profiling, reconciliation, validation, and root cause analysis across multiple systems and data sources.
  • Identify, investigate, and resolve data quality issues, exceptions, and inconsistencies.
  • Define business rules, transformation logic, and validation requirements.
  • Support data lineage, traceability, and governance initiatives across the data platform.
Agile Delivery & Jira Management
  • Create and manage Jira epics, features, user stories, and backlog items.
  • Break business requirements into detailed, testable user stories with clear acceptance criteria.
  • Participate in sprint planning, backlog refinement, prioritization, and Agile ceremonies.
  • Ensure traceability between business requirements, technical design artifacts, testing, and delivery outcomes.
Cross-Functional Collaboration
  • Refine requirements through stakeholder feedback and technical design discussions.
  • Collaborate closely with data engineers, architects, platform teams, and QA resources.
  • Serve as the liaison between business stakeholders and technical delivery teams.
  • Ensure alignment between business objectives and platform capabilities.
Testing & User Acceptance Testing (UAT)
  • Develop and execute UAT scenarios aligned to investment workflows and reporting requirements.
  • Validate end-to-end data flows from ingestion through transformation and reporting.
  • Coordinate testing activities with business users and project stakeholders.
  • Track defects through resolution and ensure successful remediation.
Delivery & Stakeholder Communication
  • Communicate project status, risks, dependencies, and delivery progress to stakeholders.
  • Support release validation and production implementation activities.
  • Ensure solutions meet business requirements and data accuracy expectations.
  • Contribute to continuous improvement efforts across data platform processes and automation initiatives.
Required Skills
  • Bachelor's degree in Finance, Computer Science, Information Systems, or related discipline.
  • 5+ years of experience as a Technical Business Analyst within investment management, asset management, insurance investments, or financial services environments.
  • Strong understanding of investment data concepts including securities, trades, portfolios, asset classes, ratings, and investment reporting.
  • Hands-on experience managing Jira features, epics, user stories, and Agile backlogs.
  • Strong SQL and data analysis skills with proficiency in Excel and related tools.
  • Experience working within Agile/Scrum delivery environments.
  • Strong analytical, problem-solving, and data validation skills.
  • Excellent communication, stakeholder management, and requirements gathering capabilities.
  • Experience documenting data mappings, business rules, and functional requirements.
  • Ability to work effectively across business, product, and technical teams.
Preferred Skills
  • Experience supporting investment data platforms, data lakes, or enterprise data warehouse environments.
  • Familiarity with Databricks, Python, cloud data platforms (Azure or AWS), or similar technologies.
  • Experience with data ingestion frameworks, ETL/ELT processes, and API integrations.
  • Knowledge of fixed income, private placements, or insurance investment portfolios.
  • Understanding of data governance, lineage, and metadata management concepts.
  • Exposure to enterprise investment management platforms and tools


SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.
 

About the Company

S

SGA Inc.