BI Developer

 

Main characteristics

Location

Banbury, Oxfordshire

Company

Planet Recruitment

Salary

£30000 - £35000/annum

Employment type

Contract

Category

IT

Job summary

BI Developer

Banbury

Fixed term contract - 12 months

£30k - £35k

Job Description

We are looking for a business intelligence (BI) developer who will be working on designing various analytical reports on company data and delivering them to management and other interested parties. As a BI developer, you will be working with business users, collecting their requests, and then updating the set of existing BI reports to accommodate business needs. You will be expected to establish company standards and common reporting terminology, and to help align existing and future reporting requests to such standards. Working on and developing ERP system.

BI Developer Responsibilities

Collect and maintain the set of business reporting requirements.

To build & maintain dashboards and reports in Power BI underpinned by SQL and bespoke reporting applications.

Translate business needs to technical specifications.

Design, build and deploy BI solutions.

Maintain and support data analytics platforms.

Create tools to store data.

Analyse existing reports and optimize them for standardization across the company.

Conduct unit testing and troubleshooting.

Evaluate and improve existing BI systems.

Collaborate with teams to integrate systems.

Develop and execute database queries and conduct analyses.

Create visualizations and reports for requested projects.

Develop and update technical documentation.

Set up and maintain BI tools, infrastructure, and integration with company data sources.

Tabular Modelling - Build and Enhance existing SSAS Tabular.

Support projects and produce business reports upon request to influence key business decisions.

Take ownership over your workload and tickets coming in, prioritising queries based on business needs.

Keep on top of Data Quality and reporting efficiency, adopting a continuous improvement mind set wherever possible.

Liaise with internal and external customers to understand their business and technical requirements, documenting required components such as data structure, workflow, dependencies, and then develop a technical solution to meet their needs.

Familiarity with Azure Open AI, showcasing an understanding of leveraging AI capabilities within the Microsoft Azure ecosystem for enhanced functionality and innovation.

Support and manage testing.

Proactively staying up to date with release notes, take ownership for testing during upgrades and ensuring the data services team are fully skilled in its operation.

Required Skills

Proven experience as a BI Developer or Data Scientist

Background in data warehouse design (e.g. dimensional modelling) and data mining

In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.

Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)

Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).

Proven abilities to take initiative and be innovative.

Analytical mind with a problem-solving aptitude.

BSc/BA in Computer Science, Engineering, or relevant field.

Strong communicator, both written and verbal.

Strong analytical skills.

Ability to work in a fast-paced environment.

Understanding of data integration concepts and ability to connect to various data sources using connectors, gateways, etc.

Experience working on multiple projects simultaneously.

Advanced SQL & understanding of SQL Data Warehousing.

INDIT

Planet Recruitment is acting as an Employment Business in relation to this vacancy