Business Analyst – Data Integration

Role Overview

We are seeking an experienced Business Analyst – Data Integration to join our growing Technology & Data team. In this role, you will serve as the critical bridge between business stakeholders and engineering teams, driving the design, documentation, and delivery of enterprise‑grade data integration initiatives. You will own the end‑to‑end lifecycle of API‑based and ETL integration projects — from identifying data elements and metadata, to creating source‑to‑target mapping documents and data dictionaries — ensuring that private markets data flows accurately, reliably, and performantly across our platform.

Alpharetta, GA
12+ months Contract - Onsite

• Lead business analysis for data integration (API and ETL) projects, gathering and translating complex business requirements into actionable technical specifications.
• Identify, catalog, and validate data elements and metadata across source and target systems to create comprehensive source‑to‑target mapping documents.
• Build and maintain data dictionaries that define data fields, formats, lineage, and business rules across private markets data ecosystem.
• Collaborate with engineering and data engineering teams to design integration workflows that connect investor, shareholder, company, and transaction data domains.
• Partner with third‑party data vendors and internal product teams to define API contracts, payload structures, and data exchange standards.

• Contribute to the design and governance of enterprise data model, ensuring consistency across investor records, cap table data, fund structures, and private placement transactions.
• Develop logical and physical data models in alignment with business requirements and downstream reporting needs.
• Review and validate data model changes with architects and senior engineers, ensuring referential integrity and scalability.
• Maintain model documentation and facilitate data model reviews across cross‑functional stakeholders.

• Diagnose and resolve data pipeline failures, data quality issues, and integration anomalies across staging, UAT, and production environments.
• Use database tools (e.g., SQL, Snowflake, dbt, Datadog, Grafana, or similar) to monitor pipeline health, job execution times, and data freshness SLAs.
• Conduct performance tuning analysis on slow‑running queries, inefficient joins, and poorly indexed tables — producing optimization recommendations backed by profiling data.
• Set up and refine alerting thresholds for data pipelines to enable proactive issue detection and minimize downstream business impact.
• Produce root cause analysis (RCA) reports following incidents and drive post‑mortem remediation actions.

• Work cross‑functionally with Deal Operations, Research, Product, Legal, and Compliance teams to identify use cases, data requirements, and functional specifications.
• Facilitate requirements workshops, data discovery sessions, and sign‑off reviews with business stakeholders at all levels.
• Author and maintain integration runbooks, BRDs (Business Requirements Documents), functional specifications, and test plans.
• Support UAT by defining acceptance criteria, coordinating test data preparation, and tracking defect resolution.
• Communicate integration progress, risks, and blockers clearly to engineering leads and business sponsors.

• 5–8 years of experience as a Business Analyst with a strong focus on data integration, ETL, or API‑based projects in a Fin Tech, financial services, or enterprise data environment.
• Hands‑on experience creating source‑to‑target mapping documents and data dictionaries for complex, multi‑source integration projects.
• Solid understanding of enterprise data modeling concepts (logical/physical models, ERDs, normalization, dimensional modeling).
• Proficiency in SQL for data querying, profiling, and validation across relational and cloud‑based data platforms (e.g., Snowflake, PostgreSQL, Redshift).
• Experience with API integration projects — including REST/JSON payload analysis, Swagger/OpenAPI documentation, and…