Azure SQL Data Developer (9 Months FTC)

Comic Relief

Employment Type Contract 9 Months
Location Hybrid · London, City of, UK 2 days a week in our London Office
Salary £42,345 - £47,975 (GBP)
Team Data & Analytics
Seniority Mid-level
  • Closing: 11:59pm, 22nd May 2024 BST

Perks and benefits

Flexible working hours
Work from home option
Life Insurance
Wellness programs
Employee Assistance Programme
Enhanced maternity and paternity leave
Paid emergency leave
Sabbatical Opportunities
Professional development
Mentoring/coaching
Paid volunteer days
Payroll giving
Salary sacrifice
Team social events
Extracurricular clubs
Cycle to work scheme
Free fruit

Candidate happiness

8.54 (8334)

Job Description

​​​​This role is offered on a hybrid contract giving you the opportunity to also work from home three days a week.

PURPOSE OF JOB: 

We are seeking a skilled Azure SQL Data Developer for a fixed term contract (initially 9 months with the possibility of extension) to assist with the seamless integration of data from multiple sources into and out of our Azure Data Lake. The successful candidate will be responsible for maintaining the flow of data through various ETL steps and ultimately integration into Salesforce NFP Cloud and Marketing Cloud, both of which are in the implementation phase. This role requires experience in data management technologies, particularly Azure Data Lake administration and Azure Data Factory and Functions. Experience of Salesforce NFP would also be an advantage. 

Ours is a collaborative, supportive environment which will ensure you reach your full potential.  You will play a key role in delivering the data and platforms which ensure that all of our activities are guided by our audience and our social impact, as we work towards our vision of a just world, free from poverty.   

Come and join us and help make a real difference to the lives of those who need it most. 

 Interviews are expected to take place on Wednesday 29th of May

KEY RESPONSIBILITIES:  

  • Data Integration support: Work with the Data Integration Manager to ensure efficient and accurate flow of data from diverse sources into and out of the Azure data lake.Responsible for building data pipelines with Azure Data Factory. 

  • Azure Data Factory maintenance: Maintain ADF ETL pipelines and functions to ensure efficient, reliable, and continuous data management in and out of the data lake 

  • Salesforce NFP Implementation support: Support the data integration with Salesforce NFP Cloud, ensuring seamless integration with data lake and other systems using APIs and partner services 

  • Data Cleansing and Harmonization: Work with others to support Aperture Data Studio to cleanse and harmonize data within the Azure data lake, ensuring data quality and consistency. 

  • Collaboration: Collaborate with cross-functional teams and personnel including the Data Integration Manager, Data Analysts, Data Quality Administrator, and business stakeholders to understand data requirements and ensure alignment with business objectives. 

  • Documentation: Maintain and where needed document data integration processes, configurations, and workflows to ensure comprehensive understanding and facilitate knowledge sharing within the organisation. 

  • Azure Data Lake administration: Manage and administer Azure Data Lake Storage accounts and associated resources, including security policies and access controls 

  • Continuous Improvement: Continuously monitor, evaluate, and troubleshoot data integration processes, identifying opportunities for improvement and implementing enhancements to optimize efficiency and effectiveness.   

  • Procedures: Adhere to appropriate code management, change control, governance, and release management procedures. 

  • Support for the requirements of the Data & Analytics Team, and the wider Technology directorate. 

  • Responsible for understanding and applying good data governance practices at every stage. 

ESSENTIAL SKILLS AND COMPETENCIES: 

  • Proven experience in data integration, ETL development, data transformations, and data management. 

  • Experience performing complex data transformations at scale. 

  • Competency in Azure SQL data technologies including Azure Data Lake Storage Gen2, Azure Data Explorer, Azure Data Factory, and Azure Functions. 

  • Experience in data cleansing and transformation, able to identify and resolve data quality issues.

  • Strong SQL Skills for data extraction and transformation: T-SQL, KQL, C#, Powershell, and Python 

  • Understand and interpret the data models of un-familiar OLTP systems 

  • Excellent problem-solving and analytical skills with strong attention to detail. 

  • Strong communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams (both technical and non-technical). 

  • Azure Data Lake Administration. 

  • Ability to deliver data to detailed data specifications. 

  • Experience building robust data pipelines to extract data from a variety data sources for data migration 

     

  DESIRABLE SKILLS AND COMPETENCIES: 

  • Experience working in a nonprofit or philanthropic organization 

  • Knowledge of PowerBI, Aperture Data Studio. 

  • Experience of Salesforce NFP Cloud and SOQL 

  • Experience of using Github for source control. 

  • Experience of working in an Agile environment. 

Don’t meet every single requirement? Studies have shown that women and people of colour are less likely to apply to jobs unless they meet every single qualification. At Comic Relief we are dedicated to building a diverse, inclusive, and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

Why work at Comic Relief

There are lots of good reasons to join us at Comic Relief. You can read more about our employee benefits, such as our commitment to flexible and hybrid working. We ask staff to come to the office twice a week, normally on agreed team days, so that we can do all those things that are difficult to do online. Our office is based in Whitechapel, London,. There are lots of opportunities to develop your skills and experience at Comic Relief, including opportunities to become a Mental Health First Aider or to participate in our Employee Network Groups that focus on making Comic Relief a more inclusive place to work.

 

Disability Confident employer

 As part of the Disability Confident scheme, we take positive action by providing first-round interviews to candidates who have a registered disability, provided they meet the minimum criteria for the role, as demonstrated on their CV and application questions.

We ask that candidates that wish to be considered for this scheme email j.scott@comicrelief.com to discuss further. Please do not email CV's/cover letters

Removing bias from the hiring process

Applications closed Wed 22nd May 2024

x

Removing bias from the hiring process

  • Your application will be anonymously reviewed by our hiring team to ensure fairness
  • You’ll need a CV/résumé, but it’ll only be considered if you score well on the anonymous review

Applications closed Wed 22nd May 2024