Data & Insights Developer, London

Data & Insights are a core function at Quintessentially and we champion data. We utilise the vast and varied data we have access to, driving key business functions.

The role of Data & Insights Developer will expand and maintain the reporting and analytical capabilities of the Data & Insights team by providing robust solutions and designing new processes

Responsibilities

  • To maintain existing data structures, and to plan, design and create new data storage
  • Maintain existing, optimize and create new SQL Server statements/processes to help with reporting.
  • Collaborate with other team members and stakeholders.
  • Identify and implement efficiencies to existing systems.
  • Maintain and/or create reporting automation processes.
  • Integrate 3rd party data
  • Ensure performance, security, and availability of databases.
  • Prepare and maintain documentations and specifications.

The Ideal  Data & Insights Developer

  • To maintain existing data structures, and to plan, design and create new data storage
  • Maintain existing, optimize and create new SQL Server statements/processes to help with 
  • Collaborate with other team members and stakeholders.
  • Identify and implement efficiencies to existing systems.
  • Maintain and/or create reporting automation processes.
  • Integrate 3rd party data
  • Ensure performance, security, and availability of databases.
  • Prepare and maintain documentations and specifications.

Essential

  • Minimum 5 years of experience using SQL server
  • Minimum 2 years of developing and analyzing data in Power BI
  • Minimum 2 years SSRS reports development and troubleshooting SQL
  • Strong proficiency with Microsoft SQL Server 2016
  • Maintaining and creating tables, views, stored procedures and functions
  • Write complex and optimize existing SQL statements
  • Ability to plan resource requirements from high level specification
  • Capable of troubleshooting common database and SQL statement issues
  • SSIS: Maintain and create new SSIS and SSRS packages
  • Deploy, schedule and monitor packages Power BI Maintain and create new Power BI reports that support various teams in the business Proficiency in writing DAX language and troubleshooting existing DAX queries Expert in managing
  • Power BI reports in the Power BI service (will be good to have some Power BI Admin experience)
  • Ability to configure Power BI gateway and troubleshoot issues that might occur Good understanding and practical experience of setting security levels on Power BI reports as well as disseminating Power BI reports via various means like embedding securely in SharePoint O365, creating Dashboards in the Power BI service for end users etc Salesforce: Run, maintain and create new Salesforce reports and dashboards.
  • Respond to ad-hoc report requests.

Other

  • Strong working knowledge of Microsoft Office, with Excel in particular Effective communicator Ability to gather requirements from stakeholders and turn it into insights Used to working in a team Desirable Other: Excel VBA Understanding of machine learning theory and its application. Data visualization expertise Luxury industry knowledge  

Hours of Work

Contractual hours are from 0900 to 1730 Monday to Friday.
However, it may be the case that in order to fulfill the duties of the role, different or additional hours may be necessary.
Requirement to be on call outside working hours in case of service-related emergency.