AWS Data Engineer

AWS Data Engineer - Location Strategy Projects

Barclays is seeking an experienced AWS Data Engineer to support the successful delivery of Location Strategy projects. This role is crucial in shaping our digital landscape, driving innovation, and ensuring unparalleled customer experiences by leveraging cutting-edge technology.

Key Responsibilities

• Support the delivery of Location Strategy projects, adhering to agreed quality and governance standards.
• Spearhead the evolution of the digital landscape, driving innovation and excellence.
• Utilize cutting-edge technology to revolutionize digital offerings and enhance customer experiences.
• Build and maintain systems for data collection, storage, processing, and analysis, including data pipelines, data warehouses, and data lakes.
• Ensure data accuracy, accessibility, and security.
• Design and implement scalable and efficient data transformation/storage solutions.
• Develop processing and analysis algorithms for complex data scenarios.
• Collaborate with data scientists to build and deploy machine learning models.

Technical Skills & Experience Required

• Hands-on experience with Python and PySpark, including strong knowledge of DataFrames, RDD, and SparkSQL.
• Hands-on experience developing, testing, and maintaining applications on AWS Cloud.
• Strong proficiency in AWS Data Analytics Technology Stack: Glue, S3, Lambda, Lake Formation, Athena.
• Experience designing and implementing scalable and efficient data transformation/storage solutions using Snowflake.
• Experience with data ingestion into Snowflake for various formats (Parquet, Iceberg, JSON, CSV, etc.).
• Experience using DBT (Data Build Tool) with Snowflake for ELT pipeline development.
• Experience writing advanced SQL and PL/SQL programs.
• Experience in AWS data pipeline development.
• Hands-on experience building reusable components using Snowflake and AWS Tools/Technology.
• Proven experience in at least two major project implementations.

Advantageous Skills

• Exposure to data governance or lineage tools (e.g., Immuta, Alation).
• Experience with orchestration tools (e.g., Apache Airflow, Snowflake Tasks).
• Knowledge of Ab Initio ETL tool.

Valued Skills & Competencies

• Ability to engage with stakeholders, elicit requirements, and translate them into ETL components.
• Understanding of infrastructure setup and ability to provide solutions.
• Good knowledge of Data Marts and Data Warehousing concepts.
• Strong analytical and interpersonal skills.
• Experience implementing cloud-based enterprise data warehouses with multiple data platforms (Snowflake, NoSQL) to build data movement strategies.
• Knowledge of risk and controls, change and transformation, business acumen, strategic thinking, and digital/technology.

Purpose of the Role

To build and maintain the systems that collect, store, process, and analyse data, ensuring accuracy, accessibility, and security.

Analyst Expectations

Perform prescribed activities timely and to a high standard, driving continuous improvement. Requires in-depth technical knowledge and experience, with a thorough understanding of underlying principles. For leadership roles, demonstrate LEAD behaviors (Listen, Energise, Align, Develop). For individual contributors, develop technical expertise and act as an advisor. Partner with other functions and business areas, taking responsibility for end results, escalating breaches, and embedding new policies. Advise and influence decision-making, own risk management, and deliver in line with regulations. Maintain understanding of functional integration and organizational objectives.

Barclays Values

All colleagues are expected to demonstrate Barclays Values: Respect, Integrity, Service, Excellence, and Stewardship. Also demonstrate the Barclays Mindset: Empower, Challenge, and Drive.

Key skills/competency

• AWS Data Engineer
• Python
• PySpark
• SparkSQL
• AWS Cloud
• Snowflake
• Data Transformation
• Data Ingestion
• DBT
• SQL