Skip to main content

This job has expired

SQL Developer - London Bridge, London

Employer
iQ Student Accommodation
Location
London Bridge, London
Salary
£55,000 - £60,000 per annum
Closing date
19 Apr 2024

Job Details

SQL Developer - London Bridge, London

Job Type: Permanent

Being curious and open to new ideas? It's an iQ thing.

iQ is one of the UK's biggest providers of student accommodation, committed to giving our 30,000 students in 77 sites across 29 UK cities their best year yet. Our London- and Manchester-based support teams are the oil that keeps the iQ wheels turning, providing our brilliant site teams (circa 600 employees) with everything they need to deliver a fantastic student experience every day.

The iQ Support functions cover everything from Real Estate and Legal to Marketing, People and Finance, but what we all have in common is our uncompromising commitment to doing the right thing, even when nobody's watching. It's an IQ Thing!

What makes a great iQer?

iQers are a pretty special bunch. Our team is bursting with independent thinkers and problem solvers, who join us to explore what's possible and build a career as part of a diverse, fun and supportive team. If you have people skills, personality and potential, you're already our cup of tea Ready to feel like you've got the best job ever?

We are looking for an SQL Data Platform Engineer who will have responsibility for bringing together all data sources into an Azure Cloud Data Warehouse to be leveraged for BI reporting, analytics, AI and machine learning initiatives.

This role will focus on designing, implementing, and maintaining all data pipelines across multiple cloud SQL environments, ensuring data integrity, security and performance are maintained to a high standard and using best practice approaches.

The role sits within the Development team, reporting to the IT Development Manager, and will work closely with internal business and technology teams, as well as external service partners to deliver continuous improvement of an industry-leading platform.

Key Responsibilities:

  • Working with the BI Team to design and build best-in-class data warehouse components.
  • Designing, building, and maintaining quality ETLs and ELTs to make corporate data accessible for reporting, analytics, and machine learning.
  • Monitoring the SQL & BI Estate to ensure high levels of performance, security and availability.
  • Designing and maintaining sustainable access control and permission mechanism for data users.
  • Maintaining separation of Dev, Test and Production environments and release management.
  • Using Cloud tools and appropriate data connectors for the extraction of data from business systems.
  • Using enterprise-grade AI service, Azure Machine Leaning for end-to-end machine learning lifecycle to aid decision support and automation for the business.
  • Engineering and maintaining all supporting data designs and updating their documentations.
  • Providing support by responding to user requests and questions; researching and correcting system issues and following up with end users to ensure satisfaction of issue resolutions.
  • Tracking and monitoring incident resolution working with technology partners as required.
  • Reporting on common sources of technical issues or questions and making recommendations.
  • Ensuring on-going integrity of data and compliance to GDPR.
  • Being on the lookout for ways to improve monitoring, discovering issues and delivering better value to the customer.
  • Working with our Managed Service Provider to manage all Reporting and Analytics infrastructure.

Skills and experience:

 

  • Significant experience of Azure SQL Development and Data Engineering.
  • Sound working experience of SQL operations; queries, query optimization, joins, entity normalization, Views, Functions & Stored procedures.
  • Significant experience managing quality ETL and ELT pipelines.
  • Experience of working with Azure Cloud Services data engineering and modelling toolsets including but not limited to, Azure Automation Account, Azure Automation Runbooks, Azure Machine Learning, Azure PowerShell, Azure Logic App, Azure Function etc.
  • Experience design and implementing Data Warehouse process using both relational and dimensional modelling (Kimball methodology).
  • Strong analytical skills with the ability to identify solutions to problems.
  • Experience documenting database designs, processes, and specifications.
  • Excellent verbal and written communication skills.
  • MS SQL, SSAS.
  • Azure Cloud Services data engineering toolsets; Azure Analysis Services, Azure Automation Account (inc Runbooks), Azure Machine Learning – ML as a service, Logic App, Azure PowerShell, Azure Functions, Azure DevOps, CI/CD pipelines.
  • Visual Studio
  • MS Power BI (and related tools)

We work a hybrid working model with 2/3 days in our office in London Bridge. Apply today and find out what its like to work at iQ

Benefits:

  • 25 days annual leave, plus bank holidays (pro rata for part-time)
  • Additional day off to celebrate your birthday
  • Discretionary bonus
  • Pension: we match your contributions up to 8%
  • Gym Discounts
  • Life Assurance
  • Access to thousand's of discounts and offers at shops you know and love
  • Season ticket loan
  • Cycle to work scheme
  • Flexible working policy

Company

iQ Student Banner

We're iQ Student, the 2nd largest provider of student accommodation in the UK. Our mission is to reimagine the student living experience, and give our Students their best year yet. We always look for passionate individuals who want to make a difference to our students' lives. In return we can offer you a fun working environment, excellent perks and we'll also help you to develop in your career with our awesome learning and development opportunities.

So what are you waiting for? Apply now and show us what you can do.  

Company info
Mini-site
iQ Student Accommodation

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert