Data/ETL Designers

Purpose of the role

To design, develop and improve software, utilising various engineering methodologies, that provides business, platform, and technology capabilities for our customers and colleagues. 

Accountabilities

• Development and delivery of high-quality software solutions by using industry aligned programming languages, frameworks, and tools. Ensuring that code is scalable, maintainable, and optimized for performance.
• Cross-functional collaboration with product managers, designers, and other engineers to define software requirements, devise solution strategies, and ensure seamless integration and alignment with business objectives.
• Collaboration with peers, participate in code reviews, and promote a culture of code quality and knowledge sharing.
• Stay informed of industry technology trends and innovations and actively contribute to the organization’s technology communities to foster a culture of technical excellence and growth.
• Adherence to secure coding practices to mitigate vulnerabilities, protect sensitive data, and ensure secure software solutions.
• Implementation of effective unit testing practices to ensure proper code design, readability, and reliability.

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.

Finance Data Team is a global team responsible for the design, development and maintenance of applications supporting the mandatory Regulatory functions of Barclays across clusters in US, Europe, UK and APAC, as well as devising the reporting strategy for Finance. Its primary mission is to continuously improve efficiency and effectiveness of global and local reporting architecture to allow our business stakeholders to have a sustained competitive advantage through technology.

Reporting to the Delivery Manager, the Data engineer AWS will be accountable for both execution and communication of the development activities within one or more of the programmes in the team. With a heavy emphasis on both technical and communication skills, the developer is expected to work closely with the developers, Business Analysts, Architects and Project Managers across all regions and clusters to deliver robust design and technical solutions in a controlled, transparent and actively risk managed fashion.

To be successful as a Data / ETL Designers, you should have experience with:

• Sound hands-on experience in on AWS Advanced Concepts, Stack (Glue, Lambda) and delivering the functionality to a high-quality meeting the agreed specifications and standards.
• Pro-active engagement in Agile ceremonies, e.g. daily stand ups, retrospectives and product demos.
• Ability to troubleshoot QA, UAT, production and performance issues; identifying root cause and options for optimisation.
• Incorporation of non-functional requirements increasing maintainability and reliability; thus, reducing technical debt. 
• Conduct regular code reviews and provide constructive feedback across the team.
• Work with RTB to guide through production issues and proactively help with system stability and performance etc.
• Must be able to work with global (UK, India and US) delivery teams.
• Ensuring project documentation is maintained as per project/firm standards.
• Actively collaborate with development teams and team leads on product development, best practices and automation.
• Excellent analytical skills and an appetite for problem-solving and delivery.

Some of Highly Valued Skills may include:

• Candidates with experience in Banking / Finance domain preferred.
• Certificate or equivalent work experience demonstrating deep expertise in AWS services, cloud infrastructure, and day-to-day cloud operations.
• Strong hold on AWS Data Analytics Technology Stack (Glue, Lambda, Step Functions)
• Strong hands-on experience in Python and PySpark .
• Strong hands-on experience in Amazon Athena .
• Strong proficiency in Advanced SQL.
• Strong understanding of Kubernetes Services / EKS.
• Good Knowledge on GitHub, CI/CD using any tool.
• Sound hands-on experience in Oracle 19c Database.
• Should have worked at least on two major project implementations.
• Exposure to financial institution with exposure to Regulatory Reporting.
• Knowledge of the finance markets and financial products, including Balance Sheet and Income statement concepts.
• Familiarity with complex system integration and excellent understanding of the full SDLC lifecycle including both waterfall and agile methodologies.

You may be assessed on the 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. 

The location of the role is Pune, IN.