Data Warehouse Developer

Hybrid

London, United Kingdom

Full Time

02-03-2025

Share this job:

Score my CV Apply

Job Specifications

Job Description

An exciting opportunity has arisen for an experienced Data Engineer / Data Warehouse Developer to join a well-established Financial Services organisation in Central London - they operate a hybrid working model, and you will spend 2-3 days per week in their modern office to collaborate with your team.

Following a recent company acquisition, they have kicked-off a large integration programme of work, including a large-scale Data Warehouse integration project. This will be a core focus of your role, and will involve uplifting and redeveloping their existing Data Warehouse to serve the needs of both entities going forwards.

The role requires extensive experience with SSIS to uplift, re-build and optimise ETL processes, ensuring seamless data ingestion, analysis and integration from various source systems, into their unified Data Warehouse. You'll ensure the stability and scalability of the Data Warehouse, ensuring it can handle increasing data volumes and user demands.

In doing so, you'll collaborate closely with the wider data and development team, subject matter experts and various business stakeholders.

This role would be well-suited to a Developer with strong T-SQL and SSIS skills, who is keen to play a key role in a large-scale and transformative Data Warehousing initiative.

Requirements

Extensive T-SQL programming skills - writing complex scripts, developing and optimising stored procedures etc.
Extensive SSIS skills - to rebuild and optimise ETL processes
Experience with Data Warehouse development
Some experience in scripting with PowerShell, C# and / or Python
Experience in Financial Services
Experience with WhereScape Red would be beneficial but not essential
Excellent communication and interpersonal skills, with the ability to collaborate effectively with diverse stakeholders and work in a team-oriented environment

Benefits

Salary from £55-70,000 depending on level of experience
25 days annual leave, increasing with tenure, with option to buy & sell days
Contributory pension scheme
Private medical insurance
Life assurance
Other optional add-ons

Please Note: This is role for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check.

Tenth Revolution Group (and Nigel Frank) are the go-to recruiter for Power BI and Azure Data Platform roles in the UK, offering more opportunities across the country than any other. We're the proud sponsor and supporter of SQLBits, and the London Power BI User Group. To find out more and speak confidentially about your job search or hiring needs, please contact me directly at v.simpson@tenthrevolution.com

About the Company

As the global leaders in solving the technology skills gap, we find, train, and deploy experienced professionals, reskill your existing staff and deliver world-class consulting services, all through our unique range of talent solutions. What we do Find talent Permanent and contract recruitment for one role or an entire team Train talent Upskill existing employees via our training programs Deploy talent Access experienced professionals through our hire-train-deploy model Consulting services A new team or project support ... Know more

Related Jobs

