Data Engineer

Technology at Brit: Brit has a leadership position at Lloyds, the most well-known insurance market in the world. At Brit, we believe that the uncertainty of the future should never stand in the way of progress. Thats why we exist. To help people and businesses face the future and thrive. We are change-makers enabled by a global workforce who collaborate to deliver a risk service. Our goal is to attract and retain the best talent in the market and empower those individuals to innovate, and champion the strategic objectives within the business. Our technology and data teams have led some of the most noteworthy developments in the London market, by delivering digital, data and AI driven capabilities: Data is a key capability to drive Brits ambition for digital, innovation, growth and efficiencies. Brit leads the market with respect to our data modernisation journey, delivering on our vision to build a central, trusted, cost efficient, flexible, and scalable cloud native data platform that enables us to harness maximum value from internal and external data for Brit. Brit is active in advancing digital tradingapproaches, most notably with respect to Broker APIs. At Brit, we are designing a multi class of business headless API which connects Brits pricing and document generation to multiple global Broker platforms, Market Hubs, and enables bulk submission ingestion. Brit has launched its Underwriting Transformation journey advancing our capabilities deploying digital foundations for pricing and underwriter workbench. Brits new modern Underwriting Platform is at the heart of this transformation agenda, with a focus on engineering, upskilling in python, exploring ingestion and analytics, we are actively delivering our digital future. Our market leading proprietary machine learning algorithm designed to accelerate the identification of post catastrophe property damage, based on the use of ultra-high-resolution imagery, allows Brit to accelerate service to its customers when they need it most, noted as the first enabler for virtual claims adjusting in the London market. We value continuous learning & exploration, encouraging our people to constantly evolve and take advantage of the best-in-class technology & tooling. If you have the drive to work in a flexible, fun, passionate Technology and Data team we would love to hear from you Purpose of the Job: As a Data Engineer, the role holder will be responsible for operating within a team of data engineers that build and run the core components of an effective Azure Data Lake platform; encompassing key services such as Azure Blob Storage, Azure Data Factory, Synapse, Databricks, SQL Data Warehousing and PowerBI for end-user data analytics and reporting. This role will play an engineer role in the continuous utilisation, expansion, and refinement of these services, as well as the development of critical data models - capable of meeting a wide range of financial and underwriting reporting/analytics needs. This role will encompass a mix of data engineering and BI development skills . As a Data Engineer, the role holder will: Design, develop, and hold accountability for core data engineering services, such as data orchestration and CICD pipelines Design and develop ETL/ELT processes, data lake architecture, data warehouse databases, data marts, cubes, reports and dashboards; in-line with company reporting strategy and best practise Design and develop models and databases both relational and dimensional to support reporting requirements. Create reporting solutions in line with standards, architectural principles and practices Assess change impact assessment on live systems and processes Work in an agile, proactive manner; delivering high quality solutions in agreed timescales Mentor and support junior data engineers/developers in the team Principal Accountabilities: Contributor on the design and build of Brits enterprise strategic reporting solutions covering all components of Brits data lake/MI/BI platform architecture and adhere to coding practices/standards Document technical design and analysis work. Develop and Support applications in Azure Assess business requirements and build reporting solutions to meet business needs Follow and enforce SDLC best practices, standards and design principles covering all aspects of data lifecycle management and BI/MI solutions Assist in developing standards for data lakes, data ingestion, data access layers and BI solutions Ensure that adequate steps are taken to protect data and the Brit data platform Ensure that all new BI/MI requirements are met using the most appropriate architecture components Design appropriate BI/MI solutions to meet business needs Ensure Brit maintains a low technical debt & identify area(s) for automation and continuous improvement Work in a DevOps team - will involve being available on call and supporting out of office hours Develop working software to a good standard using recognized software engineering principals whilst adhering to Brit development standards. Deliver features in a timely fashion within approved deadlines during IT projects. Regulatory Conduct Rules: Act with integrity. Act with due skill, care and diligence. Be open and co-operative with Lloyds, the FCA, the PRA, and other regulators. Pay due regard to the interests of customers and treat them fairly. Observe proper standards of market conduct. Education, Qualifications, Knowledge, Skills and Experience: Required Skills & Knowledge Solid hands-on experience with Azure Data Lake (incl. Blob Storage, Delta) Azure Data Factory, Synapse and Databricks Proven experience of SQL/Azure SQL data warehousing Proven experience of data engineering activities such as release management, environment controls, CICD pipeline orchestration Experience working with Python and Spark Proven ability of Microsoft BI software development including database / reporting development, full development cycle Strong data modelling, problem solving, information analysis, attention to detail, flexibility of approach The ability to deal directly with business functions and interpret their thoughts into successful data & analytics solutions The ability to design and develop complex BI/MI solutions in line with agreed architectural principles and toolsets. Capable of working closely with the business and delivering complex requirements to tight timescales. Strong interest in latest data engineering technologies, best practices, techniques and trends in the data industry Required Toolsets: Azure Data Lake Storage, Analysis Services (Multidimensional/Tabular), Power BI, Azure Data Factory, Synapse, Azure Databricks/Spark Microsoft SQL Server or Azure SQL DB Kimball data modelling Desirable Skills and Knowledge: Knowledge of London market insurance Extensive experience in the design and build of data warehouse/data lake Experience working with financial systems and business processes Experience of cloud architectures and solutions, especially Azure Experience of Infrastructure-as-Code e.g. Terraforms Agile development techniques (SCRUM, Kanban etc) Desirable Toolsets: Python, MDX, DAX Azure DevOps Required Qualifications: Degree Level or above (Science, Maths, Computing, Engineering or related subject preferred)

Location: bangalore, IN

Posted Date: 11/22/2024