Business Systems Analyst Consultant focusing on SQL and Data Mapping at PNC. Collaborating with teams to define requirements and validate business logic for banking features.
Responsibilities
Collaborate with Product and Compliance teams to define requirements for core banking features
Ensure all requirements explicitly address regulatory constraints
Identify and document non-functional requirements
Write detailed User Stories with acceptance criteria that account for financial edge cases
Perform detailed Data Mapping between modern digital channels (Web/Mobile) and legacy Core Banking Systems
Use SQL to query MySQL/Oracle databases to validate business logic and investigate production data discrepancies
Analyze API specs to define integration contracts (Request/Response models)
Create sequence diagrams to visualize the flow of funds and data across microservices
Requirements
3+ years of relevant / direct industry experience
Bachelor's degree
CBAP (Certified Business Analysis Professional) certification preferred
Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions
Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.
Benefits
medical/prescription drug coverage (with a Health Savings Account feature)
dental and vision options
employee and spouse/child life insurance
short and long-term disability protection
401(k) with PNC match
pension and stock purchase plans
dependent care reimbursement account
back-up child/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
a robust wellness program with financial incentives
maternity and/or parental leave
up to 11 paid holidays each year
8 occasional absence days each year
between 15 to 25 vacation days each year, depending on career level; and years of service
Job title
Business Systems Analyst Consultant – SQL, Data Mapping, Oracle
Systems Engineer specializing in defence systems at Babcock. Designing and integrating complex systems to ensure operational success with multidisciplinary teams in Fife.
Senior Mission Systems Engineer contributing to design and integration of mission - critical systems for naval platforms at Babcock. Engaging with customers and managing suppliers to deliver advanced capabilities.
Mission Systems Engineer developing naval mission systems at Babcock. Involves integrating Combat, Communications, and Navigation Systems into advanced ship designs.
Principal Mission Systems Engineer leading design and integration of mission - critical systems for naval platforms. Engaging with customers and managing risk to deliver advanced capabilities in a hybrid work environment.
Principal Systems Engineer leading systems engineering efforts within complex defence programmes at Babcock. Collaborating with a team to define strategies and ensure compliance throughout the project lifecycle.
Design System Designer at Saab working on product tech design systems and UI components for better user experiences. Collaborating with teams to iterate on design systems and support scalable digital products.
Trainee in IT focusing on system integration at Fraunhofer Institute in Aachen. Engaging in project work and hands - on training in IT environments for future - oriented technology.
Praktikant:in Fachinformatiker:in Systemintegration für Langzeitpraktikum im AGAPLESION BETHESDA KRANKENHAUS. Einarbeitung, Unterstützung in Projekten und Einsätze in der IT - Abteilung.
Embark on an IT apprenticeship focusing on system integration at VRG GmbH in Oldenburg. Experience practical training while gaining theoretical knowledge for three years.