back to job board

Data Integration Analyst, SQL, SSIS, Azure, ADF

Are you an experienced Data / Integration Analyst that can add value to an expanding function? Do you SQL Server and SSIS experience as well as exposure to Azure and Azure Data Factory? developments skills? Let Informed Recruitment help you to achieve your potential with an exciting opportunity for a Data / Integration Analyst to support a data function in the midst of digital transformation.  As a specialist provider of resource to the Property & Associated Technology markets, we are delighted to be partnering with a social enterprise offering you the opportunity to make a difference and take responsibility as part of modern environment championing continual improvement on an outside of IR35 contract basis.

The purpose of the role will be to provide departmental support around a project to migrate SQL-reporting into Azure.   Day-to-day duties will include developing and implementing data flows; Create custom SQL exports; Delivering the acquisition, cleansing, and transformation of data; Identifying opportunities through the production of analysis, comparisons and benchmarks; Engaging with subject matter experts within the organisation to understand data quality and lineage; Undertaking complex analysis of information to ensure consistent and accurate reporting to meet the needs of stakeholders; Providing regular data and information updates; Routinely undertaking data-quality checks to a high-level of data accuracy; Leveraging business intelligence tools; and associated documentation.

Must Have

  • A commercial track record in data, information or performance analysis and an understanding of the principles of data management.
  • Data integration experience utilising SSIS
  • Experience of working with SQL Server databases and tables.
  • SQL scripting to interrogate data sets
  • Experience working Azure data, and Azure Data Factory specifically.
  • Advanced MS Excel skills including Power Pivot Tables, DAX, VBA, and/or macros.
  • Identification of data errors through exception reporting and subsequent data cleansing.
  • Experience working with data from multiple sources.
  • A good understanding of database structures and translating business requirements into report definitions.

Nice to have / Will Strengthen Application

  • Experience working with data sets from social housing and / or with social housing management systems (Such as Civica Cx, NEC Housing, MRI/Orchard, Aareon QL, Capita One/OPENHousing, MIS ActiveH, or similar.)

As an individual you will have excellent problem-solving skills and attention to detail, whilst also being a self-starter comfortable with taking responsibility for delivery. You will have excellent interpersonal skills, the ability to think on your feet and be ultimately goal orientated. The role will be predominantly home based, with ad hoc days on site in the North West as required which will be expensed. On offer is a day rate engagement initially for three months, and outside of IR35. To take advantage of this opportunity please apply immediately as interview slots are available immediately for suitable applicants.

Share job post

Apply for this job

Please login as a candidate to submit a job application.


Looking for monthly vacancy updates and news? We would love to hear from you.