Business Analyst – Data Integration

Business Analyst – Data Integration

Alpharetta, GA

12 months Contract - Onsite

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.

Key Responsibilities

Data Integration & API Projects

• 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.

Enterprise Data Modeling

• 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.

Troubleshooting, Performance Tuning & Monitoring

• 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.

Stakeholder Collaboration & Documentation

• 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.

Required Qualifications

• 5–8 years of experience as a Business Analyst with a strong focus on data integration, ETL, or API-based projects in a FinTech, 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 endpoint mapping.
• Demonstrated experience in performance tuning and troubleshooting data pipelines or integration jobs.
• Familiarity with data monitoring tools (Datadog, Monte Carlo, Great Expectations, or equivalent) and alerting frameworks.
• Experience working in Agile/Scrum environments with tools such as Jira and Confluence.
• Strong documentation skills with the ability to produce clear, audience-appropriate technical and business-facing artifacts.
• Bachelor''s degree in Computer Science, Information Systems, Finance, or a related quantitative field.

Preferred Qualifications

• Experience in FinTech, private equity, capital markets, or investment platforms (familiarity with cap tables, private placements, or fund structures is a strong plus).
• Exposure to dbt, Airflow, Fivetran, or other modern data stack tooling.
• Knowledge of data governance frameworks and data catalog tools (e.g., Alation, Collibra, Atlan).
• Experience with cloud platforms such as AWS, Google Cloud Platform, or Azure in a data engineering context.
• CBAP, PMI-PBA, or equivalent business analysis certification.
• Familiarity with SDLC governance and change management practices in a regulated financial environment.

Thanks and regards,

Asha Krishna

Associate Director - Talent Partner - US & Canada

Email:

Salary : $60 - $70