Job description


  • Entry level
  • No Education
  • Salary to negotiate
  • Peterborough


Business Intelligence Developer / BI Developer - TSQL SQL SSIS SSRS, Salary: Up to c£50k + Excellent benefits package, Based: Peterborough

We have an exciting opportunity for a Business Intelligence Developer / BI Developer to work for a market leading hire business who are part of a global group.

The role sits within the BI/Reporting/Development function, and is responsible for developing, enhancing and maintaining the company's Management Information capability through a combination of projects and "business as usual" requests.

Main tasks;

Analysing requirements, gathering and translation into technical solutions
Data access, report and analysis design, development, testing and support
Development and maintenance of technical and data security documentation
Troubleshooting of data, report or analytic solutions of user or business issues
Provide direct user support in using self-service, reporting or analytics solutions
Understand operational and sales data and surface relevant KPIs to the business.
Adhere to industry best practice and understand any impact of system changes.
Adhoc Requests; Respond to day to day requests from users to generate reports in the required format based on user's requirements.

Infrastructure; Assist in, or own any task to develop new test environments or procedures to add to the overall robustness of projects development, test and deployment.

Reworks; Audit legacy processes and migrate to new platforms where appropriate by first assessing whether the reports are still useful or candidates for decommission.

Automation; Automate current manual reports creation and subscription by identifying the data required and creating any new objects or processes required.

Build new solutions; Analyse, design and develop new automated data extract, transformation and cleansing routines. Build data presentation layers on top of new data structures that efficiently expose key data to relevant stakeholders.

Required Skills;

High level of competence in TSQL and SQL Server 2012 essential. (SQL Server 2016 preferred).
Experience of building ETL processes using SSIS packages.
Strong Microsoft Excel and Pivot table skills
SQL Server Reporting Services SSRS for creating, deploying and maintaining reports.
A good understanding of data warehousing design concepts and Kimball methodology.
Visual Studio and Team Framework Server experience a must.
Desirable Skills;

Power BI + DAX, Salesforce, SharePoint Integration, Navision

If this sounds like the opportunity that you have been looking for then please apply, attaching your CV.

Smartsearch take your privacy seriously and will only use your personal information to administer your application. To effectively process your application, we may share your details with the company for whom we are collecting job applications and Smartsearch or the company may contact you by email, telephone or SMS. A copy of our privacy policy will be emailed to you upon receipt of your application.

Key words: Business Intelligence Developer / BI Developer, SSIS, SSRS, T-SQL

  • access
  • excel
  • navision
  • sql
  • sql server