Finance Data Analysis AVP

Barclays•Wilmington, DE

2d•Hybrid

About The Position

The purpose of the role is 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 visualizations and reports. This involves investigating and analyzing data issues related to quality, lineage, controls, and authoritative source identification, documenting data sources, methodologies, and quality findings with recommendations for improvement. It also includes designing and building data pipelines to automate data movement and processing, applying advanced analytical techniques to large datasets to uncover trends and correlations, developing validated logical data models, and translating insights into actionable business recommendations that drive operational and process improvements, leveraging machine learning/AI. The role also involves designing and creating interactive dashboards and visual reports using applicable tools and automating reporting processes for regular and ad-hoc stakeholder needs.

Requirements

Utilize quantitative and qualitative analytical skills to provide financial and data analysis and reporting for Consumer, Risk, Finance, Treasury, and Liquidity (CRFTL) and Management Information (MI).
Provide frontline support to CRFTL requests of new MI projects, including testing and data verification and data quality issues.
Build and maintain data architectures pipelines that enable the transfer and processing of durable, complete and consistent data.
Perform data extraction, aggregation, analyze, design, implement, and modify business processes to optimize capabilities and improve efficiency to support financial analysis.
Operate production and ad hoc processes to deliver MIS for segment level reporting purposes using SAS, SQL, and Excel.
Integrate reporting from various systems to develop unified and comprehensive views of the business.
Provide and maintain all database documentation including business requirements, workflows, standard procedures, and user guides.
Perform the review and data quality processes that ensure the accuracy of the data reported for financial and regulatory purposes.
Design, develop and implement controls on current DataMart to make sure it operates in control fashion and pass internal and external audit.
Design and implementation of data warehouses and data lakes that manage the appropriate data volumes and velocity and adhere to the required security measures.
Design, development and production of value-add Management Information reports for the US Consumer Banking Chief Financial Officer Management Information (USCB CFO MI).
Accountable for timely, accurate and credible production of scheduled and adhoc MI reports and analytics, leveraging SAS and Essbase.
Develop and operate processes to deliver MIS for regulatory reporting purposes.
Develop data-mining and mathematical models including business optimization and monitoring procedures that provide key guidance to business stakeholders.

Nice To Haves

Leveraging machine learning/AI.
May telecommute pursuant to company policies.

Responsibilities

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.
Translate insights into actionable business recommendations that drive operational and process improvements, leveraging machine learning/AI.
Design and create interactive dashboards and visual reports using applicable tools.
Automate reporting processes for regular and ad-hoc stakeholder needs.
Advise and influence decision making.
Contribute to policy development.
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.
Lead collaborative assignments and guide team members through structured assignments.
Identify the need for the inclusion of other areas of specialisation to complete assignments.
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.
Influence or convince stakeholders to achieve outcomes.
Utilize quantitative and qualitative analytical skills to provide financial and data analysis and reporting for Consumer, Risk, Finance, Treasury, and Liquidity (CRFTL) and Management Information (MI).
Provide frontline support to CRFTL requests of new MI projects, including testing and data verification and data quality issues.
Build and maintain data architectures pipelines that enable the transfer and processing of durable, complete and consistent data.
Perform data extraction, aggregation, analyze, design, implement, and modify business processes to optimize capabilities and improve efficiency to support financial analysis.
Operate production and ad hoc processes to deliver MIS for segment level reporting purposes using SAS, SQL, and Excel.
Integrate reporting from various systems to develop unified and comprehensive views of the business.
Provide and maintain all database documentation including business requirements, workflows, standard procedures, and user guides.
Perform the review and data quality processes that ensure the accuracy of the data reported for financial and regulatory purposes.
Design, develop and implement controls on current DataMart to make sure it operates in control fashion and pass internal and external audit.
Design and implementation of data warehouses and data lakes that manage the appropriate data volumes and velocity and adhere to the required security measures.
Design, development and production of value-add Management Information reports for the US Consumer Banking Chief Financial Officer Management Information (USCB CFO MI).
Accountable for timely, accurate and credible production of scheduled and adhoc MI reports and analytics, leveraging SAS and Essbase.
Develop and operate processes to deliver MIS for regulatory reporting purposes.
Develop data-mining and mathematical models including business optimization and monitoring procedures that provide key guidance to business stakeholders.