Sr. Business Analyst

Overview

Client is seeking a Business Analyst / Data Analyst to support enterprise-scale data solutions across reporting, analytics, regulatory needs, and data-driven business insights. This role will partner with business stakeholders, architects, data engineers, and downstream consumers to define requirements, perform data analysis, and support accurate end-to-end data delivery across the enterprise data supply chain.

Core Responsibilities

• Partner with business and technology stakeholders to elicit, analyze, and document business and data requirements.
• Own end-to-end data attribution and source-to-target mapping for enterprise data elements across source systems, CAM, and downstream marts.
• Translate business requirements into detailed functional and technical specifications, including transformations, derivations, and business rules.
• Provide SQL logic, data validation rules, and mapping guidance to support development and data engineering teams.
• Contribute to logical and physical data models and entity-relationship diagrams.
• Support solution design to ensure alignment with business objectives, data standards, and optimized user experience.
• Lead and participate in requirement and mapping reviews to ensure quality, consistency, traceability, and auditability.
• Perform data analysis, profiling, and validation to assess data quality, completeness, and downstream impacts.
• Support SIT and UAT by defining test scenarios, validating results, and assisting with defect resolution.
• Communicate progress, risks, dependencies, and estimates to project managers and stakeholders.
• Apply SDLC and Agile methodologies from discovery through delivery and post-implementation support.
• Mentor junior analysts and promote continuous improvement in data quality, delivery efficiency, and documentation standards.

Essential Qualifications, Skills, and Technologies

• Bachelor's Degree with 7+ years of Business Analysis and/or Data Analysis experience, Master's Degree with 4+ years of relevant experience, or equivalent work experience.
• Strong SQL experience for data analysis, validation, and requirement translation.
• Experience with data mapping, data modeling, and enterprise data platforms.
• Experience working with cloud platforms such as Google Cloud Platform and BigQuery.
• Experience translating business requirements into functional and technical specifications.
• Experience supporting source-to-target mapping, business rules, data validation, and data quality analysis.
• Strong analytical, written, and verbal communication skills.

Preferred Skills or Experience

• Experience working in Information Technology within the banking or financial services industry.
• Strong understanding of enterprise data supply chains and downstream impacts.
• Experience with Agile methodologies, Scrum, Jira, and Confluence.
• Experience performing data quality analysis and automation for validations.
• Working knowledge of Ab Initio, Mainframe systems, and BI tools such as Tableau.
• Understanding of SDLC, security, risk management, and IT controls.
• Ability to work independently, manage multiple priorities, and collaborate across cross-functional teams.

Work Details

• Onsite position.
• Preferred location is 4910 Tiedeman; also open to Columbus, OH, Buffalo, NY, or Albany, NY.
• Start date: 07/06/2026.
• End date: 12/31/2026.