Senior Data Analytics Developer

Barclays•Jefferson, CO

22h•$169,541 - $185,000•Hybrid

About The Position

The purpose of the role is to support the bank's decision-making processes by providing timely, accurate, and insightful information through designing, developing, and maintaining management reports, compelling visualisations and dashboards that effectively communicate key performance indicators (KPIs), data insights and trends across various business units. This role involves designing and developing comprehensive reports and dashboards utilizing best practices in data visualization principles and design aesthetics to ensure clarity, accuracy, and accessibility. It also includes the design, development, and implementation of automated report generation processes and visualization methodologies for improved efficiency and timeliness. The role requires identification and analysis of business requirements to define report content and format, as well as maintenance and updating of existing reports and dashboards to reflect changing business needs. Development of robust processes and controls for collating input data, performing exploratory data analysis, data cleansing, and seeking signoffs are also key responsibilities. Engagement with stakeholders is necessary to ensure up-to-date data is incorporated into reporting and visualizations.

Requirements

Build reports using financial and Client Relationship Management (CRM) data points using visualization tools like Tableau and Qlik, augmented by custom extensions using Angular.
Design and build multidimensional reporting data marts and build Extract-Transform-Load (ETL) pipeline using pyspark and SQL Server Integration Services (SSIS).
Design end to end solution architecture with C4 model diagrams – (Context, Component, Container, Code) and collaborate with the Chief Data Office (CDO) and Chief Technology Office (CTO) colleagues.
Clearly articulate different viable technical solutions with their Pros and Cons.
Work with multiple teams (like – Product Management, QA, UX Design etc) to ensure delivery of quality product to end user and multitask within an Agile software development framework.
Interact directly with various business users to understand their requirements and clearly articulate different viable technical solutions with their Pros and Cons.

Nice To Haves

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.
Demonstrate leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard.
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.
Demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship.
Demonstrate the Barclays Mindset – to Empower, Challenge and Drive.

Responsibilities

Design and development of comprehensive reports and dashboards utilising best practices in data visualisation principles and design aesthetics to ensure clarity, accuracy, and accessibility.
Design, development and implementation of automated report generation processes and visualisation methodologies for improved efficiency and timeliness.
Identification and analysis of business requirements to define report content and format.
Maintenance and updating of existing reports and dashboards to reflect changing business needs, including co-ordination of reporting template releases and related administrative tasks.
Development of robust processes & controls for collating input data, performing exploratory data analysis & data cleansing and seeking signoffs as required.
Engagement with stakeholders as needed to ensure up to date data is incorporated into reporting and visualisations.
Build reports using financial and Client Relationship Management (CRM) data points using visualization tools like Tableau and Qlik, augmented by custom extensions using Angular.
Design and build multidimensional reporting data marts and build Extract-Transform-Load (ETL) pipeline using pyspark and SQL Server Integration Services (SSIS).
Design end to end solution architecture with C4 model diagrams – (Context, Component, Container, Code) and collaborate with the Chief Data Office (CDO) and Chief Technology Office (CTO) colleagues.
Clearly articulate different viable technical solutions with their Pros and Cons.
Work with multiple teams (like – Product Management, QA, UX Design etc) to ensure delivery of quality product to end user and multitask within an Agile software development framework.
Interact directly with various business users to understand their requirements and clearly articulate different viable technical solutions with their Pros and Cons.