Business/Data Analyst

Mindlance

Columbus,, OH

JOB DETAILS
SKILLS
Acceptance Testing, Agile Programming Methodologies, Atlassian JIRA, Automation, Banking Services, Business Analysis, Business Architecture, Business Intelligence Software, Cloud Computing, Communication Skills, Cross-Functional, Data Analysis, Data Mapping, Data Modeling, Data Quality, Entity Relationship Diagram (ERD), Financial Services, Information Technology & Information Systems, Mainframe Computer, Multitasking, Presentation/Verbal Skills, Project Estimates, Project/Program Management, Regulations, Requirements Management, Requirements Validation/Verification, Risk Management, SQL (Structured Query Language), Sales/Support Engineering (SE), Scrum Project Management and Software Development, Software Development Lifecycle (SDLC), Supply Chain, Tableau, Test Scenario, Traceability, User Interface/Experience (UI/UX), Writing Skills
LOCATION
Columbus,, OH
POSTED
6 days ago
This position is an onsite position: Manager would prefer at Brooklyn, OH but is open to Columbus, OH, Buffalo, NY or Albany NY.

Job Brief
We are seeking a Business Analyst / Data Analyst (BA/DA) to join the Enterprise Shared Analytics Marts (ESAM) squad within Enterprise Data and Information Services (EDIS). This is a high-impact role supporting enterprise-scale data solutions that power reporting, analytics, regulatory needs, and data-driven business insights. The BA/DA will partner closely with business stakeholders, architects, data engineers, and downstream consumers to define business requirements, perform data analysis, and ensure accurate end-to-end data delivery across the Enterprise Data Supply Chain.

Essential Job Functions
· 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, ensuring quality, consistency, traceability, and auditability.
· Perform data analysis, profiling, and validation to assess data quality, completeness, and downstream impacts.
· Support testing activities including 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 throughout the lifecycle from discovery through delivery and post-implementation support.
· Mentor junior analysts and promote continuous improvement in data quality, delivery efficiency, and documentation standards.

Required Qualifications
· Bachelor’s Degree with 7+ years of Business Analysis and/or Data Analysis experience, or Master’s Degree with 4+ years of relevant experience, or equivalent work experience.
· Strong analytical, written, and verbal communication skills.
· 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 (BigQuery).
Preferred Skills / Qualifications
· 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. Is a plus.
· Understanding of SDLC, security, risk management, and IT controls.
· Ability to work independently, manage multiple priorities, and collaborate across cross-functional teams.

EEO:
“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”

About the Company

M

Mindlance