Design and develop OLAP cubes and Tabular Models in SSAS for multidimensional data analysis.
Optimize cube performance and manage dimensions, hierarchies, measures, and KPIs.
Develop and maintain calculated members, MDX queries, and DAX expressions.
Implement security roles and permissions in SSAS.

SSRS Development

Design and develop interactive and visually appealing reports using SSRS.
Write complex SQL queries and stored procedures to retrieve and manipulate data.
Create dashboards and parameterized reports based on user requirements.
Ensure performance optimization and report scalability.

General Responsibilities

Collaborate with stakeholders to gather business requirements and translate them into technical specifications.
Integrate BI solutions with other systems and data sources.
Monitor and troubleshoot issues related to SSAS and SSRS components.
Provide documentation and training for end-users and support teams.
Stay updated with the latest trends and best practices in business intelligence and data analytics.

Requirements

Strong experience with Microsoft BI tools, including SSAS, SSRS, and SQL Server.
Proficiency in T-SQL, MDX, and DAX for querying and analysis.
Experience in designing and optimizing OLAP cubes and Tabular Models.
Expertise in developing complex SSRS reports and dashboards.
Solid understanding of data warehousing concepts and ETL processes.
Excellent analytical, problem-solving, and communication skills.

Preferred Qualifications

Familiarity with Power BI and its integration with SSAS and SSRS.
Experience with Azure Analysis Services or cloud-based BI tools.
Knowledge of Python or R for advanced analytics.
Microsoft certifications, such as MCSE: Data Management and Analytics

More Jobs at Info Global Tech

SSAS and SSRS Developer

bengaluru

1.0 - 4.0 yrs

INR 3 - 7 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Business Intelligence Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.