Hybrid Business Systems Analyst Consultant – SQL, Data Mapping, Oracle

at PNC

• Job title: Business Systems Analyst Consultant – SQL, Data Mapping, Oracle
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: $55,000 - $120,750 per year
• Degree requirement: Bachelor's Degree
• Tech skills: Microservices, MySQL, Oracle, SQL
• Location requirements: Hybrid, Dallas, United States

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