Senior Systems Integration Analyst

Republic Bank of Chicago; United States; On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Paid time off

Health insurance

Dental insurance

Vision insurance

401k

Tuition reimbursement

Parental leave

Childcare assistance

Disability insurance

Life insurance

LinkedIn Learning

Headspace

Employee assistance

Job summary

Republic Bank of Chicago seeks a Senior Systems Integration Analyst to own and deliver complex enterprise integrations. You will drive end-to-end data flows, APIs, and file-based interfaces, ensuring production readiness.

The role will begin with the bank's AML platform implementation and then expand to broader integration initiatives across Fintech and Core Banking, based in Oak Brook, IL. Strong data, SQL, and testing skills are required.

Qualifications

• 7+ years in systems integration and data analysis.
• Hands-on experience with REST APIs and file-based interfaces.
• Trace data across systems and drive issue resolution.
• Proficient in SQL and data reconciliation.
• Understand data mapping, transformations and validation.
• Strong documentation and stakeholder communication.

Responsibilities

• Lead assigned integration workstreams and map end-to-end data flows.
• Analyze designs including APIs, file interfaces, and transformations.
• Map and validate data across source/target systems; reconcile data.
• Use SQL and scripting to validate record counts and totals.
• Coordinate requirements with AML/BSA, Core Banking, and partners.
• Develop tests and support cutover, monitoring, and support readiness.

Skills

REST APIs

File-based interfaces

SQL

Data reconciliation

Data mapping

API testing

ETL/ELT pipelines

Documentation

Education

BS in Information Technology/CS

Tools

ETL platforms

API gateways

SFTP

Cloud environments

SQL tooling

Job description

TITLE: Senior Systems Integration Analyst STATUS: Exempt

MANAGER: Director, Business Analysis and Innovation

DEPARTMENT: Information Technology

SUMMARY:

The Systems Integration Analyst is a hands‑on individual contributor responsible for analyzing, implementing, testing, troubleshooting, and supporting enterprise system integrations and related technology initiatives. The role provides Bank-side technical ownership of data flows, APIs, file‑based interfaces, mappings, transformations, secure data delivery, validation, reconciliation, and production readiness. The analyst works directly with internal teams and external partners to trace issues end to end, automate repeatable validation where appropriate, and drive assigned technical workstreams to completion. The initial major assignment is the Banks phased AML platform replacement across Fintech and Core Banking; afterward, the role will support integration initiatives across the Bank. The position is in Oak Brook, Illinois.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Primary:

• Lead assigned integration workstreams and develop a clear understanding of source systems, target platforms, interfaces, dependencies, and end‑to‑end data flows.
• Analyze integration designs and requirements, including APIs, file‑based interfaces, schemas, transformations, authentication/connectivity, secure data delivery, processing schedules, controls, logging, error handling, retry/reprocessing, and monitoring.
• Analyze and map customer, account, transaction, payment, operational, and other data required for integrations; perform data profiling, source‑to‑target mapping, validation, and reconciliation.
• Use SQL, scripting, and related tools to compare source and target data, validate record counts and financial totals, identify missing, duplicate, or invalid records, confirm transformations, and automate repeatable validation and reconciliation checks.
• Work with internal teams and external partners to define, document, and validate interface requirements, clarify ownership, and coordinate technical dependencies and implementation activities.
• Review and challenge technical specifications, mappings, interface designs, assumptions and deliverables; identify gaps and ensure material issues are resolved before production.
• Translate business, operational, and regulatory needs into technical, data, integration and testing requirements; coordinate across business, technology, security, operations, Risk/Compliance, and external providers.
• Develop and execute integration and data‑validation tests and support end‑to‑end, regression, parallel, user acceptance, and production validation.
• Troubleshoot integration failures and data‑quality issues end to end by inspecting payloads, files, logs, errors, mappings, and reconciliation results; identify root cause and drive resolution and retesting.
• Manage assigned technical workstreams by tracking milestones, risks, assumptions, issues, dependencies, decisions, defects, readiness, and status; follow actions through closure and elevate material risks or delays.
• Support cutover, stabilization, and transition to ongoing support, including job/interface monitoring, failed processing, retry/reprocessing, reconciliation, incident management, escalation, and knowledge transfer.
• Maintain technical documentation, including data‑flow diagrams, interface inventories, source‑to‑target mappings, data lineage, reconciliation procedures, test evidence, implementation decisions, and support procedures.
• Apply reusable integration, testing and production‑readiness practices across Bank initiatives and onboard new data feeds or interfaces by defining requirements, validating exchanges, reconciling results, and establishing monitoring.

