Data Warehouse Developer - 6 Month FTC (Remote)

Heard of us?

We're an award-winning bank; backing people to fulfil life's hopes and dreams.

Now is your chance…

Our CTO division aims to support and help build the Aldermore business, providing excellence in IT Delivery, Enterprise Architecture, Solutions Architecture, Information Security, Operations and Development.

As we continue to grow, it's key that the CTO team works closely with all parts of the Bank, helping to deliver activities through the supply of stable, secure and reliable technology solutions and to provide innovation in building the technology strategy for the future. We are committed to delivering an ever improving environment and better customer experience. Here you'll find yourself at the heart of a dynamic, growing division where innovation and teamwork thrives.

The role of Data Warehouse Developer is within the Data Warehouse team which own and develop the Data Warehouse. The Data Warehouse is critical to our business and regulatory processes and is depended on by many colleagues (our customers) across the bank.

This role is a 6 Month FTC and when the time is right, we would love to welcome you to our Manchester office. In the meantime you will be based remotely. You'll be made to feel part of your new team by your Line Manager Data and Analytics Platform Manager and colleagues through regular contact and virtual interaction.

What would your day look like?

• Have a strong working relationship with the wider business (including but not limited to the Architecture and Data Science teams) to create technical requirements, best-practice driven data warehouse designs and BI solutions, that will empower business users to embrace data confidently and responsibly address their complex challenges
• Design, build and manage dimensionally-modelled data warehouse
• Minimise duplication of data and logic to achieve the "single source of the truth"
• Build complex data visualizations, dashboards, KPI reports, etc. using Reporting Services, Tableau and other tools
• Contribute to & implement continuous improvement identified as crucial to the enhancement of the data warehouse, the team & associated processes

What do we expect of you?

• Strong T-SQL knowledge using SQL Server 2008/2012/2014 or later
• Expertise in SQL, ELT/ETL, reporting and Visual Analytics tools including SSMS, SSRS, SSIS
• Designing and implementing complex technical processes using Microsoft technologies
  • SQL, SQL Server, SSIS, SSRS, SSAS
• Designing and implementing Data Warehouse processes using Kimball methodology
• Experience of working on a Data Warehouse
• Previously worked within a Financial Service Organisation

What can you expect of us?

• A friendly and flexible culture, synonymous with our proposition to our Customers.
• A smart yet comfortable working environment, well located for the daily commute and those lunchtime errands.
• A growing organisation that defines itself as being nimble, lean and strong.
• A drive for continuous improvement, for which you will be empowered to get behind from day one.
• A visible and approachable ExCo; who you will very likely to bump into whilst making your morning coffee.

And of course you will be compensated competitively, with a good range of core benefits and bonus potential.

Still Curious?

Aldermore Group was formed by bringing together two very successful businesses, Aldermore Bank and MotoNovo Finance, under the First Rand umbrella. Whilst our parent company operates internationally from their HQ in South Africa, we are a UK-based financial services specialist that supports our customers across a range of products and services.

Underpinned by our strategic blueprint, "backing people to fulfil life's hopes and dreams", we thrive upon saying "yes" to our customers. We respect the ingenuity of entrepreneurs and their startups; we give first-timers a leg-up onto the property ladder; and we open up the lending market to many.

This is where you come in. We are on a journey. A journey defined by a destination; to deliver on our purpose over the course of the next 3 to 5 years.

Join us today and we will make the same promises to you as an employee, as we do to each of our customers. We are committed to building a working environment that values respect, diversity, and compassion. We welcome people regardless of age, disability, gender identity, marital status, race, faith or belief, sexual orientation, socioeconomic background, and whether you're pregnant or on family leave.

#backingyoutobringyourbest

Aldermore is an equal opportunities employer.

We do not accept speculative agency CVs. Any CV received by Aldermore will be treated as a gift and not eligible for an agency fee. PSL agencies should only send CVs if authorised to do so by HR.

Where a DBS check or CIFAS check is identified as necessary, all application forms, job adverts and recruitment briefs will contain a statement that an application for a DBS certificate or a CIFAS check will be submitted in the event of the individual being offered the position.