Title: Azure Data Engineer

Contract: Fixed Term Contract (2 years), Full Time or Part Time

Location: Office based 20-40% at Trafford (Manchester) or Stratford (London) with the option to work from Sidcup

Persona: Agile, Office based 20-40% dependant on business needs

Salary Circa £50-65k pa depending on experience and location

Closing date for completed applications:  22/08/22 

A great opportunity has arisen for an innovative and forward-thinking Data Engineer to help shape the Data Platform Landscape of L&Q. You will be developing and deploying cutting-edge solutions that leverage Azure cloud services. You'll join an established data engineering team and will be mentored to learn new skills and grow.

The Azure Data Engineer will be responsible for:

• Designing and implementing projects focused on collecting, aggregating, storing, reconciling, and making data accessible from disparate sources to enable analysis and decision making. Playing a critical part of the data supply chain by ensuring that stakeholders can access and manipulate data for routine and ad hoc analysis. Supporting the full lifecycle of data from ingesting through analytics to action.

Skills and Experience:

• Must have previously worked in Data Warehouse, ETL or BI platforms, with a good understanding of data and Data Warehousing concepts. Experience on Building and managing fully automated data pipelines Experience with relational databases (e.g. SQL Server) Strong experience with SQL and T-SQL Knowledge and experience working with ETL tools Experience working with database, storage, collection and aggregation models, delta loading, external data load

Desirable:

• Experience with at least one of the programming languages: Python, PySpark, Scala, R. Experience working on cloud (Azure) Experience with Azure Data Factory, Logic Apps, Databricks is highly desirable Exposure to PowerShell Scripting would be advantageous. Experience of working in an agile cross-functional delivery squad working with product owners, solution analysts, solution architects and test analysts Awareness and understanding of key DevOps and cloud concepts including CI/CD, Iaas, PaaS and SaaS with enabled multi-disciplined, cross functional capabilities. Containerisation experience highly desirable Experienced in designing and coordinating existing pilots, prototypes or proof of concepts. Experience of the underlying technology in order to develop data integration layers and associated systems to provide repositories of information

L&Q’s most important resource is our people. L&Q offers incredible work life balance (flexible working) coupled with competitive salary depending on experience. In addition to our support, learning and development opportunities, the successful candidate will have access to our full suite of benefits including 26 days holiday rising to 31 days with length of service, annual bonus subject to group performance, excellent pension scheme (L&Q ‘double matching’ your savings up to 6%), Benenden Healthcare, Season Ticket Loans, VDU Eye Care Scheme, an employee assistance programme and non-contributory life assurance.

*We are a multi-site organisation, so some roles may require occasional travel between offices but expenses will be covered. 

At the foundation of everything that we do are our corporate values and associated behaviours. Our organisational behavioural framework outlines the core expectations of all employees, which should be demonstrated at all times when representing L&Q.   More information about L&Q’s values can be found on our website and a copy of our behavioural framework can be provided on request.

COVID 19: The safety of our staff and our candidates is of the utmost importance. Every effort will be taken to ensure that safe ways of working are adopted throughout the Recruitment and Selection process. We are introducing extra precautions in line with UK Government Guidelines. Our recruitment processes will follow social distancing and COVID-19 Secure requirements. This will include the use of various technologies to support the interview process. Should candidates have any questions regarding this, or if you require additional support please let us know at the interview planning stage.

Our commitments:

At L&Q, people are at the heart of our business and our success depends on employing the best people and getting the best from them. This is why we are committed to developing our people. It's only by investing in a well-trained and motivated workforce that we can continue to prosper and sustain business success.

In addition to our support and training, the successful candidate will have access to our full suite of benefits including 26 days holiday rising to 31 days with length of service, annual bonus subject to group performance, excellent Pension scheme, Benenden Healthcare, an employee assistance programme and non-contributory life assurance.

We are committed to supporting your work-life balance and recognise the changing demands and circumstances in life.  Please let us know during the recruitment process if you’re interested in part time working or job sharing.  In addition, should your circumstances change once you have joined L&Q, you can also request flexible working arrangements, e.g. a change to working hours - if it’s feasible then we’ll make it happen.

We are recognised externally for our commitment to inclusion.  We are a Stonewall Diversity Champion, a Disability Confident (Committed) employer and have signed the Time to Change Employer Pledge to demonstrate our commitment to end mental health discrimination in the workplace.

We expect all of our employees to support our environmental policy and social responsibility work. We are an employer committed to environmental and social responsibility.

L&Q is a regulated charitable housing association and one of the UK’s most successful independent social businesses. The L&Q Group houses around 250,000 people in more than 97,000 homes, primarily across London and the South East.

As a charitable organisation, our role goes beyond providing homes and housing services. We are a long-term partner in the neighbourhoods where we work. We hope to build aspiration, opportunity and confidence in our communities through our £250 million L&Q Foundation and our skills academy. 

In response to the housing and affordability crisis, we will build 100,000 new homes over ten years. Of these, 60,000 homes will be built or funded by L&Q, whilst a further 40,000 will come through partnerships. Crucially, at least 50% of these new homes will be genuinely affordable, with a target of 60% in London.

Our vision is that everyone has a quality home they can afford, and we combine our social purpose with commercial drive to create homes and neighbourhoods everyone can be proud of.