You will develop, upgrade, and maintain data marts and SSAS cubes within a Microsoft SQL Server 2017 or higher environment.
Responsibilities
- Develop and maintain data marts and SSAS cubes.
- Manage cube deployment and processing options.
- Implement role-based and row-level security within SSAS models.
- Automate SSAS cube refreshes using scheduling tools.
- Maintain high-volume data warehouse structures.
Required Skills
- 5+ years of experience as a Database Developer.
- Strong proficiency with Microsoft SQL Server.
- Deep understanding of relational databases and high-volume data warehousing.
- Expertise in Facts, Dimensions, MDX, and DAX queries.
- Hands-on experience with SSAS cube development.
- Ability to manage security protocols in SSAS models.
- Degree in any field of study.
Preferred Skills
- Experience with SSAS administration.