Engineer - PySpark/SQL

Barclays; Bengaluru; On-site; INR 1,500,000 - 3,500,000; Full time

Job summary

Barclays in Bengaluru seeks an Engineer - PySpark/SQL to design, build and own scalable cloud-native data platforms for analytics and reporting. You will ensure data is trustworthy, well-governed and accessible while implementing robust validation, monitoring and CI/CD for data pipelines.

You will work with Python, SQL, AWS (Glue, Athena, S3, IAM) and Databricks, drive agile delivery, and collaborate with cross-functional teams to translate requirements into scalable data solutions.

Qualifications

• Strong Python and SQL experience with data processing for analytics.
• Experience with AWS data services (Glue, Athena) and Databricks.
• Knowledge of data lake/lakehouse architectures and performance tuning.
• Familiarity with data governance, security controls, and logging.

Responsibilities

• Build and maintain data architectures and pipelines for durable, complete data processing.
• Design and implement data warehouses and data lakes with appropriate security.
• Develop processing and analysis algorithms for complex data sets.
• Collaborate with data scientists to deploy machine learning models.

Skills

Python

SQL

Performance tuning

AWS

Databricks

Spark

Lakehouse architecture

Agile/Scrum

Jira

Unix/Shell scripting

Data modelling

Tools

Databricks

AWS Glue

Athena

S3

IAM

Unix/Shell scripting

Jira

Job description

Join us as a Engineer - PySpark/SQL at Barclays, where you'll spearhead the evolution of our digital landscape, driving innovation and excellence. You'll harness cutting-edge technology to revolutionize our digital offerings, ensuring unapparelled customer experiences. You will be involved in design, build, and own scalable, cloud-native data platforms and pipelines that enable reliable, secure, and high-performance data processing for analytics, reporting, and advanced use cases. Ensure data is trustworthy, well-governed, and readily accessible across the enterprise.

To be a successful as Engineer - PySpark/SQL, you should have experience with:

• Develop, and optimize batch and real-time data pipelines using Python, AWS (Glue, Athena), and Databricks.
• Ensure high data quality, reliability, and observability through robust validation, monitoring, and alerting frameworks.
• Design and implement modern data lake / lakehouse architectures on AWS, ensuring scalability, cost efficiency, and performance.
• Manage structured and semi-structured data across varying volumes, velocity, and formats.
• Develop optimized data models (dimensional, normalized, curated layers) to support analytics and reporting needs.
• Drive best practices for partitioning, indexing, and query performance tuning.
• Establish and enforce coding standards, CI/CD pipelines, and DevOps practices for data engineering.
• Automate workflows using orchestration tools and scripting (Unix/Shell).
• Agile Delivery & Stakeholder Alignment.
• Drive delivery using Agile/Scrum methodologies, managing backlog via Jira.
• Collaborate with business and cross-functional teams to translate requirements into scalable solutions.
• Primary Skills: Python, SQL & performance tuning, AWS (Glue, Athena, S3, IAM), Databricks (Spark, Lakehouse architecture).
• Secondary Skills: Agile/Scrum, Jira, Unix/Shell scripting,Data modelling.
• Ensure data solutions comply with security, governance, and regulatory requirements.
• Implement controls for data lineage, access management, and auditability.
• Proactively identify risks and enforce mitigation through engineering best practices.

Some Other Highly Valued Skills May Include

• Drive continuous improvement in platform performance, cost, and reliability.
• Influence architecture and engineering decisions within and across teams.
• Provide hands-on technical leadership while contributing to critical development work.
• Effectively communicate complex technical concepts to both technical and non-technical stakeholders.
• Build strong cross-team partnerships and act as a trusted advisor in the data domain.

You may be assessed on key critical skills relevant for success in role, such as risk and controls, change and transformation, business acumen, strategic thinking and digital and technology, as well as job-specific technical skills.

This role is based out of Bengaluru.

Purpose of the role

To build and maintain the systems that collect, store, process, and analyse data, such as data pipelines, data warehouses and data lakes to ensure that all data is accurate, accessible, and secure.

Accountabilities

• Build and maintenance of data architectures pipelines that enable the transfer and processing of durable, complete and consistent data.
• Design and implementation of data warehoused and data lakes that manage the appropriate data volumes and velocity and adhere to the required security measures.
• Development of processing and analysis algorithms fit for the intended data complexity and volumes.
• Collaboration with data scientist to build and deploy machine learning models.

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.