Oracle Data Architect - Linux Hadoop Python jobs at Pnc

• Manages all aspects of a data warehouse such as data sourcing, migration, quality, design, and implementation. Directs and develops staff who are dedicated to the development, upkeep and integrity of data warehouses.
• Oversees the work of IT and business customers in developing requirements and design specifications for complex data warehouse systems.
• Leads and manages data warehouse staff while focusing on the development, maintenance and integrity of the organization's data warehouse.
• Conducts performance reviews and determines professional development needs and opportunities for staff.
• Identifies new initiatives and/or recommendations for database growth and integration.

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 PNC's Enterprise Risk Management Framework.

PNC also has fundamental expectations of our people managers. As a manager of talent in PNC, you will be expected to:

• Include Intentionally - Cultivates diverse teams and inclusive workplaces to expand thinking.
• Live the Values - Role models our values with transparency and courage.
• Enable Change - Takes action to drive change and innovation that will transform our business.
• Achieve Results - Takes personal ownership to deliver results. Empowers and trusts others in decision making.
• Develop the Best - Raises the bar with every talent decision and guides the achievement of all employees and customers.

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and requiredneeded to be successful in this position.

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.

Refer to the

• Participates in defining functional designs and application systems architecture across all technologies and platforms.
• Designs an application's technical infrastructure, such as specific databases, programming languages, utilities, and testing approaches.
• Participates in the assessment of software defects discovered during the quality assurance process.
• Participates in addressing enterprise-wide platform and technology requirements for applications.
• Develops detailed programming instructions to solve business problems through automation support.

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 PNC's 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 requiredneeded to be successful in this position.

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.

Refer to the

• Provides guidance and advice on business architecture designs in complex projects, resolves difficult problems and ensures that all deliverables meet high standards in quality.
• Designs business architecture procedures, such as the target operating model and roadmap, while considering business strategies and goals.
• Consults on best practices for junior staff in business architecture planning, processes, data modeling and business architecture tools (e.g. UML and BPMN.)
• Provides a systematic analysis on client requirements within the traceability framework and resolves any functional problems encountered.
• Oversees the quality of business architecture project deliverables while ensuring that they are in compliance with relevant standards and processes.

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 PNC's 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 requiredneeded to be successful in this position.

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.

Refer to the

• Supervises fund closing, fund performance and reporting.
• Leads all aspects of new fund offerings including reviewing and approving overall investment model, distributing fund-level information to institutional investors and senior management, and participating in the fund closing process.
• Supervises overall fund performance, including yield maintenance through investors, both through financial modeling and oversight of transaction level performance. Performs working capital reserve analysis and recommends fee recognition and distribution. Participates in specific conversations with investors. Communicates internal revenue and budget results from syndication to senior managers.
• Reviews timing and proposed uses of investment fund capital. Supervises the process of calling investor capital to ensure maximum fund performance. Establishes quality control procedures for the capital call process as needed to ensure congruence with fund and transaction level documents.
• Motivates and develops staff which includes, acquiring top talent and managing performance based issues. Effectively plans, organizes, directs, analyzes and evaluates staff and processes. Connects strategy to day-to-day activities and updates the team on a regular basis.

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 PNC's Enterprise Risk Management Framework.

PNC also has fundamental expectations of our people managers. As a manager of talent in PNC, you will be expected to:

• Include Intentionally - Cultivates diverse teams and inclusive workplaces to expand thinking.
• Live the Values - Role models our values with transparency and courage.
• Enable Change - Takes action to drive change and innovation that will transform our business.
• Achieve Results - Takes personal ownership to deliver results. Empowers and trusts others in decision making.
• Develop the Best - Raises the bar with every talent decision and guides the achievement of all employees and customers.

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and requiredneeded to be successful in this position.

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.

Refer to the

• Provides detailed technical design and development of software solutions using existing and emerging technology platforms.
• Proposes & designs software solutions to address complex business needs.
• Writes code, tests and deploys software.
• Prepares technical and procedural documentation required for software.
• Maintains and debugs software.

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 PNC's 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 requiredneeded to be successful in this position.

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.

Refer to the

• Communicates effective compliance programs to identify and prevent illegal, unethical, or improper business practices. Coaches and mentors junior staff and raises issues to senior team members. Demonstrates ability to constructively challenge the status quo.
• Supports key business initiatives by analyzing and drawing conclusions from data to identify compliance risks. Provides resolutions to manage and mitigate the identified risks. If necessary, escalates identified risks to senior team members. Identifies compliance impact on matters such as marketing materials, sales programs, product development, documentation review and other business initiatives. Works cooperatively with the business, legal partners, audit and other risk disciplines across the organization.
• Assesses activity for existing and emerging risks. Evaluates the materiality of the risks identified and presents recommendations on necessary risk mitigation. Uses knowledge on current laws, rules, and other regulatory requirements and drafts or assesses Compliance Manuals, Front Office materials, policies and procedures to ensure alignment.
• Leads the compliance monitoring program and reviews activity to ensure it falls within established risk control limits. Helps to identify and define the compliance program objectives for assigned area, products/services, and applicable regulations. Communicates and socializes compliance program objectives to senior business partners. Independently challenges analyses and formulates insightful recommendations.
• Reviews compliance reports to identify deeper issues and common themes. Escalates issues through proper governance channels as needed, and recommends corrective action plans. Mentors and coaches junior staff on report analysis techniques as applicable. Updates and implements new/enhanced reports in order to ensure timely and effective compliance with regulatory requirements.

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 PNC's 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 requiredneeded to be successful in this position.

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.

Refer to the

Master’s degree in Analytics, Economics, Engineering, Statistics, Mathematics, or Information Systems Management plus 3 years of experience in data querying with SQL and programming in Python for developing applications for a large organization (>10,000 employees) is required. Must have experience with: (i) handling, manipulation and analysis of large datasets (multiple gigabytes of data) persisted on Hadoop, Neo4j and cloud data platforms; (ii) using statistical analysis techniques including logistic regression, time series analysis, and hypothesis testing; (iii) utilizing data query tools including SQL, R, and Python to manipulate, analyze and interpret data; (iv) writing and implementing code to clean and transform large tabular and text datasets (typically exceeding 1 million rows of data) to a consistent format usable in data visualization and developing machine learning models; (v) enriching in-house data by integrating with external data sources (Bureau and third party vendor data) to extract and analyze trends for risk management; (vi) designing rich data visualizations to communicate complex ideas to customers or company leaders; (vii) programmatically extracting data from a Hadoop database and transforming the data into a presentable form using Python plotting libraries (Matplotlib and Seaborn) and Tableau visualizations; and (viii) building machine learning models to drive business insights and improve financial outcomes.

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.

Refer to the