Business Intelligence Consultant

As a Business Intelligence Consultant, you will be working as part of an agile team in the Data & AI practice to deliver solutions to our clients ensuring they get maximum value from their data. We play to people’s strengths, and you can expect to be hands-on, providing the opportunity for you to utilise and continually develop your existing technical, consultancy and project skills to deliver high quality solutions.
We work with a Winning from Anywhere® approach but there is an element of travel to client sites when required, along with travel to our company conference and events.

• Delivering full life cycle solutions to our clients, from data acquisition, engineering, modelling, analysis, and visualisation.
• Running workshops with clients gathering information and communicating with clients on both a business and technical level.
• Migrating on-premises data solutions to the cloud. So, knowledge of the SQL Server stack (SQL, SSIS, SSAS and SSRS) is expected.
• Reports, Dashboards and Analysis using tools such as Power BI to help our clients visualise their data and present it to the wider business.
• The continued support and development of a data solution following go live.
• Ability to build relationships within a team and with our clients, creating an environment where people feel they belong and can fully contribute.
• Experience in requirements gathering from various levels of stakeholders across a business.
• Extensive experience in a BI, Data Engineering or Data Warehouse Development role involving hands-on experience with the Azure and\or SQL Server technology stack.
• Experience in designing and developing ETL\ELT processes using the Azure platform (Azure Synapse Analytics, Data Factory, Data Bricks) supported with SQL and Python.
• Exposure in implementing data lakes and medallion lake house design.
• Experience of working with large data volumes in a BI or Data Warehouse project.
• Experience in writing complex Python \ SQL queries (DDL, DML) and Stored Procedures.
• Exposure to Analysis Services Development Multi-Dimensional\Tabular (MDX, DAX).
• Expertise in the delivery of complex Dashboards, Reports & Analytical Models using a variety of different tools.
• Understanding of business intelligence and data warehousing concepts.
• Strong database design and development skills in any relational database technology.
• Good knowledge of optimisation techniques and design patterns for large data solutions. In addition to a competitive salary, there are a number of benefits and perks we offer to say thank you for being a part of our journey:
• To work at a 3* World Class Best Company
• Flexibility over where you work with our Winning from Anywhere® approach
• 25 days holiday
• Home working allowance paid monthly
• Winning from Anywhere® allowance to help your set up at home
• 24/7 GP at hand
• Immediate 24/7 access to an Employee Assistance Programme
• We’ll support you when you’re not well with our Company sick pay scheme
• Private health insurance after a successful year’s service
• Enhanced parental pay and leave, supporting you with those precious life moments
• Access to the Perkbox platform to help make your money go further
• Cyclescheme
• Electric car scheme
• And many more!