SSAS; SQL Server Analysis Services Administration Engineer

SSAS (SQL Server Analysis Services) Administration Engineer

3 weeks ago Be among the first 25 applicants

• Administer and maintain SSAS instances, including multidimensional and tabular models
• Optimize SSAS cube performance, including partitioning, aggregations, and processing schedules
• Implement and manage security roles and permissions within SSAS
• Troubleshoot and resolve issues related to SSAS processing, queries, and connectivity
• Work with data architects and analysts to design and deploy SSAS solutions

• Monitor system health, performance, and availability of BI tools and services
• Perform regular backups, updates, and patches for BI tools and related systems
• Document processes, configurations, and best practices for BI administration
• Provide technical support and training to end-users and stakeholders
• Collaborate with cross‑functional teams to ensure alignment between BI tools and business objectives
• Stay informed about industry trends and emerging technologies in BI and data analytics
• Build Analysis Services reporting models
• Migrate Self‑Service Reports from Oracle BI and Tableau to Power BI
• Migrate Reports and Dashboards from Oracle BI to Power BI

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field

• 5+ years of experience in administering and managing Power BI, SSIS, and SSAS
• Strong understanding of data warehousing, ETL processes, and BI concepts
• Experience with SQL Server, including T‑SQL scripting and database administration
• Familiarity with data visualization best practices and tools
• Experience with cloud platforms (e.g., Azure, AWS) is a plus

• Proficiency in Power BI administration, including Power BI Service and Power BI Report Server
• Expertise in SSIS package development, deployment, and troubleshooting
• Strong knowledge of SSAS, including cube design, processing, and optimization
• Experience with data modeling, DAX, and MDX
• Knowledge of data gateways, dataflows, and Power Query
• Familiarity with Power Shell scripting for automation tasks

• Strong problem‑solving and analytical skills
• Excellent communication and collaboration skills
• Ability to work independently and manage multiple priorities
• Attention to detail and a commitment to data accuracy and quality

• Microsoft Certified:
  Power BI Data Analyst Associate
• Microsoft Certified:
  Azure Data Engineer Associate
• Microsoft Certified: SQL Server Database Administration