Business System Analyst (BFSI)

Capgemini; Toronto; In loco; CAD 103.000 - 113.000; Tempo pieno

Vantaggi offerti da questo lavoro

Paid time off

Medical, dental, and vision coverage

RRSP retirement savings plans

Life and disability insurance

Descrizione del lavoro

Capgemini is seeking a Data Business Systems Analyst (Data BSA) to support data capabilities within marketing platform data infrastructure. You will act as a liaison between stakeholders, architects, developers, and external vendors to translate business needs into actionable data requirements for cloud-based storage and segmentation initiatives.

The role focuses on enablement of data for addressable messaging, including data querying, profiling, and testing readiness.

Competenze

• 5+ years of experience in a data-driven role (BS/BA in a related field preferred).
• Hands-on experience with SQL, PySpark, and Snowflake in data delivery or analytics.
• Experience with cloud data warehouses (Snowflake/Redshift), Lakehouse platforms (Databricks), Hive, and Oracle.

Mansioni

• Translate business needs into implementation-ready technical data requirements and acceptance criteria.
• Document end-to-end data flows including source-to-target mappings and transformation rules.
• Coordinate delivery across technical and business teams to support project milestones.
• Define data validation scenarios and validate outputs against requirements and acceptance criteria.
• Support go-live readiness, deployment coordination, and post-launch validation.
• Enable cloud-based segmentation and data activation to reduce file-based workflows.

Conoscenze

SQL

PySpark

Snowflake

Agile methodologies

Jira

Confluence

Data analysis

Communication

Strumenti

Snowflake

Redshift

Databricks

Hive

Oracle

Descrizione del lavoro

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 DescriptionThe Data Business Systems Analyst (Data BSA) will support the design, development, and delivery of data capabilities within the SYF and Zeta Marketing Platform Data Infrastructure through hands-on data exploration, technical analysis, and implementation-ready requirements. This role will serve as a key liaison between business stakeholders, architects, developers, and an external vendor, translating business needs and data findings into clear requirements that guide engineering implementation.This individual contributor contractor role will focus primarily on enablement of data for addressable messaging. This includes querying and profiling data, defining data flow and transformation requirements, and supporting testing and go-live readiness. The role will also help support the evolution of audience activation to include cloud-based segmentation processes, reducing reliance on file-based workflows and improving the availability, quality, and usability of data across multiple campaign types.Key Responsibilities• Partner with business stakeholders, architects, development teams, and external vendors to translate business needs into implementation-ready technical data requirements and acceptance criteria for Cloud-based data storage and Zeta-related initiatives.• Document and manage end-to-end data flow requirements, including source-to-target mappings, dependencies, business rules, and transformation logic, to guide engineers in implementing data solutions.• Coordinate delivery activities across technical and business teams to support project execution and milestone completion.• Support testing efforts by defining data validation scenarios and expected results, validating outputs against requirements and acceptance criteria, and partnering with engineers on defect triage and issue resolution.• Assist with go-live readiness, deployment coordination, and post-launch validation and support, while engineers retain responsibility for production code development and deployment.• Work with stakeholders to reduce file-based processes by enabling cloud-based segmentation and data activation capabilities.• Help ensure data is accurate, accessible, and usable to support downstream experiences and business needs.• Use hands-on querying, data exploration, and profiling to understand source data, identify root causes of data issues, and translate findings into actionable requirements for engineering resolution and data quality improvements.• Maintain clear documentation of requirements, process flows, data definitions, and operational support procedures.• Act as a conduit between technical and non-technical partners to ensure alignment throughout the project lifecycle.QualificationsRequired• 5+ years of experience as a Business Systems Analyst, Data Analyst, or similar role supporting data-driven initiatives.• Hands-on experience working with SQL, Pyspark and Snowflake in a data delivery or analytics environment.• 5+ years of experience working with a variety of data storage and processing environments, including cloud data warehouses (Snowflake/ Redshift), Lakehouse platforms (Databricks), distributed storage (Hive), and traditional RDBMS (Oracle).• 4+ years of experience in Agile environments, using Jira for project tracking and Confluence for documentation.• Experience supporting cross-functional delivery efforts, including requirements gathering, testing, and implementation support.• Demonstrated ability to work effectively with external vendors, architects, developers, and business stakeholders.• Strong written and verbal communication skills, with the ability to document complex data processes clearly.• Experience working in agile.The base compensation range for this role in the posted location is: 102,500 - 112,500Capgemini 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.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 LeaveMedical, 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 insuranceEmployee assistance programsOther benefits as provided by local policy and eligibilityImportant 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.DisclaimersCapgemini 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.Click the following link for more information on your rights as an Applicant in the United States. http://www.capgemini.com/resources/equal-employment-opportunity-is-the-lawCapgemini 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.