Data Analyst

Join us as a "Data Analyst" at Barclays, where you'll build analytical tools to generate insight, recognise patterns and predict behavior, and deliver content direct to users of information products. You will work with technical teams, architects, designers, and administrators to overcome technical challenges and to make it happen.

To be successful as a "Data Analyst", you should have experience with:

Basic/ Essential Skills:

Core Technical Expertise

• Expert-level SQL - analytical queries, query optimization, complex transformations, performance tuning

• Lakehouse table formats: Delta Lake, Apache Iceberg.

• Data modeling: dimensional modeling, SCD Type 1/2/3

• Object storage & file formats: S3, Parquet

• Data transformation frameworks: dbt , databricks.

Data Quality, Governance & Metadata

• Metadata management, lineage, and data catalogs

• Fine-grained access control, PII handling, and data masking

Cloud & Platform Expertise

• Deep experience with at least one cloud platform (AWS)

• Hands-on expertise with lakehouse platforms (Databricks, Snowflake + Iceberg)

Functional Skills

• Strong understanding of business data requirements and KPIs

• Ability to translate business logic into curated datasets and metrics

• Data analysis mindset: identify anomalies, trends, and data issues

• Stakeholder collaboration with analytics, BI, and product teams

• Documentation of business rules, data definitions, and assumptions

• Understanding of data lifecycle, data ownership, and stewardship

Educational Qualification

• Graduation as a minimum

You may be assessed on the key critical skills relevant for success in role, such as experience with ownership of key initiatives to deliver results through an agile workflow. Will have to design, test and build complex forecast models and simulations to identify causal links between customer behavior and business opportunities and performance.as well as job-specific skillsets.

This role will be based out of Pune.

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. 

Analyst Expectations

• To perform prescribed activities in a timely manner and to a high standard consistently driving continuous improvement.
• Requires in-depth technical knowledge and experience in their assigned area of expertise
• Thorough understanding of the underlying principles and concepts within the area of expertise
• They lead and supervise a team, guiding and supporting professional development, allocating work requirements and coordinating team resources.
• 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 develop technical expertise in work area, acting as an advisor where appropriate.
• Will have an impact on the work of related teams within the area.
• Partner with other functions and business areas.
• Takes responsibility for end results of a team’s operational processing and activities.
• Escalate breaches of policies / procedure appropriately.
• Take responsibility for embedding new policies/ procedures adopted due to risk mitigation.
• Advise and influence decision making within own area of expertise.
• Take ownership for managing risk and strengthening controls in relation to the work you own or contribute to. Deliver your work and areas of responsibility in line with relevant rules, regulation and codes of conduct.
• Maintain and continually build an understanding of how own sub-function integrates with function, alongside knowledge of the organisations products, services and processes within the function.
• Demonstrate understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Make evaluative judgements based on the analysis of factual information, paying attention to detail.
• Resolve problems by identifying and selecting solutions through the application of acquired technical experience and will be guided by precedents.
• Guide and persuade team members and communicate complex / sensitive information.
• Act as contact point for stakeholders outside of the immediate function, while building a network of contacts outside team and external to the organisation.

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.