At a Glance
- Tasks: Design and develop scalable data solutions using Microsoft technologies.
- Company: Join a collaborative, high-performing team focused on meaningful data initiatives.
- Benefits: Hybrid work model with opportunities for professional growth and development.
- Other info: Work with cutting-edge Microsoft technologies and contribute to an evolving data platform.
- Why this job: Make a real impact by solving complex data challenges and improving customer experiences.
- Qualifications: Five years of Data Engineering experience and strong SQL skills required.
The predicted salary is between 63000 - 77000 £ per year.
We are looking for an experienced Data Engineer to join our growing Data Engineering team. You will work with Microsoft technologies to design, develop and support enterprise-scale data solutions that improve customer experiences and help colleagues make informed, data-driven decisions. Working closely with Architects, Senior Engineers and business stakeholders, you will take ownership of solutions from initial concept through to implementation. You will translate business requirements into effective technical solutions, resolve complex data challenges and identify opportunities to improve processes, data quality and business outcomes.
What you’ll be doing:
- Designing and delivering scalable data solutions using Microsoft technologies
- Developing data integration solutions and pipelines using ETL and ELT approaches
- Working with stakeholders to understand, challenge and refine requirements
- Translating business needs into sustainable technical solutions
- Investigating complex data issues and recommending practical solutions
- Collaborating with Data Science, Digital, Core Systems and other technical teams
- Contributing to Agile ceremonies, code reviews, testing and quality assurance
- Producing clear technical documentation, release notes and support materials
- Ensuring solutions meet data governance, security, privacy and regulatory requirements
- Identifying delivery risks, dependencies and opportunities for improvement
- Supporting the continuous improvement of engineering practices, processes and tooling
What we’re looking for:
- At least five years’ experience in Data Engineering and Business Intelligence delivery
- Strong experience with SQL Server, SSIS, SSAS and SSRS
- Strong SQL skills, including experience with T-SQL and DAX
- Experience designing and developing ETL and ELT data pipelines
- A solid understanding of data warehousing, data modelling, dimensional modelling and data architecture
- Strong analytical and problem-solving skills
- Experience gathering, analysing and refining requirements with business stakeholders
- The ability to manage competing priorities and deliver outcomes independently
- Strong communication and stakeholder management skills
- Experience working within an Agile delivery environment
- Experience with Power BI, including dashboards, reporting and semantic models
It would be an advantage if you have:
- Experience within mortgages, financial services or another regulated environment
- Knowledge of Microsoft Azure technologies such as Azure Data Factory, Azure Data Lake, Azure SQL Database, Azure Synapse Analytics and Azure Functions
- Experience consuming APIs and working with JSON or XML
- Knowledge of Python, C# or PowerShell
- Experience with Git repositories and branching strategies
- Knowledge of Infrastructure as Code and DevOps tooling, including Bicep, YAML and CI/CD pipelines
- Knowledge of Power Platform technologies
- Relevant Microsoft or Azure Data Platform certifications
Why join us?
You will join a collaborative, high-performing team where you can take ownership of meaningful data initiatives, work across a broad Microsoft technology stack and contribute to the continued development of our data platform. If you are a proactive Data Engineer who enjoys solving complex problems, working with stakeholders and delivering reliable, high-quality solutions, we would like to hear from you.
Key skills: Data Engineering, SQL Server, SSIS, SSAS, SSRS, T-SQL, DAX, ETL, ELT, Data Warehousing, Data Modelling, Dimensional Modelling, Power BI, Python, C#, PowerShell, Git, Bicep, YAML, CI/CD, Agile
Data Engineer in London employer: Kensington Mortgage Company Careers
Join a forward-thinking company that prioritises innovation and collaboration in the heart of Marlow or London. As a Software Engineer, you'll be part of a dynamic Digital Services team dedicated to simplifying the mortgage journey for customers and colleagues alike. With a strong emphasis on employee growth, a supportive work culture, and the opportunity to work with cutting-edge technologies like C#, .NET, and Microsoft Azure, this role offers a meaningful career path where your contributions truly matter.
Contact Details:
Kensington Mortgage Company Careers Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Kensington Mortgage Company Careers!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer at Kensington Mortgage Company Careers.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Kensington Mortgage Company Careers.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer at Kensington Mortgage Company Careers, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Kensington Mortgage Company Careers, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Kensington Mortgage Company Careers. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Kensington Mortgage Company Careers
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Kensington Mortgage Company Careers!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.