Company Name: SevenRooms
Job Title: Staff Software Engineer, Backend
Job Description: The Team & Role SevenRooms is hiring a remote Staff Software Engineer with a backend focus. We’re looking for a strong developer who is excited to engineer highly performant, mission-critical systems that are designed for agile development and rapid scaling. You will partner with other engineers, product managers and designers who are dedicated to engineering real solutions that empower SevenRooms for growth. You will be joining a team of 70+ engineering professionals and will report directly to one of our awesome Engineering Leaders. The 7R Technology organization is committed to building products that help restaurants create magical experiences every day. We are a small, but rapidly growing team of engineers, scientists and builders who are on a mission to fundamentally transform the hospitality industry. Our engineers are guided by the following core values that help us stay connected and shipping often: Ownership, Customer Obsession, Collaborate & Be Transparent, Measure & Monitor, Be Creative, and finally Be Yourself. What You’ll Do Engineering: Design, develop, test, deploy, maintain and improve software with a strong focus on customer-facing features. Become an expert in a system-level view of the SevenRooms architecture. Own and implement major features and architectural changes alongside other engineers. Be a role model and mentor to other engineers; assist in technical design reviews Product Focus: Be the technical owner of features, from design to implementation to ongoing support Project Management: Manage individual project priorities, deadlines, code quality and deliverables; Participate in occasional on-call duties to keep software systems up and running Who You Are BS degree in Computer Science, similar technical field of study or equivalent professional experience 7+ years of software engineering experience Willingness and desire to work in Python, Rust, and Kotlin; prior experience is preferred but not required Strong architectural vision and judgment Knowledge of evolving best practices and advocate for them Experience with: Migrating from monolith to decoupled architecture Scaling engineering teams Mentoring junior developers Experience developing web applications at scale Significant experience with algorithms, data structures, complexity analysis and software design Familiarity with Agile methodologies What We Offer A fresh start: SevenRooms offers the unique opportunity for eligible new hires to participate in our Fresh Start Program, where the company provides the option to curate your own meaningful experience, to reset and refresh. Whether you want to prioritize self-care and rest, connect with loved ones, or treat yourself to something new – the choice is up to you and our team is ready to help make that happen. Equitable compensation: Our compensation packages are based on competitive external market data. At SevenRooms, you can expect to be paid well for your contributions towards transforming the hospitality industry. We also offer equity for all employees as part of our commitment to everyone being an owner and working together to build an outstanding company. Comprehensive benefits package: SevenRooms provides access to private medical coverage, life insurance, and income protection. Employee programs: Through our Roomie’s Choice program, all employees at SevenRooms receive a monthly stipend to spend however they see fit. You will also receive unique milestone awards throughout your journey with SevenRooms, including swag, experiences, and trips to celebrate specific years of tenure. Learning and professional development: Your manager will partner with you on establishing quarterly objectives that not only benefit the company but aid in your overall career development and advancement. SevenRooms also provides financial support for continuing education, certifications, or participation in external training programs as part of many reimbursement options available through Roomie’s Choice. About SevenRooms SevenRooms is a guest experience and retention platform that helps hospitality operators create exceptional experiences that drive revenue and repeat business. Trusted by thousands of hospitality operators around the world, SevenRooms powers tens of millions of guest experiences each month across both on- and off-premises. From neighborhood restaurants and bars to international, multi-concept hospitality groups, SevenRooms is transforming the industry by empowering operators to take back control of their businesses to build direct guest relationships, deliver exceptional experiences and drive more visits and orders, more often. The full suite of products includes reservation, waitlist and table management, online ordering, mobile order & pay, review aggregation, email marketing and marketing automation. Founded in 2011 and venture-backed by Amazon, Comcast Ventures and PSG, SevenRooms has dining, hotel F&B, nightlife and entertainment clients globally, including: Marriott International, MGM Resorts International, Mandarin Oriental Hotel Group, Wynn Resorts, Jumeirah Group, Hard Rock Hotels & Resorts, Wolfgang Puck, Michael Mina, Bloomin’ Brands, José Andrés Group, Union Square Hospitality Group, Australian Venue Company, The Wolseley Hospitality Group, Dishoom, Live Nation and Topgolf. SevenRooms has been recognized as a top employer for its people-first approach by publications including: Inc. Best Workplaces (2023, 2022, 2020) Inc. 5000 (2023, 2022) Ragan’s Platinum HR Awards Finalist (2022) Built in Best Places to Work NYC (2023, 2022, 2021, 2020) Built in Best Place to Work NYC - Midsize Companies (2023, 2022) VentureFizz Unique PTO (2022) Forbes Best Startup Employers (2022) SevenRooms is an equal opportunity workplace and an affirmative action employer. We welcome all qualified applicants regardless of race, color, ancestry, religion, sex (including pregnancy and related conditions), national origin, sexual orientation, age, marital status, disability (physical or mental), gender identity, gender expression, genetic information, veteran status, citizenship, immigration status, or any other classification, category or characteristic protected by applicable federal, state or local laws. We understand the importance of creating a more diverse and inclusive workplace and celebrate our employees for their differences. View our Prospective Employee Privacy Notice by visiting https://bit.ly/2P6ey4M #BI-Remote

London, United Kingdom

Remote

Full Time

26-02-2025

