SSAS Data Engineer

Tekskills; Gurugram District; On-site; INR 2,800,000 - 4,200,000; Full time

Job summary

Tekskills in Gurugram, India seeks a senior SSAS BI Developer to develop, deploy, and optimize OLAP cubes and tabular models. You will work with data teams to design robust data solutions, troubleshoot SSAS issues, and ensure secure, efficient querying and data backups.

The ideal candidate has 7+ years of SSAS experience, strong SQL/MDX/DAX skills, data warehousing, ETL, data modelling, and Power BI proficiency, with a collaborative, Agile mindset.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 7+ years of experience working with SSAS (SQL Server Analysis Services).
• Strong understanding of data warehousing, ETL processes, OLAP concepts and data modelling concepts
• Proficiency in SQL, MDX, and DAX query languages.
• Experience with data visualization tools like Power BI.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration abilities.
• Experience on Agile way of working

Responsibilities

• Develop, deploy, and manage OLAP cubes and tabular models.
• Collaborate with data teams to design and implement effective data solutions.
• Troubleshoot and resolve issues related to SSAS and data models.
• Monitor system performance and optimize queries for efficiency.
• Implement data security measures and backup procedures.
• Stay updated with the latest SSAS and BI technologies and best practices.

Skills

SSAS (SQL Server Analysis Services)

SQL

MDX/DAX

Data Warehousing

ETL Processes

Power BI

Data Modelling

Data Security

Agile

Communication

Education

Bachelor's degree in Computer Science / Information Technology or related field

Tools

Power BI

Job description

Responsibilities

• Develop, deploy, and manage OLAP cubes and tabular models.
• Collaborate with data teams to design and implement effective data solutions.
• Troubleshoot and resolve issues related to SSAS and data models.
• Monitor system performance and optimize queries for efficiency.
• Implement data security measures and backup procedures.
• Stay updated with the latest SSAS and BI technologies and best practices.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 7+ years of experience working with SSAS (SQL Server Analysis Services).
• Strong understanding of data warehousing, ETL processes, OLAP concepts and data modelling concepts
• Proficiency in SQL, MDX, and DAX query languages.
• Experience with data visualization tools like Power BI.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration abilities.
• Experience on Agile way of working

Skills

• SSAS (SQL Server Analysis Services)
• SQL
• MDX/DAX
• Data Warehousing
• ETL Processes
• Performance Tuning
• Data Analysis
• Data Security
• Data modelling
• Plus: knowledge on Power BI or a reporting tool
• Plus: working for ING