BUSINESS ANALYTICS LEAD
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.