We are looking for a senior Business Systems Analyst to support complex data and reporting initiatives for a Long-term Contract position based in Columbus, Ohio. In this role, you will convert business and regulatory needs into well-defined data requirements, partnering with technical and functional teams to build dependable, traceable reporting solutions. The ideal candidate brings strong experience in enterprise data warehousing, source-to-target mapping, and data validation within banking or financial services environments.<br><br>Responsibilities:<br>• Lead the creation and maintenance of end-to-end source-to-target mapping documents, defining transformation rules and preserving clear data lineage from source systems through reporting layers.<br>• Analyze data across upstream applications and warehouse structures to confirm accuracy, investigate discrepancies, and support reconciliation efforts for auditable reporting.<br>• Develop and refine validation queries, exception reporting, and quality checks to verify that business rules are implemented correctly in data processes.<br>• Partner with data engineering, finance, risk, and business stakeholders to translate requirements into scalable data designs that support reporting and analytical needs.<br>• Research business issues and system behavior to identify requirements, assess solution options, and guide design decisions for data-focused initiatives.<br>• Support ETL and batch processing activities by aligning job logic, parameter settings, restart considerations, scheduling expectations, and operational documentation with approved specifications.<br>• Produce and maintain project artifacts such as business requirements documents, mapping workbooks, design documentation, test plans, and runbooks.<br>• Participate in defect resolution, production readiness reviews, and change management discussions to help ensure stable delivery of reporting capabilities.