"Alerted.org

Data Business Analyst

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Job Location - Fort Mills SC (Day One Onsite - Hybrid)

About The Role

+ We are seeking a highly analytical and detail-oriented Data Business Analyst to support the Bridge to the Future / Trade Hub initiative.

+ This role will focus on enabling the Trading Lite MVP by owning data-domain requirements, ensuring data readiness, and supporting the transition from legacy systems to modern cloud-based platforms.

+ The ideal candidate will have a strong background in financial services, data modeling, and API/data contract documentation, with a passion for driving data quality and operational excellence.

Key Responsibilities

+ Data Requirements & Mapping

+ Own and manage data-domain requirements for the Trading Lite MVP.

+ Identify and capture minimum viable product (MVP) data fields.

+ Map data elements to source-of-record (SOR) systems, including:

+ FIX protocol tags

+ Billing systems

+ Compliance attributes

+ API & Data Contract Documentation

+ Define and document domain-hosted SOR APIs and data contracts.

+ Specify transformation rules, data entitlements, and validation logic.

+ Trace data lineage from legacy SQL systems to AWS targets (Aurora/PostgreSQL, DynamoDB, Kinesis/streams).

+ Data Readiness & Synchronization Strategy

+ Lead the strategy for data synchronization and readiness:

+ Dual-write vs. Change Data Capture (CDC)

+ Data caching mechanisms

+ Transition from batch to real-time processing

+ Identify and surface data quality issues impacting reporting and analytics migration (SQL to Snowflake).

+ Stakeholder Collaboration

+ Collaborate with internal LPL stakeholders to:

+ Validate data completeness and accuracy

+ Analyze cost-of-trade handling and reconciliation metrics

+ Gather user telemetry and feedback for MVP rollout

Required Skills

+ Bachelor's degree in Computer Science, Information Systems, Finance, or related field.

+ 5+ years of experience as a Data Business Analyst or similar role in financial services or trading environments.

+ Strong understanding of trading systems, FIX protocol, and post-trade processes.

+ Experience with cloud data platforms (AWS preferred), including Aurora, DynamoDB, and Snowflake.

+ Proficiency in SQL and data lineage tracing.

+ Familiarity with API documentation tools and data contract standards.

+ Excellent communication and stakeholder management skills.

Preferred Skills

+ Experience with real-time data streaming (e.g., Kinesis, Kafka).

+ Knowledge of data governance, entitlements, and compliance frameworks.

+ Exposure to Agile/Scrum methodologies and tools like JIRA or Confluence.

Mandatory Skills

+ Domain - Trading or Merger & acquisitions mandatory

+ Data analysis, data mapping,

+ Sql scripting

+ Requirement gathering

+ Creating business requirement document (BRD),

+ Functional requirement documents (FRD),

+ Data requirement document (DRD)

+ Data mapping document(DMD)

+ Snowflake (good to have)

Life At Capgemini

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:

+ Flexible work

+ Healthcare including dental, vision, mental health, and well-being programs

+ Financial well-being programs such as 401(k) and Employee Share Ownership Plan

+ Paid time off and paid holidays

+ Paid parental leave

+ Family building benefits like adoption assistance, surrogacy, and cryopreservation

+ Social well-being benefits like subsidized back-up child/elder care and tutoring

+ Mentoring, coaching and learning programs

+ Employee Resource Groups

+ Disaster Relief

Disclaimer

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Click the following link for more information on your rights as an Applicant

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.

Ref. code: 297257

Posted on: Jul 29, 2025

Experience Level: Experienced Professionals

Contract Type: Permanent

Location:

Columbia, US

Brand: Capgemini

Professional Community: Data & AI

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.