Canvas is not supported by your browser.

Senior IT Consultant

Contract Type:


Role Type:


Permission Type:


Company Name:

Esh Solutions Limited



Closing Date:

Friday 21st August 2020

2 IT Consultant having 6-8 years of experience in the field of SQL Server, Business intelligence & Reporting (SSRS,SSAS,SSIS, Alteryx CUBES)

Job Description:

·         Experience in ETL Tools like SSIS, Alteryx to perform Data Processing tasks -Analysis, Data Cleansing,

Data Transformations, Data Relationships


·         Expertise in T- SQL writing stored procedures, triggers and functions.


·         Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering. Implemented the new SQL Server 2012 mechanisms

·         Translate business needs to technical specifications

·         Design, build and deploy BI solutions (e.g. reporting tools)

·         Maintain and support data analytics platforms

·         Create tools to store data (e.g. OLAP cubes) 

·         Conduct unit testing and troubleshooting

·         Evaluate and improve existing BI systems

·         Collaborate with teams to integrate systems

·         Develop and execute database queries and conduct analyses

·         Create visualizations and reports for requested projects

·         Develop and update technical documentation 




·         Knowledge of SQL Server. T-SQL essential.


·         Full BI Stack (SSRS, SSAS, SSIS).


·         Proven experience with enterprise BI tools (Qlik, SAP, Microstrategy, Tableau, Other). QlikView and QlikSense are preferred (scripting, UI design and data visualisation).


·         Good understanding of BI development life cycle.


·         Experience and knowledge of dimensional data modelling.


·         Design and development of physical & logical data models (data warehousing knowledge).


·         Experience of designing data structures (dimensional / star schemas) and optimising performance


·         Experience working with complex data structures


·         Effective communicator with good organisational skills


·         Experience of presenting technical information to non-technical stakeholders



Salary: Negotiable