Job Description

Investec is a distinctive Specialist Bank serving clients principally in the UK and South Africa. Our culture gives us our edge: we work hard to find colleagues who\'ll think out of the ordinary and we put them in environments where they\'ll flourish. We combine a flat structure with a focus on internal mobility. If you can bring an entrepreneurial spirit and a desire to learn and collaborate to your work, this could be the boost your career deserves.Key Roles and Responsibilities:Responsibilities:

• Translating architecture designs into technical implementations.
• Building dynamic meta-data driven data ingestion patterns using Azure Data Factory and Databricks.
• Building and maintaining the Enterprise Data Warehouse (using Kimball methodology)
• Building and maintaining business focused data products and data marts.
• Building and maintaining Azure Analysis Services databases and cubes.
• Ad hoc data analysis and \'data wrangling\' using Azure Synapse Analytics and Databricks.
• Implementing and delivering to all stages of the data engineering using Investec Data Experience (IDX) templates into ODP (One data platform).
• Playing a supporting and mentoring role to junior data engineers.
• Develop, implement, and maintain relevant documentation, guidelines, checklists, and policies to promote continuous integration, ensure and improve data security, and reduce the possibility of human error.
• Sharing support and operational duties within the team.
• Working closely with end-users to understand their business and their data requirements.

Requirement & Skills:

• Knowledge of distributed data mesh deployment methodology.
• 6+ years of experience as a data engineer.
• Experience in building robust and performant ETL processes.
• Excellent data analysis and exploration using T-SQL
• Demonstrated expertise in developing and optimising large-scale data processing applications using Apache Spark. Proficient in writing complex Spark jobs to process and analyse vast datasets efficiently.
• Skilled in leveraging Pandas for data manipulation and analysis tasks. Capable of transforming raw data into actionable insights by utilising Pandas\' powerful data structures and functions.
• Extensive experience with SQL Server and SSIS
• Knowledge and experience of data warehouse modelling methodologies (Data Vault 2.0, Kimball)
• Experience in Azure - one or more of the following: Azure Data Factory, Databricks, Azure Synapse Analytics, ADLS Gen2
• Understanding and experience in Azure bicep templates for automating deployment of pipelines.
• Python and SQL (stored procedures, functions)
• Understanding of systems development, project management approaches.
• Build and maintain Analysis Services databases and cubes (both multidimensional and tabular)
• Experience in using source control, preferably GIT.
• Basic knowledge in Infrastructure as Code (IaC) - scripting and automation via Azure CLI, PowerShell, Bash, Bicep and JSON ARM and Bicep templates.
• Understanding and experience of DevOps deployment pipelines
• Effective communication and collaboration skills to work in cross-functional teams, participate in code reviews, and communicate technical concepts to non-technical stakeholders.
• Willingness to learn new technologies, keep up with industry trends, and adapt to evolving development practices and too

As part of our collaborative & agile culture, our working week is 4 days in the office and one day remote.Investec offers a range of wellbeing benefits to make our people feel healthier, balanced and more fulfilled in their lives inside and outside of work.Embedded in our culture is a sense of belonging and inclusion. This creates an environment in which everyone is free to be themselves which helps to drive innovation, creativity and ultimately business performance. At Investec we want everyone to find it easy to be themselves, and to feel they belong. It's a responsibility we all share and is integral to our purpose and values as an organisation.Research shows that some candidates can be reluctant to apply to a role unless they meet all the criteria. We pride ourselves on our entrepreneurial spirit here and welcome you to do the same - if the role excites you, please don\'t let our person specification hold you back. Get in touch!Recite MeWe commit to ensure that everyone is fairly assessed during our recruitment process. To assist candidates in completing their application form, Recite Me assistive technology is available on our Careers pages. This can be accessed by clicking on the \'Accessibility Options\' link at the top of the page.The Recite Me tool includes a screen reader, styling and customisation options, a series of reading aids, a translator and more.If you have any form of disability or neurodivergent need and require further assistance in completing your application, please contact the Careers team at who will be happy to assist.Loading...Close mapLocationMumbaiParinee Crescenzo, 11th floor, G Block BKC, Bandra Kurla Complex, Bandra (E, Mumbai, Maharashtra 400051, India, Mumbai, IndiaLoading...Meet the recruiterNancy JosephWe commit to ensure that everyone is fairly assessed during our recruitment process.Let us know if you need any reasonable adjustments to complete your application.Loading...Share this pageJob AlertsCreate an alert subscription based on this JobBenefitsPensionPrivate Medical CoverVirtual GPGym DiscountsPsychologist ServiceAnnual LeaveLife AssuranceLoadingXLoading...Email*span class="labelText">Email
/span>" class="inputText tooltiprow"/>Name*span class="labelText">Name
/span>" class="inputText tooltiprow"/>Please let us know what adjustments would help you with your application:*span class="labelText">Please let us know what adjustments would help you with your application:

Investec