Lead EDW Global Core Data Engineer

Lead EDW Global Core Data Engineer

Whippany, NJ

As a Barclays Lead EDW Global Core Data Engineer, you will function as Senior Engineering Lead for large scale massively parallel data warehouse for Market Post trade warehouse and Data Mart Growth Initiatives. You will be responsible to design & deliver regulatory reports like LIBOR EAR, MIFID II, CAT, Bluesheets which are sent to external regulators along with ACT and other surveillance reports.

Barclays is one of the world's largest and most respected financial institutions, established in 1690, with a legacy of success, quality, and innovation. We've helped millions of individuals and businesses thrive, creating financial and digital solutions that the world now takes for granted. An important and growing presence in the USA, we offer careers providing endless opportunity.

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.

What will you be doing?

• Designing and building data warehouses on cloud/on-premises, to provide efficient analytical and reporting capabilities

• Developing highly scalable data pipelines to load data and build Data Warehouse/Mart workflows

• Using cloud based or on-premises tools and technologies like IBM Netezza, AWS cloud, Spark, Informatica, Scala, Python, SQL, Kafka

• Facing off to one or more business areas/SME's and understand high level requirements

• Innovating and owning design/architecting solutions and ensuring delivery from requirement to successful completion

• Spearheading planning, development, testing and production implementation with highest level of standards

• Accounting for critically evaluating information gathered from multiple sources, discussing and documenting high level requirement, system requirements, design workflows etc

• Working independently with different areas/teams from business, operations, engineering, and support teams

What we're looking for:

• Experience of several years in Data warehouse, ETL/Streaming, Data architecture space

• Solid expertise in dimensional modelling and data warehousing

• Deep understanding of System Design and Data Architecture

• Good experience with Design Lage scale Data Warehouse, Data Mart, and Reporting applications

Skills that will help you in the role:

• Experience of working with Market Post Trade functions and exposure to regulatory reporting systems would be advantageous

• Hands on experience in delivering applications/solutions on AWS, Azure etc

• Good to have experience with Data API design and implementation using Microservice based architecture based on Graph QL, REST etc

• Understanding of and hands on experience on Data Visualisation and data analytics tools such as QlikView, Tableau, etc

Where will you be working?

Our next-generation workplace in Whippany allows talented, passionate, down-to-earth colleagues to connect daily. With state-of-the-art work facilities and many added features like pool tables, cafés and a gym - it's a place you can call home. Our office is minutes away from Morristown, known for its rich history and lively modern spirit. With bustling Manhattan easily accessible and a picturesque landscape here on the doorstep, Whippany really does offer the best of both worlds.

#LI-Hybrid

#infrastructure