Microsoft SQL Server Analysis Services (SSAS) Technical Lead

About Sopra Steria
Sopra Steria, a major Tech player in Europe with 50,000 employees in nearly 30 countries, is recognised for its consulting, digital services and solutions. 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 organisations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a 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.

Total experience: 6 years to 8 years
Location: Noida
Mode of work: Hybrid (3 days office every week)

1. Strong proficiency in DAX: complex measures, time intelligence, context transition, and row context handling.
2. Solid experience with SSAS Tabular Models, Power BI Data Modeling,
3. Translate business requirements into scalable and optimized data models and reports.
4. Optimize DAX queries for performance and memory usage in large data models.
5. Create and manage semantic data models using best practices in dimensional modeling
6. Collaborate with data engineers, analysts, and architects to ensure high data quality and governance.
7. Proficiency in SQL/SQL server for data validation and backend query support.
8. Experience working with large datasets and optimizing performance in enterprise environments.
9. Data Modeling: Proficiency in designing data models that underpin reports and dashboards.
10. DAX (Data Analysis Expressions): Mastery of DAX, a formula language used in Power BI for calculations and data manipulation.
11. Data Transformation: Skills in transforming raw data into a format suitable for analysis
12. Must have Data Analytics Skill
13. Need to understand various statistical functions that will be used for calculation logic in preparing matrices

Soft Skills:

1. Strong analytical and problem-solving abilities.
2. Excellent communication and stakeholder management skills.
3. Ability to work independently as well as lead/mentor a team.
4. Detail-oriented and quality-focused mindset

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.