Data Analyst - Location Strategy
Join Barclays in Pune, India, as a Data Analyst to support the successful delivery of Location Strategy projects. This role is pivotal in planning, budgeting, and ensuring projects meet quality and governance standards. You will be instrumental in evolving our digital landscape, fostering innovation, and enhancing our digital offerings through cutting-edge technology to provide exceptional customer experiences.
Key Responsibilities:
- Investigate and analyze data issues concerning quality, lineage, controls, and authoritative source identification. Document data sources, methodologies, and quality findings, providing recommendations for improvement.
- Design and construct data pipelines to automate data movement and processing.
- Apply advanced analytical techniques to large datasets to uncover trends and correlations. Develop validated logical data models and translate insights into actionable business recommendations for operational and process improvements, leveraging machine learning/AI.
- Translate analytical findings into actionable business recommendations, identifying opportunities for operational and process enhancements.
- Design and create interactive dashboards and visual reports using applicable tools, and automate reporting processes for both regular and ad-hoc stakeholder needs.
Required Skills and Experience:
- Proven hands-on experience in data analysis or a data-focused Tech BA role, with the ability to manage complex technical and business stakeholder matrices across multiple geographies.
- Proficiency in technical data migration analysis, including database & table level details, reconciliation, and SAS process migrations. Experience in creating and maintaining Data Dictionaries, Metadata, Data Lineage, Mapping documentation, API Catalogues, and interface inventories.
- Strong SQL query writing skills for small to medium complexity requirements. Minimum 2 years of hands-on SAS software experience for ad-hoc analysis and BAU reporting.
- Exposure to Python programming for data analysis, automation, and scripting, including working with large datasets for extraction, cleaning, analysis, and presentation.
- Understanding and implementation of Technology Application Delivery and Data Management control frameworks. Familiarity with Apache Spark, Databricks, and AWS cloud services.
- Experience with data visualization tools such as Tableau, Power BI, or Qlik for creating interactive dashboards and reports.
Highly Valued Skills:
- Practical agile methodology experience, including defining business outcomes and creating portfolio epics and user stories. SAS Certified Base and/or Advanced Programmer certifications.
- Hands-on experience in data streaming, ETL, data quality, data reconciliation, data processing, and data warehousing, preferably on AWS.
- Experience in batch and real-time warehousing. Advanced Python libraries (Pandas, NumPy, Matplotlib, Seaborn) and PySpark for distributed data processing and big data analytics.
- AWS certifications (e.g., Solutions Architect, Data Analytics). Advanced Tableau/Power BI skills including calculated fields, parameters, and dashboard optimization.
- Experience in the banking and financial services sector, particularly in fraud detection.
- Track record of success in large, matrix organizations, working with senior stakeholders.
- Ability to work independently, shape abstract situations, and manage multiple priorities effectively. Flexibility to overlap with US, UK, and India time zones.
- Strong drive for results, ability to juggle priorities, multitask, and execute flawlessly at speed.
This role is based in Pune, India.
Barclays colleagues are expected to demonstrate the Barclays Values: Respect, Integrity, Service, Excellence, and Stewardship, as well as the Barclays Mindset: Empower, Challenge, and Drive.