Microsoft SQL Server Analysis Services (SSAS and SSIS)

Experience required: 2yr to 6yr
Location: Chennai
Mode of work: Hybrid (3 days at office every week)
Shift: UK Shift and UK Holidays

Mandatory: MSS SQL, SSIS, and SSAS

2+ Years with Retail Knowledge and Application, should be experienced in SSAS and Cube Reports and Quickly understand Business process and enable to onboard Application Support ASAP

1. Work with an experienced product and architecture team to build IT solutions that support merchandising processes.
2. Be an expert on certain functions, processes, or tools.
3. Use SSAS and SSIS for reporting and able to write complex Queries in SQL
4. Strong SQL skills, experience with data warehousing concepts, proficiency in the respective toolset (SSAS for data modeling and analysis, SSIS for data extraction, transformation, and loading), and understanding of data integration best practices.
5. Experience with data visualization tools like Power BI or Tableau (preferred)
6. Performance optimization techniques for SSAS cubes
7. Knowledge of ETL processes (especially if working closely with SSIS)