Business Analytics Consultant Senior-Lending Analytics and Tableau
Pittsburgh, PA - USA
Job Summary
We are seeking a Business Analytics Consultant Senior to join the Retail Lending Reporting and Analytics organization supporting one of the largest and most active analytics sites at PNC. Our team builds and maintains the end to end data pipeline that powers critical Tableau dashboards a custom JavaScript/HTML reporting portal and a broad suite of analytics used across Retail Lending business lines.
You will play a key role in advancing our data engineering and reporting capabilities ensuring our analytics ecosystem is accurate high performing scalable and strategically aligned with enterprise priorities.
Key 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.
Preferred Skills & Experience
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.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.
- Leverages complex analytical tools to provide business and technical expertise for the analytics process tools and useful applications across multiple functions or business units to create data driven solutions.
- Consulting to clients on tool and strategy implementation and monitoring statistical scoring business intelligence data quality and analytical product / solution development.
- Determining the optimal analytic approach and supporting development implementation and enhancements.
- Conceptualizing developing and continuously optimizing analytical solutions for business leadership to enable data driven decision making.
- Analyze results and make recommendations for key business partners and senior management or communicate conclusions from complex analytical solutions to a wide range of audiences.
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