Locale : Global (English)
Create document Page
Review document
Page Added

BI developer

Job Profile

Seeking talented BI developers

The shared information services department is currently in the middle of an exciting digital programme, which involves moving to a new cloud-based ERP system and the adoption of new reporting techniques including the development of business intelligence dashboards in PowerBI.
The ability to showcase data in a visually stimulating way and to add value to data reporting is the driving force behind this latter initiative.

We are seeking talented people who are well versed in data mining, analytics and modelling with relevant experience.The core part of the work will be in gathering data from SQL Server Data warehouse using Azure Data Factory (ADF) and incorporating this data into an Azure BI Infrastructure – Azure SQL Server DB and Azure Analysis Server to create a data model which will be used to build visualisations in Power BI. You will be working closely with a business analyst to turn what will initially be abstract concepts into well defined requirements and ultimately the end solution which will help to drive forwards our business.

You will be able to show experience in building views and stored procedures in SQL Server using T-SQL. Experience in high level data management and warehousing is beneficial.

You must be an excellent communicator,
with customer engagement experience and you must be confident about your skills.
You must also think creatively and should always be seeking new and more efficient ways to improve systems.
You should be able to manage your own time, work to clearly defined targets and be able to communicate effectively with your manager and the wider team.

The application process
Read the information provided and if it sounds like the right role for you please apply online as soon as possible. Our online application process takes about 10 minutes and you'll need to upload your CV/resume. You have the option to upload a cover letter – to help explain why you're interested in applying for this role.
Applications will be reviewed by the team to shortlist for interviews, which will be held in Croydon.

If you have any questions or need to send us your application in a different format, please contact us at careers@mottmac.com. We are an equal opportunity employer and value diversity at our company. We do not discriminate, and take positive steps to create an inclusive culture.

Job Description

You will work with business analysts and also business users in finance, HR and projects to understand their data needs with regards to BI dashboard solutions, create ETL process and Analysis Server data model according to their requirements.
This will involve:
  • Turning abstract concepts into analytics to depict data or support business needs
  • Data discovery involving discussions with other application teams within MM
  • Designing the data model to ensure it is robust, secure, relevant and succinct
  • Carrying out peer reviews of other developers' work
  • Defining and executing test cases as part of developer QA
  • Providing clear complexity estimates during agile scrum sprint planning meetings
  • Providing daily progress updates during stand-ups

Candidate Specification

Formal Education & Certification

  • University degree or diploma in the field of Computer Science, Information Systems, Software Engineering, or relevant equivalent work experience.

  • Experience implementing ETL and data integration processes using tools such as Azure Data Factory (ADF) or SQL Server Integration Services
  • Data Mining: Exceptional SQL and data discovery and analysis skills with ability to
    • Cleanse, transform and prepare data to feed models
    • Query data using SQL
  • T-SQL expertise in creating stored procedures using dynamic SQL to perform ETL
  • Data modelling using SQL Server Analysis Services (SSAS) or Azure Analysis Services (AAS) experience
  • A high level of proficiency in Data Analysis Expressions (DAX) with demonstrable capabilities in this area.

Good to have
  • Some knowledge and experience in Json, data lakes or warehouses on Azure
  • Knowledge of automation scripts such as PowerShell would be highly advantageous
  • Experience implementing and supporting Self-service BI tools such as Microsoft PowerBI and Excel (PowerPivot, PowerQuery)
icon-arrow-down-sml icon-arrow-left-lrg icon-arrow-left-sml icon-arrow-right-lrg icon-arrow-right-sml icon-arrow-up-sml icon-champions icon-close icon-download icon-education icon-email icon-grid-view icon-language icon-link-to icon-list-view icon-location icon-login-register icon-minus icon-more icon-phone icon-plus icon-recently-viewed icon-search icon hash key-facts-corner-sash quote-underline social-icon-facebook social-icon-googleplus social-icon-linkedin social-icon-twitter social-share-icon-facebook social-share-icon-facebook social-share-icon-googleplus social-share-icon-googleplus social-share-icon-instagram social-share-icon-instagram social-share-icon-linkedin social-share-icon-linkedin social-share-icon-twitter social-share-icon-twitter social-share-icon-youtube social-share-icon-youtube sina-weibo MM-Shape01-Quote-Views MM-Shape03-Quote-Locations MM-Shape05-Quote-Projects MM-Shape12-Quote-Sectors MM-Shape13-Quote-Expertise MM-Shape14-Quote-About-Us MM-Shape14-Quote-Careers checkmark icon-expand-view icon-apply-now menu sphere icon-cookies icon-legal icon-registered-companies target rotate-screen video-replay-flat video-replay audio-mute audio-play