Apply on Employer Site

Barclays Investment Bank · 5 months ago

Data Architect/Data Design - AVP

115 South Jefferson Rd Campus, Whippany

Full-time

Onsite

Mid, Senior Level

$105K/yr - $150K/yr

Barclays Investment Bank is embarking on a transformative journey to redefine the future of banking. In this role, you will design and maintain enterprise data models that ensure consistency, scalability, and compliance across global functions while collaborating across teams to strengthen data governance and optimize architecture.

BankingFinancial Services

H1B Sponsor Likely

Responsibilities

Analysis and documentation of business requirements to translate them into data models aligned with organisational goals

Development and maintenance of data dictionaries and glossaries to define data elements and their usage

Analysis and monitoring of data usage patterns to identify opportunities for data optimisation and improvement, in partnership with the Data Base Administrator

Strategic architecture definition and product selection

Production of logical designs in relevant subject area (technical, data, operational), showing for example: processes, objects, data flows, inputs, stored data and outputs. Identifying common components

Implementation of architectures and Identification, ownership and resolution of design related issues

Definition and documentation of data architectures standards, principles and strategies

To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions

Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes

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 will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes

Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues

Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda

Take ownership for managing risk and strengthening controls in relation to the work done

Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function

Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy

Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc).to solve problems creatively and effectively

Communicate complex information. 'Complex' information could include sensitive information or information that is difficult to communicate because of its content or its audience

Influence or convince stakeholders to achieve outcomes

Qualification

Data modellingData architectureAdvanced SQLData warehousingETL toolsData governanceCloud-native solutionsRelational databasesNoSQL databasesScripting languagesCollaborationStrategic thinking

Required

Data modelling and data architecture, preferably within financial services or large corporates

Data modelling tools such as Erwin, ER/Studio, or PowerDesigner

Conceptual, logical, and physical modelling techniques applied at scale

Advanced SQL (DDL, DML, performance tuning) and scripting languages such as PL/SQL, T-SQL, Python, or Shell

Data warehousing approaches (Inmon, Kimball) and ETL tools such as Informatica

Preferred

Working with relational (Oracle, SQL Server, PostgreSQL, MySQL), columnar (Amazon Redshift, Snowflake), and NoSQL databases (MongoDB, Cassandra)

Designing and implementing cloud-native solutions on AWS (S3, Redshift, Glue) or Azure

Building and managing Lake Formation / Data Lake architectures

Knowledge of data governance policies and compliance standards such as BCBS239 or GDPR

Collaborating effectively across global teams and influencing senior stakeholder decisions

Benefits

Medical

Dental and vision coverage

401(k)

Life insurance

Other paid leave for qualifying circumstances

This position is eligible for an incentive award.

Company

Barclays Investment Bank

Barclays Investment Bank offers large corporate clients with strategic advisory, financing, and risk management solutions. It is a sub-organization of Barclays Corporate Banking.

Founded in 1997

London, England, GBR

10001+ employees

https://www.investmentbank.barclays.com

H1B Sponsorship

Barclays Investment Bank has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2022 (1)