SQL SSAS Developer
VirtusaJobsCloseBy Editorial Insights
Virtusa is hiring a SQL SSAS Developer for a full-time onsite role in Mississauga, Ontario. The ideal candidate has 6+ years of MS SQL Server development, with hands-on experience in SSAS (Multidimensional and Tabular), SSIS, SSRS, and T-SQL. The role emphasizes performance tuning, troubleshooting, data warehousing concepts (3NF, dimensional models, star schemas), and Power BI service usage, plus strong DB design and DW/BI knowledge. Agile/Scrum teamwork is required, with CI/CD pipeline integration and JIRA familiarity. To apply, tailor your resume to show measurable improvements, provide concrete cubes or reports, highlight CI/CD milestones, and demonstrate strong communication. Onsite Mississauga, experienced individual contributor.
Description
Primary Skills
- SQL Server Analysis Services
- MS SQL Server
- Data Analysis
- ANSI SQL Skills
- DW/BI Knowledge OLPT
- DW/BI Knowledge OLAP
- Relational Database Knowledge - Tables, Relations, Types
- Database Model 3NF
- Database Model Dimensional
- Database Model STAR
- Database Model Schema
- Power BI Service
- SSRS
- SSAS
- Data Science Knowledge
Skills from outside primary skill cluster
- JIRA
- Agile/Scrum
- CICD pipeline
Job Description (up to 150 characters)
Candidate must have 6+ Year of Experience in MS-SQL server development.
Detailed Job Description
- Proven experience as SSAS Cube developer with significant hands-on experience in TSQL, SSIS, SSRS.
- Expert in SQL Server Analysis Services Development (Multidimensional and Tabular).
- Must have worked on performance tuning SQL Queries, stored procedures, creation of database objects etc.
- Good in troubleshooting.
- Agile knowledge is a must.
- Good team player.
- CI/CD Integration Experience integrating into CI/CD pipelines.
Communication
- Consistently demonstrate clear, concise, and effective written and verbal communication skills.
Problem-Solving
- Proactive approach to anticipating, understanding, and implementing required actions for project needs, with the ability to organize and track overlapping tasks and frequent priority changes.