Business Systems Analyst (IT): III (Senior)

Description

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.

Responsibilities:
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.
Analyze data across upstream applications and warehouse structures to confirm accuracy, investigate discrepancies, and support reconciliation efforts for auditable reporting.
Develop and refine validation queries, exception reporting, and quality checks to verify that business rules are implemented correctly in data processes.
Partner with data engineering, finance, risk, and business stakeholders to translate requirements into scalable data designs that support reporting and analytical needs.
Research business issues and system behavior to identify requirements, assess solution options, and guide design decisions for data-focused initiatives.
Support ETL and batch processing activities by aligning job logic, parameter settings, restart considerations, scheduling expectations, and operational documentation with approved specifications.
Produce and maintain project artifacts such as business requirements documents, mapping workbooks, design documentation, test plans, and runbooks.
Participate in defect resolution, production readiness reviews, and change management discussions to help ensure stable delivery of reporting capabilities.

Requirements

At least 5 years of experience in business analysis or data-focused roles within banking or financial services.
Strong SQL and PL/SQL skills with the ability to query, analyze, and validate complex data sets.
Minimum 3 years of experience working with ETL processes or data integration jobs in an enterprise environment.
At least 3 years of experience supporting or working within an Enterprise Data Warehouse.
Proven ability to create source-to-target mappings and maintain data lineage and traceability across systems.
Strong communication skills with the ability to turn business and regulatory needs into clear technical specifications.
Experience collaborating with cross-functional stakeholders, including business subject matter experts and technical delivery teams.
Familiarity with financial reporting, reconciliations, and banking data domains such as loans, deposits, or regulatory reporting is preferred.

Technology Doesn't Change the World, People Do.

Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.

All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.

2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.