Business Intelligence Developer

The Vacancy

The Solutions Integration & Development team are responsible for the design, implementation, enhancement, testing and on-going management of a variety of off-the-shelf and in-house software systems, applications and reporting solutions including ERP, web, mobile and document automation. The Business Intelligence developer will join a small team of developers and play a key role in the adoption, migration to and enhancement of Microsoft Dynamics 365 ERP and Power BI, SharePoint, Office 365 and Azure together with.

The key responsibilities for the role:

• Work with stakeholders to provide business intelligence reports to support business information, planning and decision making needs across multiple business areas including finance, business development and fee earning.
• Analyse, design and develop Microsoft Business Intelligence (BI) solutions including Power BI and Excel delivered across desktop, web and mobile platforms.
• Present information in an engaging and interactive way using modern visualisation and mapping capabilities.
• Support the analysis, interpretation and forecasting of business information with the use of appropriate statistical tests and procedures.
• Ability to model Data Warehouse entities using Dimensional Modelling to support user requirements.
• Full life cycle experience working on medium to complex data warehousing projects, ideally in ERP solutions.
• Good working experience with SQL Server databases including administration and managing security.
• Produce Low/High Level Design, Data Mapping and Data Dictionary documents.
• Maintain Business Intelligence, reporting and database solutions by proactively identifying and correcting software defects.
• Track enhancements, issues and defects using VSTS and other tools.
• Work to agreed principles, coding & security standards & recommend improvements if needed.
• Participate in technical design, change & approval forums where required.
• Liaise with clients and stakeholders to clarify and refine requirements.
• Create and maintain product and technical documentation and records.
• Work with offshore and ERP development partners for the delivery of externally sourced projects and services.
• Work closely with test team to increase the quality of solutions delivered to our customers and clients.
• Carry out effective unit, integration and system testing.
• Provide high quality client focused support and undertake a variety of administration tasks across applications and databases.
• Contribute strongly as part of a cross functional delivery team

Experience, Skills & Qualifications required:

• Degree in either Computer Science, Economics, Mathematics or Business Studies
• Microsoft certifications highly advantageous
• Designing or developing advanced Business Intelligence solutions using the full Microsoft BI Stack. Familiar with Software Development Life Cycle and testing processes.
• Evidence of a structured approach to software development and testing including knowledge and experience of agile methodologies.
• Solid experience working with unit testing frameworks, and experience of integration testing and continuous delivery.
• Experience of handling multiple simultaneous releases for multiple products with a track record of on time delivery.
• Experience working in complex data models, ideally in ERP solutions.
• Excellent technical knowledge and skills in modelling and transforming data, build or design ETL solutions and present data in a useful business context.
• Excellent knowledge of the Microsoft BI Stack (SSIS, SSAS, SSRS).
• Experience in data analytics and presentation using data visualisation tools such as MS Power BI.
• Strong MS Excel skills including data presentation using pivot tables/graphing.
• Write complex T-SQL, MDX and DAX queries and calculations.
• Familiarity with SQL Server with skills in SQL queries, stored procedures, triggers and security.
• Some knowledge of statistical test and procedures
• Good organisational and time management skills with the ability to prioritise tasks appropriately.
• Exceptional attention to detail and quality.
• Pragmatic and good at quickly turning ideas into action.
• Self motivated, flexible with a “can-do” attitude and the ability to prioritise, multitask and meet deadlines.
• Excellent problem solving and trouble shooting skills.
• Proactive and forward thinking able to identify innovative solutions and approaches to new challenges.