Initial Major Assignment - AML Platform Implementation:

• Serve as the primary Bank-side technical resource for the phased implementation of the new AML platform across Fintech and Core Banking.
• Understand the customer, account, ownership, transaction, and payment data required by the AML platform, including source systems, business meaning, relationships, and processing characteristics.
• Define and validate feed scope, source‑to‑target mappings, transaction‑code classifications, customer/account relationships, APIs/files, transformation rules, and integration dependencies.
• Trace representative records end to end from source systems through integration layers to the AML platform; validate payloads/files, control totals, rejected records, and error handling, and investigate delivery, mapping, or transformation failures.
• Perform SQL‑ and script‑based reconciliation between source systems and the AML platform to identify missing, duplicate, incomplete, or incorrectly mapped/transformed data and drive issues to resolution.
• Support historical data migration and establish repeatable controls for data completeness, accuracy and reconciliation.
• Coordinate integration testing, parallel validation, cutover readiness, production verification and defect resolution for each phase.
• Work with AML/BSA, Core Banking, Fintech, Operations, technology teams, and implementation partners to translate compliance and business needs into technical requirements.
• Ensure monitoring, reconciliation, documentation, knowledge transfer, and support procedures are in place before each production phase.

Secondary:

• Troubleshoot production integration and data issues spanning multiple systems or providers and coordinate resolution.
• Participate in technical due diligence, integration design reviews, and implementation planning for new technology platforms.
• Help improve the Banks integration standards, documentation, testing practices, production‑readiness controls, and implementation governance.
• Other duties as assigned.

MINIMUM KNOWLEDGE, SKILLS AND ABILITIES REQUIRED:

Experience: Minimum 7 years of progressive experience in systems integration, technical data analysis, application delivery, systems analysis, or related technology roles. Experience independently leading technical workstreams in multi‑system or multi‑provider implementations is required.

• Hands‑on systems integration - Strong proficiency: Experience implementing, testing, supporting, and troubleshooting enterprise integrations using REST APIs, file‑based interfaces, databases, middleware, and/or ETL/data pipelines. Must be able to interpret specifications, payloads, file layouts, schemas, mappings, logs, and errors and validate end‑to‑end processing.
• Integration troubleshooting - Strong hands‑on proficiency: Ability to trace data across source systems, integration layers, APIs/files, and target applications; isolate failures to data, mapping/transformation, connectivity/authentication, middleware, or target systems; and drive corrective action through resolution.
• SQL and data reconciliation - Strong hands‑on proficiency: Ability to write SQL using joins, aggregations, CASE expressions, subqueries, and common table expressions; profile data; compare source and target datasets; identify duplicates or anomalies; and reconcile record counts and monetary values.
• Data mapping and validation - Strong proficiency: Ability to understand data structures and business meaning, map fields and relationships, validate transformations, and trace data issues from source through downstream platforms.
• Integration design and operations - Strong proficiency: Ability to document end‑to‑end integration flows, dependencies, batch and real‑time processing, controls, error/retry handling, reconciliation, monitoring, and support requirements.
• APIs - Working hands‑on proficiency: Ability to interpret REST API specifications; inspect and validate JSON payloads; understand HTTP methods/status codes, OAuth 2.0, API keys, certificates, pagination, rate limits, and error handling; and execute test calls using an API‑testing tool.
• File‑based integrations - Strong proficiency: Experience with CSV, delimited/fixed‑width files, JSON/XML, SFTP, object storage or secure upload, scheduling, authentication, header/trailer controls, control totals, monitoring, error files, retry/reprocessing, and exception handling.
• ETL/ELT, pipelines, and scripting - Intermediate proficiency: Working knowledge of extraction, transformation, loading, scheduling, reprocessing, data lineage, and pipeline monitoring. Ability to use scripting or automation to create or validate extracts, parse files or payloads, compare datasets, and automate repeatable checks is required. Hands‑on development in a specific ETL platform is beneficial but not required.
• Testing - Strong proficiency: Ability to develop and execute integration, data‑validation, negative, regression, end‑to‑end, and production‑validation tests; support user acceptance testing; and document defects through closure.
• Spreadsheet analysis - Working proficiency: Ability to use pivot tables, lookup functions, formulas, filtering, comparison, and data‑transformation features for validation and reconciliation.
• Technical project delivery - Strong proficiency: Experience managing technical workstreams, milestones, dependencies, risks, issues, decisions, defects, external partners, and status reporting.
• External partner management: Ability to review technical deliverables, challenge assumptions, clarify responsibilities, coordinate issue resolution, and hold providers accountable for agreed outcomes.
• Communication and documentation: Strong written and verbal communication skills; ability to translate between business and technical stakeholders and produce clear requirements, mappings, diagrams, test evidence, decisions, and status updates.

