Microsoft Business Intelligence Consultant:
The candidate must have an excellent overall knowledge of the Microsoft BI product suite and must have an interest in working in a senior technical role in a customer facing environment
The Senior MS BI Consultant must have experience in the areas of Data Warehouse Design, Modelling, Data Integration, Data Analysis, Reporting and prove consistent business knowledge. In particular SSAS, SSIS and SSRS. The Senior MS BI Consultant will be responsible for the overall design and build of business intelligence solutions for a set of clients, delivered on Azure, Microsoft SQL Server and Business Intelligence platforms. You will work as a team member along with business analysts, project managers, developers, technical architects and testers to deliver the complete solution to the customer. The role requires a willingness to travel to customer sites when necessary.
5+ years working in a consultant role on business systems implementation projects
BSc Computer Science, Information Systems, Engineering or a related field.
Proven leadership experience and capabilities
Microsoft SQL Certifications (MCTS / MCSE / MCSA).
MS SQL Server 2012/2014/2016 (SSIS) (SSAS) (SSRS)
Desire experience in Power BI + DAX language.
Desire experience working as Microsoft Sql Server DBA (cluster installation, replication, backup policies, tuning performance)
Demonstrate expert knowledge in multiple technical and business areas.
Design, plan, develop, test, document and maintain Microsoft BI Solutions, including data warehouse data structures, ETL jobs, cubes and reports.
Experience in Design and Build the Business Components of a Business intelligence data warehouse.
Identifying BI infrastructure environments specifications.
Experience in writing complex SQL queries, MDX/DAX.
Aware of C#.Net and VB.Net Coding and debugging.
Self-learning and knowledge acquisition on the latest BI tools, technologies and best practices.
Coordinate and support Business Analysts in new BI projects business specifications.
Develop Microsoft BI solution proof of concepts (POC’s)
Design and build the Business Components of a Business Intelligence Data Warehouse.
Gather, document, and distribute business and technical requirements.
Design, Plan and Deploy BI solutions.
Participate in and have a focus on building reusable BI components and artifacts.
Debug, monitor, and troubleshoot BI solutions.
Diagnosing and repairing Client and Performance issues and Modify existing solution to fix bugs.
Approximately 2 years of experience.
Purpose of the Role:
To develop analytics datasets
To streamline the code processes in order to increase the efficiency of model and dataset generation
Re-engineering of the Departments existing data processes to ensure that they are consistent with fulfilling the Departments obligations.
Highly numerate with a third level
qualification in one of the following fields: Analytics,
Mathematics/Statistics, Computing, Engineering;
Experience with SQL
(preferably MySQL) and at least one NoSQL database;
dashboard design and business discovery software (Qlikview preferably) and
CRM tools such as Salesforce;
Experience with the R
or Python programming language;
Strong Excel skills
At least one year
experience working with data-warehouses and intelligence delivery;
A strong business-orientation,
ability to communicate effectively with internal customers;
Have a high level of attention to