Business Systems Analyst Sr API, ETL, SQL
Denver, CO - USA
Job Summary
within PNCs Retail Technology organization you can be based in Pittsburgh PA; Strongsville OH; Cleveland OH; Birmingham AL; Phoenix AZ; Lakewood CO.PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We encourage candidates to connect with their recruiter and hiring manager to understand workplace expectations and ensure the role aligns with their goals.PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.
Core Responsibilities
- Effectively gather integration requirements translate business needs into clear Agile stories and validate data outcomes
- Partner with business stakeholders to elicit analyze document and validate requirements
- Translate business needs into epics user stories functional requirements and acceptance criteria
- Participate actively in Agile/Scrum ceremonies (backlog grooming sprint planning reviews retrospectives)
- Perform current-state and future-state analysis including process flows and gap analysis
- Collaborate with engineering teams on API-based integrations and system interfaces
- Support data-related initiatives including ETL processes and data transformations using Informatica
- Analyze and validate data using SQL and relational databases
- Ensure requirements are traceable prioritized and aligned with business and regulatory needs
- Act as a key liaison between business product and technical teams
- Working knowledge of API-based integrations including RESTful services request/response structures and error handling
- Ability to perform current-state and future-state analysis including process flows gap analysis and impact assessments
- Hands-on experience analyzing and validating data using SQL across relational databases such as Oracle SQL Server Teradata and MongoDB
- Familiarity with ETL concepts and data flow architectures including data ingestion transformation and downstream consumption
- Experience supporting data transformation and integration initiatives using tools such as Informatica (PowerCenter/PowerExchange) from a requirements and validation perspective
- Strong understanding of data quality data lineage and reconciliation techniques to support accurate analytics and reporting
- Ability to create and maintain process diagrams data models and interface specifications to support technical design
- Experience ensuring requirements traceability from business objectives through development testing and delivery
- Strong experience partnering with business and technical stakeholders to define clear testable functional and non-functional requirements
- Comfortable working in Agile/Scrum environments collaborating closely with Product Owners engineers and QA throughout the SDLC
PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:
- Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
- Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNCs Enterprise Risk Management Framework.
Successful candidates must demonstrate appropriate knowledge skills and abilities for a role. Listed below are skills competencies work experience education and required certifications/licensures needed to be successful in this position.
To learn more about these and other programs including benefits for full time and part-time employees visit.
If an accommodation is required to participate in the application process please contact us via email at . Please include accommodation request in the subject line title and be sure to include your name the job ID and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses. Applicants may also call and say Workday for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.
At PNC we foster an inclusive and accessible workplace. We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions.
PNC provides equal employment opportunity to qualified persons regardless of race color sex religion national origin age sexual orientation gender identity disability veteran status or other categories protected by law.
This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and for any registered role the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA) which prohibit the hiring of individuals with certain criminal history.
Required Experience:
Senior IC