Analytics Assurance - AVP

Barclays Bank US; Wilmington (DE); Hybrid; USD 120,000 - 190,000; Full time

Benefits offered by this job

Barclays Employee Referral Program

Job summary

Barclays is seeking an Analytics Assurance – AVP in Wilmington, DE to extract insights from large datasets, design data pipelines, and build dashboards for data-driven decision making. You will leverage SAS, Python, Tableau and SQL to support remediation efforts and issue resolution across consumer and commercial portfolios.

The role involves advanced analytics, data validation, and collaboration with multiple business units.

Qualifications

• Proficient in SAS, SQL and scripting for data extraction and validation.
• Experience building dashboards and visual reports for stakeholders.
• Strong analytical skills to identify data quality issues and remediation opportunities.
• Experience in leading or collaborating with cross-functional teams at AVP level.

Responsibilities

• Investigate data issues related to quality, lineage, controls, and source identification, documenting sources, methods, and quality findings with recommendations.
• Design and build data pipelines to automate data movement and processing.
• Apply advanced analytics to large datasets to uncover trends and translate insights into business recommendations that improve operations.
• Translate analytical findings into actionable business decisions and process improvements.
• Create interactive dashboards and visual reports, and automate reporting for stakeholders.

Skills

SAS programming

Python

Tableau

SQL

Oracle SQL

UNIX scripting

SAS Grid

PL/SQL

SQL Loader

Visual Basic

Data visualization

Data pipelines

Tools

TSYS mainframe

Unix Shell

Job description

What will you be doing?

Barclays Services LLC seeks Analytics Assurance – AVP in Wilmington, DE (multiple positions available):

• Examine data repositories and generate periodic reports to assist with resolution of consumer and commercial card and loan bank wide issues for the Customer Remediation Team (“CRT”) within Barclays Customer Delivery business.
• Create complex queries utilizing SAS, Python, and Tableau to extract data from multiple data sources.
• Utilize SAS to query bank databases to identify accounts impacted by opened incidents.
• Utilize SQL and Oracle SQL programming to extract, load, and transform customer specific data.
• Utilize SAS analytics and SAS Grid to design and create datasets from various sources including MS excel, MS Access, flat files, and Oracle files.
• Utilize UNIX scripts for automating processes and integration within existing operational framework.
• Utilize TSYS mainframe through Visual basic and SAS Scripts as per test scenarios to condition test data and validate test results.
• Utilize PL/SQL and SQL loader calling Unix Scripts to download and manipulate files.
• Responsible for developing UNIX Shell scripts for Batch processing of data files to update accounts.
• Identify accounts as defined by business requirements.
• Ensure the validation of files and assist in making changes as needed based on requirements and the creation of batch update files.
• Compile and validate lists and apply remediation treatment on impacted accounts.
• May telecommute pursuant to company policies (hybrid role).

This position is eligible for incentives pursuant to Barclays Employee Referral Program.

Purpose of the role

To enable data-driven strategic and operational decision making through extracting actionable insights from large datasets, performing statistical and advanced analytics to uncover trends and patterns, and presenting findings through clear visualisations and reports.

Accountabilities

• Investigation and analysis of data issues related to quality, lineage, controls, and authoritative source identification, documenting data sources, methodologies, and quality findings with recommendations for improvement.
• Designing and building data pipelines to automate data movement and processing.
• Apply advanced analytical techniques to large datasets to uncover trends and correlations, develop validated logical data models, and translate insights into actionable business recommendations that drive operational and process improvements, leveraging machine learning/AI.
• Through data-driven analysis, translate analytical findings into actionable business recommendations, identifying opportunities for operational and process improvements.
• Design and create interactive dashboards and visual reports using applicable tools and automate reporting processes for regular and ad-hoc stakeholder needs.

Assistant Vice President Expectations

• To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions.
• Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes
• If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L - Listen and be authentic, E - Energise and inspire, A - Align across the enterprise, D - Develop others.
• OR for an individual contributor, they will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes.
• Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.
• Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda.
• Take ownership for managing risk and strengthening controls in relation to the work done.
• Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy.
• Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc).to solve problems creatively and effectively.
• Communicate complex information. 'Complex' information could include sensitive information or information that is difficult to communicate because of its content or its audience.
• Influence or convince stakeholders to achieve outcomes.

All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship – our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Barclays Mindset – to Empower, Challenge and Drive – the operating manual for how we behave.