Engineer - PySpark/SQL
barclays
Job Description
- 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 exp