Pensions & Benefits System Consultant managing systems and data for Zurich's UK pension arrangements. Collaborating to deliver effective services and continuous improvement initiatives with a supportive team.
PN
Hybrid Senior Business Analytics Consultant – Lending Analytics, Tableau
Posted 2 months ago
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 working on multiple projects in the manufacturing sector for renewables. Engaging with stakeholders and ensuring project success across various initiatives.
SAP SuccessFactors Consultant at HR Path Group implementing HRIS projects for international clients. Managing various HR functionalities and collaborating closely with project teams throughout the implementation process.
Senior Talend Consultant responsible for regulatory compliance in Data Management Office. Engaging in functional analysis, technical specifications, and job development in hybrid environment.
Wellbeing and Leadership Trainer and Coach for the Changemakers programme to enhance personal and community wellbeing in contexts of conflict and violence.
Technology Advisory Consultant helping organizations drive digital transformation and operational efficiency. Join a team that translates business goals into tech solutions with a focus on growth sectors.
Investment Strategy & Competitive Intelligence Consultant at Medtronic, translating business insights for executive - level decisions. Lead competitive intelligence for Neuromodulation, improving healthcare access and equity.
Professional Services Consultant delivering AI - powered customer experience solutions for organizations. Designing, implementing, and optimizing Genesys Cloud solutions to enhance engagement.
Consultant QSE in alternance contributing to environmental and safety studies at Bureau Veritas. Engaging with clients on regulatory compliance and risk assessment within a team in Rouen.
Consultant in digital analytics focusing on Adobe solutions at Deloitte. Collaborating on strategic digital analytics projects with leading companies in a hybrid work model.