Senior Business Systems Analyst

• 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

• 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

• Medical insurance
• Vision insurance
• Dental insurance
• Life insurance
• Disability insurance
• 401(k) plan