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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonTableaudata modelingperformance tuningrelational modelingextract automationcomplex queriesdata pipelineshyper extracts

Soft Skills

communicationanalytical reasoning