Preferred knowledge and experience:

• Banking or financial‑services experience, especially with transaction‑intensive platforms such as core banking, payments, fintech, AML/fraud, or regulatory technology.
• Working knowledge of cloud environments, SaaS architectures, identity/access, secure connectivity, storage, and cloud integration patterns.
• Experience with integration patterns and technologies such as ETL/ELT platforms, integration‑platform-as‑a‑service, API gateways, webhooks, and queues/messaging; specific product expertise is not required.

EDUCATIONAL REQUIREMENTS:

BS degree in Information Technology/Systems, Computer Science, Information Systems, Engineering, or a related field, or an equivalent combination of education and directly relevant experience.

ADDITIONAL RESPONSIBILITIES:

Every employee of Republic Bank is responsible for knowing and practicing Bank Secrecy Laws (AML/CIP/SAR/CTR/OFAC), the USA Patriot Act, and other related regulations as they relate to their specific job function. Training will be provided during your Introductory Period and annually thereafter. If you need additional training, you are responsible for contacting your immediate supervisor.

OUR COMMITTMENT

Republic Bank of Chicago is fully committed to fostering a workplace culture where all individuals feel valued, respected, and empowered to thrive—because our most important asset is, and always will be, our people.

What We Offer

• A competitive salary range is estimated at $120,000 - $150,000 per year for this position. Final compensation will vary based on experience, skills, and qualifications.
• Generous Paid Time off to help you rest, recharge, and have a productive work / life balance.
• Health, dental, and vision insurance with tax‑advantaged FSA and HSA account options
• Retirement benefits including 401k plan with generous discretionary matching contributions
• Tuition reimbursement program for continuing education and professional development
• Parental Leave for both primary and secondary caregivers
• Childcare assistance program to support working parents and their eligible dependents
• Short‑term and long‑term disability coverage for long‑term income stability
• Basic Life and AD&D insurance with elective additional coverage for you, your spouse, or children
• Professional and personal skill development resources offered through bank‑paid LinkedIn Learning subscription
• Mental wellness benefits including Headspace meditation app subscription and access to our Employee Assistance Program

About Republic – Chicagos Hardworking Bank

Republic Bank has been dedicated to and deeply rooted in the communities we serve since 1964. We live where you live. We work where you work.

We are proud to serve local businesses and individual clients, contributing to their financial success.

At Republic Bank, we are building a team of talented and enthusiastic professionals who share our passion for doing right by others. We are committed to new ideas, new ways of thinking, and we have a focus on your development as a teammate, professional colleague, and respected partner to the business.

Our Core Values are not framed on the wall. They are the DNA that shapes how we think, act, and grow. From the boardroom to the breakroom, our values live in every colleague who is fortunate enough to serve our clients and communities:

• Put People First
• Lead with Integrity
• Deliberate Transparency
• Relentless Customer Focus
• Value Creation/Growth Mindset