Barclays Hiring Data Analyst in Pune | Data & SQL Role

Purpose of the Role

The role focuses on supporting data-driven strategic and operational decision making by extracting actionable insights from large datasets. It involves performing statistical and advanced analytics to identify trends and patterns, then presenting results through clear reports and visualisations.

Key Accountabilities

• Investigate and analyse data quality, lineage, controls, and authoritative sources. Document data sources, methodologies, and quality findings with recommendations for improvement.
• Design and build data pipelines that automate the movement and processing of data.
• Apply advanced analytical methods on large datasets to identify trends and correlations, create logical data models, and convert insights into practical business recommendations that support operational improvement.
• Use data-driven analysis to highlight opportunities for process optimisation and operational enhancements.
• Create interactive dashboards and visual reports using suitable tools, and automate reporting for both scheduled and ad-hoc stakeholder requirements.

Analyst Expectations

• Complete assigned activities on time while maintaining a consistently high standard and supporting continuous improvement.
• Demonstrate strong technical knowledge and understanding of core principles within the assigned area of expertise.
• Lead or guide team members where required, support professional development, allocate tasks, and coordinate team resources.
• For people leadership roles, demonstrate leadership behaviours that encourage collaboration and high performance. These include listening and being authentic, energising and inspiring others, aligning across teams, and developing colleagues.
• For individual contributor roles, continue building technical expertise and act as a subject matter advisor when needed.
• Work collaboratively with other teams and business units while contributing to shared objectives.
• Take responsibility for operational outcomes within the team and ensure adherence to internal policies and procedures.
• Identify and escalate policy or procedural breaches when required.
• Support the adoption of updated policies and processes introduced for risk mitigation.
• Provide insights and influence decision making within the relevant area of expertise.
• Take ownership of risk management and strengthen controls related to assigned responsibilities, ensuring compliance with applicable rules, regulations, and codes of conduct.
• Maintain awareness of how the sub-function integrates with the wider organisation, including knowledge of products, services, and operational processes.
• Assess factual information carefully, make informed evaluations, and resolve problems using established precedents and technical expertise.
• Communicate complex or sensitive information clearly and collaborate with stakeholders beyond the immediate team.

All colleagues are expected to demonstrate the Barclays values of Respect, Integrity, Service, Excellence and Stewardship. Employees should also embody the Barclays mindset of Empower, Challenge and Drive.

In this position, you will help ensure that corporate bank initiatives align with and follow the organisation’s corporate data strategy. The role involves supporting stakeholders in understanding the data strategy and working closely with business and technical subject matter experts to clarify initiative scope and impacts. Applying business domain understanding to each initiative is important.

Required Experience

• Data analysis using SQL.
• Understanding of data lakehouse and data warehouse concepts.
• Knowledge of payments data domain, including SWIFT and ISO 20022.
• Data modelling concepts.

Additional Valued Skills

• Data analysis using Python.
• Experience with lakehouse platforms such as Snowflake or Databricks.
• Familiarity with project tools such as JIRA and Confluence.
• Knowledge of Unix and ETL concepts.
• Understanding of RDBMS database principles.

Assessment for this role may include evaluation of skills related to risk and controls, change and transformation, business understanding, strategic thinking, digital and technology capabilities, along with role-specific technical expertise.