Business Intelligence Developer

Position Business Intelligence Developer

Location Peterborough

Salary Up to £40,000 plus benefits

Manpower have teamed up with a leading global business services provider focused on modular space, secure portable storage solutions, and remote workforce accommodation management. And we are looking to recruit a BID specialist to join their team at their Head offices based in Peterborough.

Our clients IT has three main functions of Service Desk, Applications Support and BI/ Reporting/Development.

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.

The primary responsibilities of the role include:

• 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.
• Power BI + DAX
• 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

• Salesforce
• SharePoint Integration
• Navision

SOFT SKILLS

• Excellent organizational, presentation, analytical, written and verbal communication skills.
• Ability to analyse business requirements and model effective, best practice solutions.
• A willingness to collaborate and engage with the team and with stakeholders, embrace agile principles and be ready to innovate whenever possible.
• Ability to work independently and manage time effectively without close supervision
• Maintain complete knowledge of and comply with all company policies and procedures
• Adapts positively to changes in direction, priorities, schedules, approaches, and responsibilities
• Strong business acumen. Uses and balances information about business drivers and trends such as revenue, costs, customer needs, and short- and long-term needs to guide planning and activities