Microsoft SQL Server Analysis Services (SSAS) Technical Lead, Sopra Steria

Sopra Steria

Location:
India, Noida

Category:
IT - Software Development

Contract Type:
Employment contract

Salary:

Not provided

Save Job

Apply Position

Job Description:

Sopra Steria is a major player in Europe with 50,000 employees across nearly 30 countries, recognized for consulting, digital services, and solutions. The company seeks a Technical Lead skilled in SSAS, DAX, SQL, and Power BI to join their Noida, India team in a hybrid setting.

Job Responsibility:

Translate business requirements into scalable and optimized data models and reports
Optimize DAX queries for performance and memory usage in large data models
Create and manage semantic data models using best practices in dimensional modeling
Collaborate with data engineers, analysts, and architects to ensure high data quality and governance

Requirements:

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

Nice to have:

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

What we offer:

Inclusive and respectful work environment
Open to people with disabilities

Additional Information:

Job Posted:
June 09, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

Microsoft SQL Server Analysis Services (SSAS) Technical Lead