BUSINESS ANALYTICS LEAD
Company: The PNC Financial Services Group, Inc.
Location: Lawrenceville
Posted on: June 25, 2022
|
|
Job Description:
BUSINESS ANALYTICS LEAD
The PNC Financial Services Group, Inc. seeks a Business Analytics
Lead in Pittsburgh, PA. Specific duties include: (i) source
appropriate data, apply analytical method(s), interpret the
resulting information and then construct an understandable visual
representation in the analysis; (ii) serve as a subject matter
expert of lending sales data; (iii) build and publish Customized
interactive Dashboards, KPI in Tableau Desktop and Report
scheduling using Tableau Server; (iv) understand complex business
rules and combine salespeople, managers, geographies and
hierarchies, and sales activities with loan application and
servicing systems to provide insights for business leaders in a
repeatable and highly available reporting environment; (v) design,
develop and implement various information related deliverables,
including KPI, performance reporting, Tableau dashboards and
self-service analytical tools; (vi) own the production and
maintenance of metrics, KPI and performance related reporting and
dashboards for BI stakeholders; (vii) act in a consultative role
with business leaders to implement and drive adoption of metrics
and KPIs; (viii) drive to one source of truth across the business;
and (ix) own end-to-end lifecycle for deliverables including
requirements gathering, technical development, refinement, adoption
and maintenance as a member of a high performing agile crew; and
adding value from outset through technical, analytical, and
problem-solving skills. Position requires a Bachelor's degree in
Computer Science, Technology, Software Engineering, Computer
Engineering, Information Technology, or Information Systems, plus 5
years of experience in position(s) that involves designing,
building, and maintaining data, reporting, and analytical
systems.
Experience required with the following: (i) developing,
maintaining, and optimizing Tableau dashboards, including
management of Tableau Server user groups and permissions; (ii)
embedding tableau dashboards in the other systems, including custom
web portals; (iii) developing complex SQL (including stored
procedures, functions, materialized views, common table
expressions, analytical functions, performance tuning, and
partitioning) and ETL processes (aggregations, complicated joins,
rank, union, lookup, and custom user defined functions) with
advanced features and functionally of multiple data sources (Oracle
SQL, Teradata, MS SQL Server, Hadoop, and Hyper); (iv) automating
(incremental processing, dependency and schedule management, and
error checking) and maintaining complex data transformation
pipelines (Tableau Prep, Alteryx, Python, Oozie, and SSIS); and (v)
experience, in or for the financial services industry, performing
the following: (a) utilizing lending systems, application and loan
servicing data models (Empower, OLNACS, EDS, Capital Stream, MSP,
ACLS, or FDR), and sales management systems (ADAPT, TIM, Workday,
Genesis, CIM, or Salesforce) in production and support of analytics
and reporting; (b) interviewing business users; (c) identifying
functional and technical requirements; and (d) converting use cases
into technical designs (LLD and User Case Diagrams) and solutions
(prototypes and mock-ups) as part of an agile software development
process (version One of Jira).
40 hours/week, 8:00 a.m. -5:00 p.m. Interested individuals apply
online at www.pnc.com using keyword R104663. 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.
Keywords: The PNC Financial Services Group, Inc., Syracuse , BUSINESS ANALYTICS LEAD, Other , Lawrenceville, New York
Click
here to apply!
|