Business Intelligence Specialist
Business Intelligence Specialist
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
5-7years
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
- Design build and optimize SSAS Tabular and Multidimensional cubes to meet reporting and analytical needs.
- Implement advanced DAX and MDX logic for KPIs measures calculated fields and aggregations.
- Deploy and manage cubes in Azure Analysis Services or Power BI Service.
- Design and develop ETL packages using SSIS to extract transform and load data from various sources.
- Build and maintain data marts in SQL Server to support cube processing and reporting layers.
- Develop and maintain Power BI reports PowerPivot dashboards and Excel-based analytical solutions.
- Publish reports to SharePoint and/or Power BI Service.
- Design performance management dashboards procurement & stock reports and executive dashboards.
- Design and optimize relational and dimensional data models.
- Write complex SQL queries stored procedures and scripts to support data preparation and validation.
- Perform data reconciliation and quality checks across systems.
- Tune SSAS cubes and SQL queries for performance and scalability.
- Implement cube partitioning aggregations and process automation.
Requirements
- 5 years of experience in Microsoft BI stack: SSIS SSAS (Tabular & Multidimensional) SQL Server.
- Strong expertise in cube design and deployment in both on-prem and Azure environments.
- Hands-on experience with Power BI PowerPivot and Excel-based reporting.
- Deep understanding of dimensional modelling (star/snowflake schemas).
- Proficiency in SQL T-SQL DAX and MDX.
- Experience with SharePoint integration for report delivery.
- Strong analytical and problem-solving skills.
Develop and maintain Power BI reports, PowerPivot dashboards, and Excel-based analytical solutions. Publish reports to SharePoint and/or Power BI Service. Design performance management dashboards, procurement & stock reports, and executive dashboards.
Education
5+ years of experience in Microsoft BI stack: SSIS, SSAS (Tabular & Multidimensional), SQL Server. Strong expertise in cube design and deployment in both on-prem and Azure environments. Hands-on experience with Power BI, PowerPivot, and Excel-based reporting. Deep understanding of dimensional modelling (star/snowflake schemas). Proficiency in SQL, T-SQL, DAX, and MDX. Experience with SharePoint integration for report delivery. Strong analytical and problem-solving skills.
Employment Type
Full Time
