Senior Core Banking Engineer

Job Description: Senior Core Banking Engineer— XGEN & IBM i Data Specialist Function: Core BankingEngineering Location: Remote / Hybrid (US-based) Employment Type: Full-time Experience Level: Senior (7+ years) About the Role We are looking for a seasoned Core Banking Engineer with deep, hands-on expertise in XGEN — the enterprise report writing, data extraction, and output generation platform used within IBM i / AS400- based core banking environments. This role sits at the intersection of core banking operations, data engineering, and regulatory compliance — partnering directly with business stakeholders, compliance teams, and downstream integration consumers to design, build,and optimize XGEN-driven solutions that power critical banking, regulatory, and analytics functions. You will serve as the primary XGEN subject-matter expert within the engagement, translating complex banking data requirements into reliable, performant, and auditable extracts and reports from the core banking platform. Your work will directlysupport regulatory reporting, business intelligence, operational analytics, and core modernization initiatives. What You Will Do XGEN Report &Extract Development Design, build, and maintain complex XGEN report definitions and data extracts against IBM i / AS400 physical and logical file structures in a core banking environment Develop multi-level hierarchical XGEN reports with advanced selection criteria, field-level conditional logic, grouping, sorting, sequencing, and output formatting Build and schedule batch extracts for downstream consumption — producing fixed-width, pipe- delimited, comma-delimited, and custom-format output files for BI platforms, data warehouses, and third-party integrations Optimize XGEN extract performance on high-volume banking databases applying logical file key sequencing, selection criteria tuning, and batch window awareness to ensure extracts complete reliably within operational constraints Maintain complete documentation for all XGEN report and extract definitions including field mappings, selection logic, scheduling parameters, output formatspecifications, and data lineage Demonstrate deep working knowledge of IBM i / AS400 physical file (PF) and logical file (LF) structures as they apply to core banking data domains — accounts, transactions, general ledger, customer information, loans, deposits, and payments Navigate multi-file core banking data models — identifying the correct sourcefiles, understanding key structures, and constructing logical access paths that support accurate and complete XGEN outputs Advice on IBM i data access patterns, file locking behavior, and batch cycle constraints that directly affect extract design, scheduling, and reliability Apply IBM i DB2 query and SQL skills as a complement to XGEN where native IBM i querying provides performance or flexibility advantages Manage IBM i job scheduling — defining job queue priorities, managing dependencies between extract jobs, and aligning extract schedules with core banking batch processing windows to prevent conflicts Regulatory & Compliance Reporting Build and maintain XGEN-driven outputs for regulatory reporting obligations including but not limited to Call Report data feeds, HMDA extractpreparation, BSA/AML data pulls, CRA reporting, Federal Reserve submissions, and NCUA/FDIC compliance extracts Map core bankingdata fields to regulatory reporting schemas — handlingcases where regulatory requirements span multiple source files or require derived and calculated fields Validate field-level accuracy of regulatory extracts against compliance requirements and audit standards Produce ad hoc data extracts and supporting documentation for internal audit, external examination, and regulatory inquiry responses Proactively update XGEN extract logic and field mappings as regulatory reporting requirements evolve Design XGEN-produced output files that feed downstream systems — data warehouses, BI platforms, core modernization middleware, payment systems, and third-party fintech vendors Collaborate with data engineering teams to define transformation logic between raw XGEN extract formats and target data models in modern analytics and integration platforms Work with integration middleware teams whereXGEN-sourced data feedsnear-real-time or API- driven services, advising on extract frequency, format, and latency constraints Partner with BI and analyticsteams consuming XGEN data — supporting data model design,field definition, and data quality validation in downstream platforms such as Power BI, Tableau, or MicroStrategy Core Modernization & Migration Support Support core banking modernization and platform migration engagements by inventorying, documenting, and mapping all existing XGEN reports and scheduled extracts in scope For each XGEN extract in scope, document business purpose, data sources, scheduling cadence, output format, recipients, and all downstream system dependencies — creating a complete migration reference artefact Map XGEN sourcedata fields to target platformdata models — identifying gaps, mismatches, and transformation requirements that must be resolved before migration Perform data equivalency validation between sourceXGEN extracts and target platform outputs ensuringcompleteness, accuracy, and format consistency before cut-over Advise on data cleansing, deduplication, and format normalization requirements discovered during source data profiling using XGEN Client & Stakeholder Engagement Work directly with bank operations staff, compliance officers, finance teams, and IT leadership to gather XGEN reportand extract requirements, explain technical constraints, and deliver solutions that meet business needs Conduct knowledge transfersessions and hands-ontraining for client staff covering XGEN report usage, scheduling, output interpretation, and basic maintenance Participate in agile ceremonies — sprint planning,backlog grooming, sprint reviews — as the XGEN and IBM i data SME Produce clear, maintainable technical documentation including data dictionaries, extract specifications, field mapping registers, scheduling runbooks, and operational guides for client teams Must-Have Experience 7+ years of hands-on experience in IBM i / AS400-based core banking environments in a technical data or engineering capacity 5+ years of direct, production-grade XGEN experience — designing and building complex report definitions and data extracts from scratch, not merely running or maintaining existing reports built by others Deep working knowledge of IBM i physical file and logicalfile structures acrosscore banking data domains — accounts, transactions, GL, customer, loans, and deposits Demonstrated experience building XGEN outputs for regulatory reporting — Call Report, HMDA, BSA/AML, CRA, or equivalent US banking regulatory obligations Hands-on experience with IBM i job scheduling, batch window management, and the operational discipline required to run large extracts in a live banking production environment Proven ability to design XGEN selection criteria and logical file access paths that optimize performance on large banking databases Experience producing XGEN output files consumed by downstream data warehouses, BI platforms, or integration middleware Strong working knowledge of community or regional bank operations — deposit and loan products, payment processing workflows, and the regulatory environment governing US commercial banking Strong Preference Experience supporting a core bankingplatform migration — specifically the work of inventorying, mapping, and validating XGEN-driven extracts against a target platform Proficiency in IBM i / RPG, CL, or SQL for data access needs that extendbeyond what XGEN natively provides Experience delivering XGEN outputs into modern BI platforms such as Power BI, Tableau, or MicroStrategy — including the transformation and data modelling layer Exposure to ETL/ELTtooling and moderndata pipeline designas applied to core bankingdata Familiarity with data governance, data quality, and data lineageframeworks in regulatedfinancial services environments Experience working in an agile product engineering delivery model with sprint-based accountability Domain knowledge in BSA/AML, CRA, HMDA, or other US community bankingcompliance areas Education Bachelor’s degree in computer science, Information Systems, Finance Technology, or a related field or equivalent practical experience in a bankingtechnology environment. IBM i, data engineering, or banking technology certifications are a plus but not required in the presence of strong demonstrated experience. #J-18808-Ljbffr ESP Engineered