SQL Software Developer / Business Analyst

Job Title: SQL Software Developer / Business Analyst
Contract Type: Permanent
Location: Shepton Mallet, England
Salary: Good
Start Date: 2018-12-03
Reference: BH-91138-4
Contact Name: Amanda Bury
Contact Email:
Job Published: November 14, 2018 09:34

Job Description

Business Solutions Developer - Permanent – Shepton Mallet
Business Solutions Developer Role Summary:
My client is a leading provider of expert services in the O&M marketplace with a reputation they are proud of.  Their business is run in a responsible, transparent and ethical way where safety dominates everything we do – our mantra is ‘home safe – every day’. Through analysis of existing business processes and systems, contract obligations and existing operational data streams, the Business Solutions Developer will analyse, develop systems and techniques that improves the resolution, range and accessibility of Management Information across the O&M department. In addition, this role identifies opportunities, proposes and implement techniques for streamlining and automating data capture, analysis and reporting of key metrics. The successful benefits of delivery in this role are expected to have wide ranging beneficial impacts on the O&M business.
Business Solutions Developer Duties of the Role
  • Continue the creation of the suite of apps created using the Microsoft Dynamics 365 Power Apps and Flow environment
  • Lead on requirements capture with stakeholders, prioritising features in line with business objectives and priorities and programme targets
  • Design and support the Azure SQL Server database, ensuring performance and Kimball methodology is adhered to
  • Using Power Bi, produce insightful management dashboards based on data collected through Apps and stored in the SQL Database
  • Produce and update all system user guides
  • Design and execute system and user acceptance testing procedures to ensure levels of defects are minimised
  • Work with the Integrated Management System team to ensure that the IMS systems are updated and kept aligned with changes in O&M business processes and systems
  • Develop and deliver training sessions that promote the smooth roll out and user adoption of systems with end users
  • Provide technical support to end users, and trouble shoot defects and faults promptly
  • Work alongside the IT team in the migration of the documents from in house file server to SharePoint, providing training to end users
  • Support the integration of O&M business processes, systems and tools into the proposed ERP
Business Solutions Developer Key skills:
5 Years’ experience of SQL Server (Ideally Certified)
  • SQL Querying
  • Both DML (Data manipulation language) and DDL (data definition language)
  • Views, CTE (Common Table Expression), Kimball methodology
  • Power Apps
  • User requirements gathering
  • Design, build and UAT (user Acceptance testing)
  • Microsoft Flow
  • Automation of system processes
  • Power Bi
  • User requirements gathering
  • Dashboard reporting
  • Modelling
  • R Script (advantageous)
  • Power Apps integration
Web development (Advantageous)
  • Object-oriented programming
  • C#
  • HTML
  • CSS
  • Bootstrap
  • ASP
  • JavaScript
  • Python
  • Application development
  • Data Analysis
  • System Requirements Gathering
  • Coaching
  • IT Support
  • Document Control
  • Facilities Management
Applicants must be eligible to work in the UK.