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