Principal Oracle Business Systems Analyst at Entrust driving solution strategy and optimizing Oracle Cloud ERP applications for global business processes.
PN
Hybrid Business Systems Analyst Consultant – SQL, Data Mapping, Oracle
Posted 4 months ago
About the role
- 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
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Lead Business Systems Analyst managing travel servicing applications integration at Amex GBT. Responsible for testing, pilot activities, and coordinating user validations in travel technology.
Virtualization Enterprise Systems Engineer managing VMware ESX infrastructure for Leidos' mission - critical environments. Focused on security compliance and operations management in Huntsville, AL.
Information Security Systems Engineer working closely with Government clients to apply security practices. Integrating systems security methods and technologies for L3Harris Technologies.
Network Engineer leading a team in network architecture design and troubleshooting. Involves collaboration with various network vendors and ensuring network security.
Senior Lead Networking Specialist responsible for designing, implementing, and maintaining complex network infrastructures at First American Bank. Focusing on scalability and high availability across network environments.
Lead Systems Engineer overseeing high - performing engineering team and ensuring reliable delivery of critical systems. Collaborating with stakeholders to drive continuous improvement and manage operations effectively.
Associate supporting asset management for commercial real estate debt investments at advisory firm. Responsibilities include data analysis, workflow automation, and collaboration with investment team.
Business Systems Engineer on Global e‑Commerce and ERP team translating business requirements into technical specifications. Collaborating with TPMs, developers, and operations teams for robust automated solutions.
Embedded Systems Engineer developing firmware and integrating software for smart locker solutions at Bloq.it. Focusing on firmware development, debugging system - level issues, and producing technical documentation in a hybrid work environment.