Data Engineer

Job Description :Job Title : Data Engineer

Department : IT- Data Reporting to : Sr. Data Engineering Manager

Location : Bangalore

Skills : Azure Data Engineer, SQL, Azure Data Factory, Azure Data Bricks, pyspark

This role aligns with the Employee/Line Manager version of OSB's Value Driven Behaviours framework.

About OneSavings Bank plc :

OneSavings Bank plc (OSB) the specialist lending and retail savings group began trading as a bank on 1 February 2011 and was admitted to the main market of the London Stock Exchange in June 2014 (OSB.L). OSB joined the FTSE 250 index in June 2015. The Group, which is headquartered in Chatham, Kent OSB is authorised by the Prudential Regulation Authority, part of the Bank of England, and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

OSB primarily targets underserved market sub-sectors that offer high growth potential and attractive risk-adjusted returns in which it can take a leading position and where it has established expertise, platforms and capabilities. These include private rented sector Buy-to-Let, commercial and semi-commercial mortgages, residential development finance, bespoke and specialist residential lending and secured funding lines. It is differentiated through its use of high skilled, bespoke underwriting and efficient operating model. OSB lends through the Kent Reliance, InterBay Commercial, Prestige Finance and Heritable Development Finance brands, originating organically through specialist brokers and independent financial advisers.

OSB is predominantly funded by retail savings originated through the long established Kent Reliance name, which includes online and postal channels, as well as a network of branches in the South East of England. Diversification of funding is currently provided by participation in the Funding for Lending Scheme and access to a securitisation programme. The majority of the Group's administrative support functions are performed by its wholly owned OSB India operation, based in Bangalore, India.

About OSB India Pvt Ltd :

OSB India is an offshore subsidiary of One Savings Bank Group plc., the UK based Challenger Bank. OSB India was incorporated in 2004 as a key part of the OneSavings Bank business strategy to provide operational service support.

OSB India works with the Bank's trading brands in the UK, providing exceptional customer support and service delivery to new and existing customers.

OSB India also prides itself for offering operational excellence by devising and utilizing process improvements and functional efficiencies.

Job Purpose :

The Data Engineer will be responsible for translating business requirements into Azure Cloud-based big data solutions for the data modernisation program. You will be responsible for building complex data pipelines, data warehouses, and data lakes using Azure services like Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.

The Azure DE will work closely with other members of the data Engineering team and product owners ensuring Data strategy and platforms fulfil current needs and are aligned with the overall vision of the organisation. They will be responsible for delivery of enterprise scale data transformation/modernisation programmes.

The ideal candidate will be an experienced data technologist and have a blend of experience across delivery and the practical application of contemporary data technologies. Experience in working within the Banking Industry (in banking, vendors or a large tech firm) is highly desirable.

Core Responsibilities :

• Develop high quality big data technologies-based solutions on Azure Cloud leveraging Azure Databricks and other services for advanced data processing, analytics tasks, optimizing performance and scalability.

• Analyse current business practices, processes, and procedures as well as identifying future business opportunities for leveraging Microsoft Azure Data & Analytics Services.

• Develop best practices including reusable code, libraries, patterns, and consumable frameworks for Azure cloud-based data warehousing and data pipelines.

• Work closely with the Azure Data engineering Manager and technical leads to ensure the execution of plans corresponds with what is being promised.

• Data processing efficiency improvement, migrations from on-prem to public cloud platforms.

5. Experience Requirements :

• Overall 4-5 years of IT experience preferably in Data and Analytics implementation.

• Minimum 3 years of Data engineering (Azure) delivery experience including analysis / development / configuration/ deployment.

• 2 years of implementation experience in Azure Data engineering projects.

• Experience in an MI / BI / Analytics environment (Kimball, lake house, data lake) is essential.

• Proficiency in Python/SQL/SparkSQL/PySpark.

• Expert level understanding on Azure Data Factory, Azure Synapse Analytics, Azure SQL, Azure Data Lake, Datra bricks, perview and Azure App Service is required.

• Significant technical skills such as Transact SQL language, relational database skills are essential.

• Understanding of data governance and security best practices.

• Experience in Streaming and batch architecture (e.g., Kafka, Kafka streams, Spark, Flink).

• Exposure in at least one distributed data processing framework : Spark (Core, Streaming, SQL), Storm or Flink, etc.

• Should have worked on any NoSQL solutions like Mongo DB, Cassandra, HBase, Cosmos DB etc, or Cloud-based NoSQL offerings like DynamoDB, Big Table, etc.

• Good Exposure in development with CI / CD pipelines. Knowledge of containerization, orchestration, and Kubernetes engine would be an added advantage.

• Development of data pipelines using API ingestion and Streaming ingestion methods.

• Experience in working in a fast-paced agile environment.

Knowledge Requirements :

• Excellent understanding of data technologies landscape/ecosystem (Both On-prem and Cloud).

• Detailed knowledge of Software development essential.

• Detailed knowledge of the below skills are essential :

• Azure Data Factory

• Azure Databricks

• Azure Synapse Analytics

• SQL

• Python

• Data Modelling

• Data Warehousing

• Data Lake

• ETL

• Proven ability to build, manage and foster a team-oriented environment.

• Proven ability to work creatively and analytically in a problem-solving environment.

• Excellent communication (written and oral) and interpersonal skills.

• Excellent organizational, multi-tasking, and time-management skills.

Required Qualifications/Certifications :

• Bachelor's or master's degree in computer science, information systems, or related field, and / or equivalent work experience is essential.

• Azure Certifications (Related to Design and Development).

• Professional IT accreditation or qualification is desirable.