Address
Form of workJob Description :Role & Responsibilities :- Create Integration Services (SSIS) packages and Analysis Cubes (SSAS) and Reporting Services (SSRS)- The ability to do ad-hoc SQL to research data questions, identify root causes, and interact closely with peers and the business data analysts is essential. - Develop and support end to end Data Warehouse and Business Intelligence solutions for analytics and management teams - Create complex queries, data transformation, aggregation, stored procedures, and triggers Consult with business partners such as marketing analysts, management, and other developers to clarify program objectives, determine scope, identify problems and recommend solutions - Performance tune ETL, stored procedures, and reports to keep databases and applications optimized; identify root causes in case of ETL failures - Perform code reviews, data validation, and system testing for data warehouse changes - Interact closely with members of both IT and the business Ideal Candidate :- Expert knowledge of Transact-SQL - Experience of the following technologies is required SQL Server 2008/12, Azure SQL, SQL Server Integration Services, SQL Server Analysis Services Experience of BI tools like Power BI, Tableau or any other tool - Knowledge of Azure Data Factory, Azure Synapse Services would be added advantage Experience modelling and designing Relational Databases, Star Schemas, and cubes - Ability to innovate, multi-task and set priorities effectively - Experience in logical and physical data modelling - Ability to quickly understand both business and technical concepts Self-starter with strong verbal and written communication skills - Experience with using MDX to query Analysis Services cubes (ref:hirist.tech)
