Job Description

Job Title :Supervisory Deliverables Analyst Location: Pune About Barclays Barclays is a British universal bank. We are diversified by business, by different types of customers and clients, and by geography. Our businesses include consumer banking and payments operations around the world, as well as a top-tier, full service, global corporate and investment bank, all of which are supported by our service company which provides technology, operations and functional services across the Group. Risk and Control Objective Take ownership for managing risk and strengthening controls in relation to the work you do Working Flexibly We\'re committed to providing a supportive and inclusive culture and environment for you to work in. This environment recognises and supports ways to balance your personal needs, alongside the professional needs of our business. Providing the opportunity for all our employees, globally to work flexibly empowers each of us to work in a way that suits our lives as well as enabling us to better service our customers\' and clients\' needs. Whether you have family commitments or you\'re a carer, or whether you need study time or wish to pursue personal interests, our approach to working flexibly is designed to help you balance your life. If you would like some flexibility, then please discuss this with the hiring manager, and your request will be reviewed subject to business needs. Hybrid Working Structured hybrid role: At Barclays, we offer a hybrid working experience that blends the positives of working alongside colleagues at our onsite locations, together with working from home. We have a structured approach where colleagues work at an onsite location on fixed, \'anchor\', days of the week, for a minimum of two days a week or more, as set by the business area (or nearest equivalent if working part-time hours). Please discuss the working pattern requirements for the role you are applying for with the hiring manager. Please note that as we continue to embed our hybrid working environment, we remain in a test and learn phase, which means that working arrangements may be subject to change on reasonable notice to ensure we meet the needs of our business. Introduction: The role is for experienced data and ETL developer and is required to contribute to Regulatory Projects utilizing best policies for data management and data integration. What will you be doing . Self-Motivated to instrument best practices for Solution Development which requires understanding of Market Risk, Compliance, and Trade Surveillance & Regulatory Data and through exposure of data extraction, data transformation, data management and reporting. . Drive the Best execution strategy for development and implementation . Play a lead role in Design and develop and implement effective and efficient solution for end to end data flow and reporting suit for CAT . Responsible for implementation of new EOD Reporting regulations in Europe, Americas and / or Asia Pacific, dependent on demand. . Prior knowledge on regulatory reporting streams (CAT, Mifid1, BestEx reporting, Algo HFT etc) is added advantage Analysis: . Actively engaged external business and IT partners in the requirements analysis for system enhancements and changes. . Business analysis - Translate regulations into business requirements. Documentation and analysis using appropriate tools and techniques. Design: . Interpret and understand functional specifications. Writing functional specifications if required. . Writing technical design documents adhering to predefined standards . Agile business methodology understanding is essential . Design and document business processes for new world view post regulation implementations. Ensuring business users are trained accordingly. Develop: . Extensive experience in Data Management, Data Extraction and data migration and integration . Extensive experience in Data warehouse design and modelling Expertise in SQL/Netezza/Unix, STAR Schema modelling and experience in Data warehouse methodologies (Kimball) . Use technical expertise to extrapolate data by using ETL tools (Informatica / AbInitio) . Hands on development of quality (i.e. readable, performing and supportable) of code of native database, scripting tools and ETL tools . Hands on development of Autosys, Unix, and Perl scripts, delivering the functionality detailed in the technical specifications Performance Tuning: . Tuning existing code to ensure acceptable application performance . Review users queries to understand data access patterns and suggest enhancements to data model and/or indexing strategy . Maintain and enhance conformance framework & conduct conformance testing and troubleshooting Develop and update technical documentation Quality Assurance: . Conducting reviews at various quality check points and providing constructive feedback . Mentoring junior members of the team Testing: . Preparation of detailed unit test cases . Execution of unit test cases and documentation of results . Providing support during QA and UAT test phases . Diagnosis and resolution of defects found during QA and UAT test phases . Support regression testing - investigate output differences. Implementation: . Packaging up codes for release into production . On implementation of releases, provide training to support team members Post-Implementation: . Point of contact for support team, investigating and resolving issues found in production Production Escalation: . The role demands to provide analysis and solution when production issues/job failures are escalated to build the bank (Production Escalation to BTB) in a timely manner. Individuals will be required to provide Production escalations on rotation basis. Communication Responsibilities . Communication - ensuring all key stakeholders understand project milestones, risks and issues . Communicate directly with business analysts and project managers, understanding detailed business requirements at all stages of the development lifecycle . Communicate effectively with business users to gain an in-depth understanding of new requirements and minor system changes . Communicate effectively with the other external IT development teams and the local development manager. . Work closely with global development team members in Singapore, London and New York - participating in and contributing to technical discussions. Participate and contribute in technical discussions What we\'re looking for: Experience and Qualifications: . A bachelor degree in Computer Science, Software Engineering or related. . Extensive hands-on experience on DWH, SQL, ETL and Unix. . Experience of working in a fast-paced and agile environment. . Desirable to have experience of agile delivery in a data centric, regulatory environment . Domain knowledge: Treasury/Risk/Finance (nice to have) Financial Services (desirable) Skills that will help you in the role: Technical Skills: . An extensive grounding in software development with solid data management skills considering on premises and Cloud based environments. . Well versed with DDL, DMLs, DCLs and Data Storage and Data Retrieval mechanism for in premises (Data Warehouse / Data Mart). . Experience working with large scale Data Warehouses and ETL Services . Extensive experience PL/SQL Development, Database design, SQL performance tuning, ETL Design, Development and Tuning . Good understanding of Data Warehouse and Data Mart concepts with proven experience in both . Ability to design and implement logical and physical data models . Experience with Unix (preferably Linux) . Good understanding for Netezza / Oracle. . Hands on experience with Source Code control tools e.g. Git Repo . Familiar with scheduling management technologies e.g. Autosys . Experience working in Agile/Scrum development team. Personal & Interpersonal Skill: . Able to work well with IT developers in multiple locations. . Knowledge of software development \'best practices\'. Good knowledge of the software development life cycle. . Analytical & Problem Solving skills - ability to investigate and resolve issues in a high-pressured environment. . Excellent written and verbal communication skills . Ability to multitask, Ability to train others. Preferred: . Good understanding of investment banking, and the industry sector . Good understanding of front to back finance and operational process flows Where will you be working Pune Be More at Barclays At Barclays, each day is about being more - as a professional, and as a person. \'Be More @ Barclays\' represents our core promise to all current and future employees. It\'s the characteristic that we want to be associated with as an employer, and at the heart of every employee experience. We empower our colleagues to Be More Globally Connected, working on international projects that improve the way millions of customers handle their finances. Be More Inspired by working alongside the most talented people in the industry, and delivering imaginative new solutions that are redefining the future of finance. Be More Impactful by having the opportunity to work on cutting-edge projects, and Be More Valued for who you are. Interested and want to know more about Barclays Visit home.barclays/who-we-are/ for more details. Purpose, Values and Mindset We deploy finance responsibly to support people and businesses, acting with empathy and integrity, championing innovation and sustainability, for the common good and the long term. Our values underpin everything we do: Respect, Integrity, Service, Excellence and Stewardship. Respect We harness the power of diversity and inclusion in our business, trust those we work with, and value everyone\'s contribution. Integrity We operate with honesty, transparency and fairness in all we do. Service We act with empathy and humility, putting the people and businesses we serve at the centre of what we do. Excellence We champion innovation, and use our energy, expertise and resources to make a positive difference. Stewardship We prize sustainability, and are passionate about leaving things better than we found them. Our Mindset shapes how we take action, living by our Values, driven by our Purpose, always with our customers and clients at the heart of what we do our Mindset is to Empower, Challenge and Drive. Empower Trust and support each other to deliver. Make decisions with those closest to the topic. Include diverse perspectives. Celebrate success and learn from failure. Challenge Question whether things can be done better. Use insights based on data to inform decisions. Be curious about how we can adapt and improve. Speak up and be open to alternative viewpoints. Drive Focus on outcomes. Deliver with pace. Be passionate and ambitious about what we do. Take personal responsibility. Actively build collaborative relationships to get things done. #Data Engineering and Analytics

foundit