Company Name: Joinrs UK
Job Title: [Full Remote] Software Engineer
Job Description: This position is in the Prima team, a leading provider of car insurance. The summary of the opportunity by Joinrs AI: Prima seeks a full-remote Software Engineer specializing in IAM with experience in Okta and Rust. The candidate will manage IAM SaaS platforms, develop custom services, and support other teams. The selection process will be fully managed by Prima. -- Role and Team This is a backend and infrastructure engineer role with a specialisation in Identity and Access Management (IAM) and security. You will be responsible for the configuration and hardening of workforce and customer IAM SaaS platforms, extending and adapting their functionality, developing custom services, productionising IAM functionality for other engineering teams and maintaining the core access model for Prima. The IAM team works as part of platform security and has the mission to reduce the risk of IAM-related security incidents and data breaches by offering state-of-the art, uniform platform for workforce and customer IAM. The team works closely with the Service Desk team, the people team and engineering teams developing user-facing services. It’s a full-stack and multidisciplinary team that takes full ownership of IAM for Prima, from the deployment of customisations to the user experience and permission modelling. What You'll Do Use Infrastructure as Code (IaC) to manage IAM SaaS such as Okta and Cloudflare Zero Trust. Develop and operate custom services in Rust to extend and adapt SaaS functionality to better support and automate Prima’s processes Help other teams integrating applications in IAM systems, and modelling roles and permissions. Care for the end user experience of IAM platforms creating automated request workflows, internal procedures and documentation and configuring user-facing sections of SaaS platforms. Maintain IaC and software libraries, abstractions and documentation to support the developer experience of other engineering teams adopting IAM solutions. Work with security and the people team to evolve Prima’s core identity and access model. Audit permission models and access exceptions with security, introducing automation into the process. What You'll Need A curious and inquisitive mindset and an aptitude for learning. Experience as a Software Engineer, focusing on IAM solutions. Experience with Okta or other IAM SaaS solutions Familiarity with OAuth 2.0, OIDC, and SAML. Familiarity with automation tools and IaC frameworks like Pulumi. Proficiency in writing code, ideally in Rust and Python. Problem-solving skills and a proactive approach to identifying and mitigating risks. Strong communication skills and a team player mentality. A product development mindset when developing internal developer platforms. Practised delivering value with agile iterative practices and continuous improvement. Familiarity with AWS IAM and cloud security is a plus. We evaluate hybrid or full-remote hirings from the U.K.

Company Name: Zurich Insurance
Job Title: Data Apprenticeship 2025 - Retail underwriting (London)
Job Description: Data Apprenticeship 2025 – Retail Underwriting - London Location: London Salary: £23,387 plus £3,200 location allowance Qualification: Level 3 data technician Start Date: September 2025 Closing date for applications: 23rd March 2025 Insurance is so much more than you think! Are you looking for a career that will excite, challenge and inspire you? If so, an apprenticeship could be the ideal role for you! You’ll find the perfect balance of real life, on the job experience, whilst having time to complete your studies, apply your knowledge and earn qualifications too. With plenty of support around you, including your buddy, you’ll have lots of opportunities to shape your career and to make a difference to our customers at a time when they need us the most. This is a permanent role, your apprenticeship is just the start of your career with us. We'll continue to cheer you on every step of the way once you’ve finished and will remain committed to help you grow. Working in insurance is so varied, you’ll find that there are so many different opportunities for you to explore. An apprenticeship is the perfect way to fast-track your career! Your Opportunity We are currently expanding the team and are looking for people to support the continued growth and development of our Portfolio Management team. Your role could include: Sourcing data in a secure manner Collating and formatting data to present for review and further analysis Blending data by combining it from various sources and formats to explore it’s relevance Analysing simple and complex data to support business outcomes, using different methods to analyse the data Collaborating with people at all levels with a view of creating value from the data Interacting with Brokers to support their customers Staying up to date with market changes, distribution methods, and our competitive position. Building and maintain strong relationships with our internal and external stakeholders. What can I look forward to? Working in our Schemes Portfolio Management department with a team of analysts, you’ll help us achieve our Scheme P&L targets by suggesting improvements to our pricing, underwriting, and proposition. During your apprenticeship you’ll: Learn how to understand and analyse customer requirements and then implement findings. Build data analysis skills to identify risks and opportunities. Develop collaboration and communication skills that help you share our insights with stakeholders in a way that suits different audiences. Understand data, enabling you to make informed evidence-based decisions Use data visualisation tools to create infographics, reports, tables, dashboards and graphs and communicating data insights. Understand how to collate and interpret qualitative and quantitative data. Alongside your day-to-day work, you’ll complete a Level 3 Data Technician apprenticeship which will take around 18 months to complete. In addition to investing in your learning, we give you time to study as well as the opportunity to put what you learn into practice. What’s in it for you? As well as joining a company that is passionate about our people, sustainability and our customers, we also have a competitive rewards and lifestyle benefits package. You’ll receive: £23,387 starting salary £3,200 per annum location allowance 25 days holiday plus an additional 3 volunteering days Flexible bank holidays for religious/cultural events Private medical cover 12% company pension contribution Annual company bonus Discounted gym membership Discounted gadget insurance Discounted technology offers What you’ll need: Full right to work and reside in the UK – Due to apprenticeship funding regulations, we cannot accept applications from those who require sponsorship to work in the UK. You must have resided in the UK for a minimum of 3 consecutive years. A minimum of five GCSEs (or equivalent) at grade C/4 including Maths and English. A professional attitude with a positive ‘can do’ approach to your work Strong interpersonal and communication skills Ability to build strong working relationships NB: Due to Apprenticeship funding rules, we can only accept applicants who haven’t completed a qualification in the same field at the same or higher level to the course you are applying for Are you ready to create a brighter future? At Zurich our brand purpose is to create a brighter future together, for our customers, our partners, our employees and the planet. It’s a promise that for our customers, we will put their needs at the heart of everything we do and for our employees, to grow and develop together. For our partners, to collaborate to create mutual value and for the planet, to drive positive impact by integrating our sustainability work into how we do business. We put our customers at the heart of everything that we do, and we’re looking for like-minded people to join us. We’re passionate about diversity and inclusion, we want our people to bring the whole of themselves to work. You’ll have every opportunity to use your drive and enthusiasm to innovate the future of Zurich. Everybody is made to feel welcome, different opinions are valued, personal needs are respected, and opportunity is equal for all. So, make a difference. Be challenged. Be inspired. Be supported, Love what you do. Work for us. Please note we are unable to progress your application if you don't meet our criteria listed above. Please ensure you have the right to reside and work in the UK before you apply as we are unable to provide sponsorship. You must have resided in the UK for a minimum of three consecutive years in order to apply. xxxxxxxxxxxxxxxxxxxxxx

