Data Engineer
Brighton and Hove, United Kingdom
LegalAndGeneral
Legal & General are a leading UK financial services provider, offering life insurance, pensions, retirement and investment services. Get a quote today.Company Description
Life can sometimes be unpredictable, and it pays to plan ahead. Our aim at Legal & General Retail is to help our customers plan for the unexpected, achieve financial security for their tomorrow, and protect everything that’s important to them. To better understand our customers and meet their needs, we’ve brought our protection, retirement income, savings, lending and advice, fintech and mortgage businesses under one umbrella. Created at the start of 2022 through the merging of our long-standing and trusted retail retirement and insurance businesses, we’re a fast-growing division with big, customer-centred ambitions.
Job Description
Legal and General Retail’s Group Protection Data team are currently hiring for a Data Engineer as they begin the journey of delivering a new, modernised data platform with the aim of increasing accessibility and quality to improve insight required by the wider business for decision making.
This position will see you responsible for liaising with the business to gather requirements, working with the team to identify potential tools and through the migration on to a centralised platform consolidate data sources.
What you’ll be doing
- Contributing towards improvements to database systems and linking the understanding of source data to value-adding data engineering solutions (across storage, transformation, and data quality).
- Continuously developing processes so that deliverables are created in the most efficient way to improve performance, ensuring code is scalable, portable, and reusable, ensuring timely and accurate delivery of data solutions to the business.
- Developing and maintaining productive relationships with all stakeholders; providing advice and guidance on data solutions to improve their knowledge and understanding.
- Effectively maintaining Planning and Design documentation and utilising a variety of tools and techniques to manage Stakeholders.
- Taking accountability for the delivery of ad hoc data requirement for internal customers; understanding the business need and deliver the outcome in a flexible manner in line with business requirements.
- Owning the timely delivery of data platform pipelines to the business while aiming for automation and standardisation to support business requirements.
- Engaging stakeholders and undertaking appropriate testing prior to the implementation of any system or business changes to ensure the impact on internal stakeholders and customers is understood.
Qualifications
What we’re looking for
- Proficient across many domains of data engineering, including ELT/ETL, metadata management, data integration, data management in transit and at rest and data streaming.
- Experience of Kimball modelling techniques to design databases & data warehousing solutions that conform to the standards adopted by Data Ops.
- Competent in the cloud data warehousing paradigms specific to our platform, with a good awareness of alternatives.
- Use of modern project delivery methodologies to plan and deliver solutions (Agile, Waterfall etc).
- Highly proficient in SQL, DAX, DDL & DML & Powershell.
- A detailed working knowledge of many of the tools and platforms used by the Engineering Team, for example; Wherescape RED & 3D, Snowflake, Postgres, SQL Server, PowerBI, DBT, Alteryx, Qlik Replicate, Salesforce
- Industry recognised badges and certificates on any of the following tools: Snowflake, Azure Synapse/Data Factory, DBT Cloud, Azure DevOps, PowerBI would be beneficial
Additional Information
The brand with the brolly is choosing today to change tomorrow.
Since 1836, we’ve grown to become one of the world's largest asset managers, homebuilders, pension providers and insurance brands.
We’re all here to improve the lives of our customers, build a better society for the long term, and create value for our shareholders - helping to shape a better future for society and the planet.
We need people who share our ambitions, agility and entrepreneurial spirit to help us do it.
At L&G, you’ll find a balance that helps you be your best. Empowered by hybrid working, we’re supported by technology and workplaces that enable us to work effectively wherever we are. We come together in offices to collaborate and connect, and use time at home for individual, focused activities. And, when we achieve great things, we celebrate our success and reward strong performance.
Today, there’s over 10,000 of us, working towards our mission, with plenty of opportunities to grow your career as we grow L&G. Will you join us?
Great minds don’t have to think alike, so we welcome voices from all backgrounds. Bringing together people with different life experiences helps us build empathy with our customers and drive innovation.
We don’t just talk about it, we actively promote diversity and equitable opportunities for all. That means our employment decisions are made without regard to race, colour, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability or protected veteran status. In fact, we embrace every dimension of diversity to reflect the customers and communities we serve.
We think it’s important to create an inclusive environment where we can all belong, contribute and drive progress, where you can develop and grow, and be empowered. We want you to use your voice to help us build a better tomorrow.
We all work differently, and have different needs, which is why. we’re always open to discussing flexible working arrangements. Likewise, we’re committed to finding reasonable accommodations for candidates with specific needs during our recruiting process.
So whoever you are, wherever you are, whatever your story, we'd love to hear from you.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Azure Data management DataOps Data quality Data Warehousing dbt DDL DevOps ELT Engineering ETL FinTech Pipelines PostgreSQL Power BI Qlik Salesforce Security Snowflake SQL Streaming Testing
Perks/benefits: Career development Flex hours Insurance Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open Data Manager jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Junior Data Engineer jobs
- Open Research Scientist jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs