Esh Solutions Limited
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)
· 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