London, United Kingdom

On site

Full Time

03-03-2025

Company Name: NEC Software Solutions
Job Title: Senior Developer - .NET
Job Description: Company Description Come join us and make a difference in the world! Discover more at www.necsws.com Job Description Here at NECSWS our Public Safety division provides mission critical command and control software to the Emergency Services globally. This Senior Developer role is to work with a team responsible for delivering a largely internal facing role in an agile software development team responsible for delivering telephony and communications software solutions, supporting the team meet its sprint goals and deliver quality software on time and to budget. The role is “hands on” being full involved in the code base of the applications using in depth knowledge of .NET framework, data structures, code efficiency and problem-solving skills. The seniority of this position means you will work closely with and report to the Software Development Manager to ensure issues and risks are manged in a timely manner. Collaboration within the team with all disciplines including Solution Assurance and Business Analysis is essential to the role. It’s fully expected that suitable candidates will participate in architectural design decisions and the influencing of technologies considered within the current and future product suite. Qualifications Essential Qualifications/Experience Significant experience within software development in a senior capacity Detailed knowledge of .NET development using C# Agile Software Development Methodologies such as Scrum and Kanban Session Initiation Protocol (SIP) Real Time Transport Protocol (RTP) Knowledge of Telephony and Communications infrastructure and call management Experience of using Azure or other cloud environments Experience developing with Microsoft SQL Server (Query’s, View, Stored Procs, Scripting) Message Queues Experience in contributing to and making architectural and technical design decisions. Experience of source control repositories e.g., GIT Strong working knowledge of developing enterprise applications Knowledge of design patterns Desirable Experience / Knowledge Microsoft Azure DevOps Microsoft SQL Server (Administration, Performance Tuning) Behavioral Driven Design (BDD) Knowledge of C / C++ programming language Type Script React Experience of using Azure or other cloud environments Additional Information We pride ourselves in offering an excellent benefits package. When you join the team at NEC Software Solutions, you are provided with the following: 25 days paid holiday with the option to buy/sell (FTE) 4 x basic salarylife assurance cover (with the option to increase cover at an additional cost) A Group Pension Plan A selection of flexible benefits to suit your individual needs Other Information Candidates must be able to demonstrate a pre-existing right to work and travel within the UK. Documentary evidence will be required. All offers are subject to satisfactory vetting, references and occupational health checks. Depending on the nature of the role a DisclosureBarring Service (DBS) check may also be required. NEC Software Solutions is an equal opportunities employer, welcoming applications from all communities.If you require any reasonable adjustments or have specific accessibility needs during the recruitment or interview process, please feel free to share these with us. We are committed to ensuring an inclusive and accommodating experience for all candidates. Who We Are: We’re NEC Software Solutions (part of global tech giant NEC Corporation). While you read this ad, our software is helping to dispatch ambulances, support families, keep trains on the move, locate missing people and even test the hearing of newborn babies. Working with us, you’ll be helping our 3,000+ employees push the boundaries of what’s possible and support amazing public services. We work with governments, hospitals, police forces, housing providers, local authorities and more. We help them pay financial support faster, speed up treatments for patients and respond to emergencies in the right way. The more we do, the more our customers can do for others. And together, we make a world of difference. We’d love your help. And we’ll support you all the way.

Hartshorne, United Kingdom

On site

Full Time

27-02-2025