Associate Consultant supporting risk management and control testing activities in technology sector across multiple operational areas. Focusing on risk management initiatives in a flexible, collaborative work culture.
PN
Hybrid Senior Business Analytics Consultant – Lending Analytics, Tableau
Posted last month
About the role
- Senior Business Analytics Consultant advancing data engineering and reporting capabilities at PNC. Maintaining data pipelines powering critical Tableau dashboards for Retail Lending.
Responsibilities
- Own, enhance, and maintain data pipelines powering Tableau data sources and Lending dashboards.
- Run, analyze, troubleshoot, and optimize complex SQL across MS SQL Server, Teradata, Oracle, Impala/Hadoop, and SharePoint.
- Use internal Python libraries to connect to databases and generate hyper extracts via the Tableau Hyper API.
- Work with version controlled SQL to maintain consistency across environments.
- Support Tableau Server data sources, extracts, permissions, and performance tuning.
- Develop and optimize Tableau data models, including relational and multi fact structures.
- Partner with business stakeholders to translate requirements into analytics solutions.
- Serve as SME for lending sales data, KPIs, and reporting structures.
Requirements
- Expert SQL skills with ability to diagnose, optimize, and document complex queries.
- Strong experience with MS SQL Server, Teradata, Oracle, Hadoop/Impala, SharePoint.
- Python experience including database connectivity and extract automation.
- Tableau Desktop/Server experience including data modeling and performance best practices.
- Understanding of relational modeling, joins, and Tableau query generation.
- Lending platforms familiarity preferred.
- Strong communication and analytical reasoning.
- 3+ years of relevant analytics, BI, data engineering, or data management experience.
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
- 9 occasional absence days each year, unless otherwise required by law
- 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
Consultant at Red Hat working on organizational transformations through innovative software solutions in Brazil. Collaborating with clients and team to deliver technology implementations.
Cloud Consultant assisting in the implementation of Red Hat solutions for clients in Brazil. Focused on the design, deployment, and management of cloud infrastructures.
Consultant ensuring Red Hat technology engagements are transformational through Ansible solutions and Agile methodologies while collaborating with cross - functional teams in Brazil.
Project Manager or Junior Consultant for ERP implementations at SSH Software, leading client projects and facilitating trainings and support.
Property Consultant managing property movement and inventory for the Department of Elder Affairs. Assisting in record retention, building maintenance, and property transfers.
Crop Consultant role at Nutrien selling agricultural products and services within assigned territory in California. Responsibilities include maintaining sales goals, providing training, and conducting agronomic research.
Crop Consultant developing agricultural input sales at Nutrien. Interacting with growers and managing sales to meet profit goals in New Boston, IL.
Solution Consultant focusing on HCM expertise for Workday in Manufacturing, Consumer Goods, Utilities, & Energy sectors. Delivering technical presentations and supporting sales through an interactive pre - sales process.
SuccessFactors Talent Consultant responsible for implementation of SuccessFactors modules and ensuring quality delivery. Engaging in both client - facing and internal activities for successful project completion.