Business Data Analyst

Capgemini; New York (NY); On-site; USD 82,786 - 85,383; Full time

Benefits offered by this job

Paid time off

Medical/dental/vision coverage

401(k) retirement plan

Life & disability insurance

Employee assistance program

Job summary

Capgemini in New Jersey seeks an experienced Business Systems Analyst (BSA) with a strong background in data engineering and data warehousing to bridge business needs with IT delivery. You will analyze requirements, define data rules, support ETL/ELT workflows, and collaborate with data engineers, architects, and analytics teams to deliver reliable reporting and dashboards.

The role requires 8+ years of BA experience, knowledge of Snowflake/Redshift/BigQuery, cloud platforms, and strong

Qualifications

• 8+ years as a Business Systems Analyst supporting data projects.
• Experience translating business needs into data specs and technical requirements.
• Strong SQL, data modeling, and data quality skills.
• Knowledge of data platforms and ETL/ELT processes.

Responsibilities

• Gather and document business and data requirements with stakeholders.
• Define data rules, KPIs, and use cases; document BRDs/FSDs.
• Collaborate with Data Engineers and IT to deliver data pipelines and warehouses.
• Support data governance, quality, and security initiatives.
• Assist in UAT, data validation, and dashboard reporting support.

Skills

Business Analysis

Stakeholder management

SQL

Data modeling

Data governance

Agile/Scrum

BRD/FSD documentation

Data quality

Education

Bachelor's degree in CS/IS/Analytics

Certifications in BA/Agile/Cloud/Data Mgmt

Tools

JIRA

Azure DevOps

Visio

Lucidchart

Power BI

Tableau

Snowflake

Amazon Redshift

BigQuery

Azure Data Factory

Informatica

Talend

AWS Glue

Excel

Job description

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 bya 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 organizationsunlock the value of technology and build a more sustainable, more inclusive world.

Job Location: New Jersey, NJ (Onsite/Hybrid from Day 1)

Job Description

We are seeking an experienced Business Systems Analyst (BSA) with a strong background in Data Engineering and Data Warehousing projects. The ideal candidate will serve as a critical liaison between business stakeholders, data engineering teams, and IT organizations to ensure that data-driven solutions are aligned with business objectives and delivered effectively.

This role requires a blend of business analysis expertise, data domain knowledge, stakeholder management, and technical understanding of modern data platforms, ETL/ELT processes, and reporting solutions.

Key Responsibilities

• Collaborate with business stakeholders to gather, analyze, and document business and data requirements.
• Translate business requirements into functional and technical specifications for data engineering teams.
• Define business rules, data use cases, KPIs, and success criteria.
• Work closely with Data Engineers, Architects, and Developers on data integration, ETL/ELT, data pipeline, and data warehousing initiatives.
• Analyze and document data flows, source-to-target mappings, transformation logic, and data lineage.
• Facilitate requirements workshops, stakeholder meetings, and solution review sessions.
• Act as the primary liaison between business users, data teams, and IT stakeholders.
• Create and maintain Business Requirement Documents (BRDs), Functional Specification Documents (FSDs), user stories, process flows, data dictionaries, and related documentation.
• Ensure alignment between business expectations and delivered solutions.
• Support data governance, data quality, security, and compliance initiatives.
• Participate in User Acceptance Testing (UAT), data validation, and defect resolution activities.
• Collaborate with BI and Analytics teams to support dashboards, reporting, and data visualization requirements.
• Ensure data accuracy, consistency, and usability across reporting and analytical platforms.
• Support Agile project delivery and participate in sprint planning, backlog grooming, and requirement refinement sessions.

Required Skills & Experience

• 8+ years of experience as a Business Systems Analyst or Business Analyst, with significant experience supporting Data Engineering or Data Warehousing projects.
• Strong understanding of Business Analysis methodologies, requirements management, and stakeholder engagement.
• Hands-on experience with data integration, ETL/ELT processes, and enterprise data platforms.
• Advanced SQL skills for data analysis, validation, and troubleshooting.
• Solid understanding of data modeling concepts, including Star Schema and Snowflake Schema.
• Experience with data mapping, data lineage, metadata management, and transformation logic.
• Knowledge of data quality frameworks and data validation techniques.
• Experience working with data warehouses and data lake technologies such as Snowflake, Amazon Redshift, BigQuery, or similar platforms.
• Exposure to cloud platforms including Azure, AWS, or GCP.
• Experience with ETL/ELT tools such as Informatica, Talend, Azure Data Factory, AWS Glue, or similar technologies.
• Familiarity with reporting and visualization tools such as Power BI, Tableau, and Excel.
• Experience using JIRA, Azure DevOps, Visio, Lucidchart, or similar tools.
• Excellent analytical, problem‑solving, and communication skills.
• Strong stakeholder management skills with the ability to work across cross-functional teams.

Preferred Qualifications

• Experience working in Agile/Scrum environments.
• Understanding of API integrations, web services, and data exchange mechanisms.
• Exposure to Big Data technologies such as Spark and Hadoop.
• Knowledge of data governance, data privacy, and regulatory compliance frameworks.
• Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field.
• Relevant certifications in Business Analysis, Agile, Cloud, or Data Management are a plus.

The base compensation range for this role in the posted location is: 82786- 85383

Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.

The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.

These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.

It is not typical for candidates to be hired at or near the top of the posted compensation range.

In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.

Benefits

Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees.

In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

Important Notice

Compensation (including bonuses, commissions, or other forms of incentive pay) is not considered earned, vested, or payable until it becomes due under the terms of applicable plans or agreements and is subject to Capgemini’s discretion, consistent with applicable laws. The Company reserves the right to amend or withdraw compensation programs at any time, within the limits of applicable legislation.

Disclaimers

Capgemini is an Equal Opportunity Employer encouraging inclusion in the workplace. Capgemini also participates in the Partnership Accreditation in Indigenous Relations (PAIR) program which supports meaningful engagement with Indigenous communities across Canada by promoting fairness, accessibility, inclusion and respect. We value the rich cultural heritage and contributions of Indigenous Peoples and actively work to create a welcoming and respectful environment. 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 accommodation does not pose an undue hardship. Capgemini is committed to providing reasonable accommodation during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.

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.