Microsoft SQL Server Analysis Services (SSAS) Technical Lead

About Sopra Steria

Sopra Steria, a major Tech player in Europe with 51000 employees in nearly 30 countries, is recognized for its consulting, digital services and software development. It helps its clients drive their digital transformation and obtain tangible and sustainable benefits. The Group provides end-to-end solutions to make large companies and organizations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a fully collaborative approach. Sopra Steria places people at the heart of everything it does and is committed to putting digital to work for its clients in order to build a positive future for all. In 2024, the Group generated revenues of €5.8 billion.

The world is how we shape it.

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

6+ 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. Well versed with Dataware housing knowledge and expert in SQL DB technologies
2. Should be able to drive the team, manage team, deal with clients, involve in meetings and provide technical decisions.
3. Work with an experienced product and architecture team to build IT solutions that support merchandising processes.
4. Be an expert on certain functions, processes, or tools.
5. Use SSAS and SSIS for reporting and able to write complex Queries in SQL
6. 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.
7. Experience with data visualization tools like Power BI or Tableau (preferred)
8. Performance optimization techniques for SSAS cubes
9. Knowledge of ETL processes (especially if working closely with SSIS/SSAS) 

B.E / B.Tech / M.E / M.Tech / MCA

At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.

All of our positions are open to people with disabilities.