BI Developer

Our customer is looking for an experienced BI developer to design and develop analytics solutions.

This is a critical role within the team, with outstanding opportunity for future growth. This role is either a London or Work from Home role. to £80k and good benefits.

The core technical work is database development on a cloud big data database platform (Amazon Redshift), but includes interfaces, ETL and data pipelines, and visualisations, and working with the various cloud services and analytics packages that provide these capabilities. The initial focus for the role will be working on a new service performance analytics solution, but the role will not be limited to this project, and there is room for growth across a range of projects and platforms – including Machine Learning and AI. The role will involve working with IT and business stakeholders to understand requirements, and working with users to ensure developments meet the business need

Key Responsibilities

Develop high quality solutions to meet business requirements:

  • Design and develop end to end BI solutions
  • Work with stakeholders and users to understand requirements
  • Ensure compatibility with required analytics packages
  • Produce analytic dashboards, according to user requirements
  • Support user interrogation of the database, with documentation and consulting support
  • Proactively identify and resolve issues, including performance and data quality problems
  • Work with product and project managers to maintain roadmaps
  • Identify potential datasources to meet user requirements, work with IT colleagues to develop robust and secure interfaces
  • To own the integrity of the data within the platforms and ensure this is maintained
  • Identify potential improvements in existing build
  • Manage 3rd parties in the monitoring and support of the data feeds and platform to ensure SLAs are being adhered to
  • To continually review security of the platform and ensure any new threats are addressed in a timely manner
  • Ensure the platforms readily supports addition of interfaces and use cases as required
  • To ensure a library of technical documentation is maintained and regularly updated

Key Experience

  • Required
    • Excellent knowledge and experience of SQL and database design and development
    • Excellent knowledge and experience of Business Intelligence data modelling
    • Excellent knowledge and experience of database housekeeping and tuning techniques
    • Strong experience working with cloud computing technologies, preferably AWS
    • Strong experience working with one or more cloud data warehouses (for example Snowflake, Redshift, BigQuery, Athena), and an in depth understanding of their architecture, and best practises for design
    • Strong knowledge of AWS services, including Redshift, S3, Lambda, Kinesis Streams, Kinesis Firehose
    • Strong coding experience, ideally working with Python
    • Good experience working with ETL tools
    • Experience of testing and deployment processes
    • Experience of managing deployments to production environments
    • Experience working with analytical packages, and an understanding of how these integrate with data platforms
    • Understanding of broader cloud data services and capability

Key Behaviours/Attributes

  • Performance and delivery oriented
  • Analytical mindset with a problem-solving aptitude
  • Ability to communicate to a wide range of business audience, to ensure their requirements are understood and prioritised
  • Willingness to confront and ask probing questions to understand colleagues needs
  • Good written and verbal communication skills
  • Operate effectively in unfamiliar environments, remaining calm under pressure and agile in approach
  • Proactive and positive attitude
  • Transparent and open style
  • Excited by a challenge and enthusiastic about developing the wider team
  • Takes responsibility for personal objectives
  • Desire to succeed!

 

 

If you are interested in finding out more about this job, please get in touch: