Clicky

Locale : Global (English)
X
Create document Page
added
Remove
page
Add
page
Review document
/
Page Added
Collected
Pages
Create

BI dashboard developer

Job Profile

Seeking talented BI dashboard 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 Oracle Packages and incorporating this data into a data model which you will then use 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 data querying using SQL on different platforms, such as using SQL within Power BI, in SSIS or SSMS. Experience in building views and stored procedures in Oracle using PL-SQL is essential. 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 SMEs in finance, HR and projects to understand their needs with regards to BI dashboard solutions and to produce PowerBI dashboards according to their requirements.
This will involve:
  • Turning abstract concepts into analytics to depict data or support business needs
  • Data querying using SQL on different platforms, such as using SQL within Power BI, in SSIS, SSMS or Oracle
  • 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.

Essential:
  • T-SQL expertise in creating stored procedures using dynamic SQL to perform ETL
  • Working with complex data sets, experience in a multi-sector environment would be beneficial
  • Proven design, delivery and deployment experience of Business Intelligence projects
  • Data Mining: Exceptional SQL and data analysis skills, with the ability to transform and prepare data to feed models without further necessary ETL processes
  • Experience with ETL and data integration tools such as SQL Server Integration Services or ETL using Power BI
  • Experience implementing and supporting Self-service BI tools such as Microsoft PowerBI and Excel (PowerPivot, PowerQuery)
  • Data modelling (SSAS, Excel/PowerQuery or Power BI) experience is essential
  • A high level of proficiency in Data Analysis Expressions (DAX) with demonstrable capabilities in this area

Good to have
  • Some knowledge and experience in data lakes, factories or warehouses on Azure
  • Knowledge of automation scripts such as PowerShell would be highly advantageous
  • Azure and Json experience very valuable
icon-arrow-down-smlicon-arrow-left-lrgicon-arrow-left-smlicon-arrow-right-lrgicon-arrow-right-smlicon-arrow-up-smlicon-championsicon-closeicon-downloadicon-educationicon-emailicon-grid-viewicon-languageicon-link-toicon-list-viewicon-locationicon-login-registericon-minusicon-moreicon-phoneicon-plusicon-recently-viewedicon-searchicon hashkey-facts-corner-sashquote-underlinesocial-icon-facebooksocial-icon-googleplussocial-icon-linkedinsocial-icon-twittersocial-share-icon-facebooksocial-share-icon-facebooksocial-share-icon-googleplussocial-share-icon-googleplussocial-share-icon-instagramsocial-share-icon-instagramsocial-share-icon-linkedinsocial-share-icon-linkedinsocial-share-icon-twittersocial-share-icon-twittersocial-share-icon-youtubesocial-share-icon-youtubesina-weiboMM-Shape01-Quote-ViewsMM-Shape03-Quote-LocationsMM-Shape05-Quote-ProjectsMM-Shape12-Quote-SectorsMM-Shape13-Quote-ExpertiseMM-Shape14-Quote-About-UsMM-Shape14-Quote-Careerscheckmarkicon-expand-viewicon-apply-nowmenusphereicon-cookiesicon-legalicon-registered-companiestargetrotate-screenvideo-replay-flatvideo-replayaudio-muteaudio-play