Solution Designer

Job Title: Solution Designer
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

Structured hybrid role:
Introduction:
A Solution Designer who would assist Clients with their data requirements, have in-depth knowledge of our data platform’s data models, create and maintain data models and metadata, perform Impact assessment, define requirements and lead problem solving in the data architecture space bringing together people of different businenss and technical disciplines.

What will you be doing?
- Define functional/non-functional requirements with the stakeholders
- Identify and assess potential data sources
- Agree scope and priorities
- Carry out Impact Assessment and create user stories
- Define business transformation rules from source system through to consumer interface
- Build and maintain knowledge of data sources and what data is used by a particular Consumer
- Definition of data models and metadata in line with business requirements
- Validate data model is in line with projected data growth, non-functional requirements and changing consumer patterns
- Educate users on PBTV capabilities, the data available, what it means and how to access it

What we’re looking for:

- Personal Competencies
- Self-driven, proactive and demonstrates initiative with strong problem solving abilities.
- Strongly collaborative in nature with the ability to see the whole picture
- Highly communicative and influential, able to manage conflict
- Confident and assertive in nature
- Education Qualification
- Graduate preferably with a technology based degree
- Mandatory Technical Skills
- Data modelling and data analysis skills in a data warehouse type environment
- Data warehouse background is essential
- Strong SQL and PL/SQL skills (for MS SQL Server). Comfortable at the SQL command prompt
- Strong analytical skills
- Understand types of data schema and when to use them (3NF, star, flat, etc); mapping/translation between these;
- Understand data exchange methods, coordination of data feeds and mechanics of data integration. Autosys.
- Translate and map between schemata
- Understand, describe and define data lineages and flows (e.g. Data Flow diagramming)
- ER Studio / ERWIN
- Express key structural points of complex data model in accessible terms
- Entity-relation diagramming
- Experience undestanding source data models with different architectures and limited documentation

Skills that will help you in the role:

- Preferred Skills
- Experience of working in Financial domain is preferred
- ETL tools; ability to use and enhance new tooling
- SQLServer / Hadoop
- Working in agile mode

Where will you be working?
Pune

Be More at Barclays
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.

Software Engineering