SQL Developer - MSBI

Role Overview

We are seeking a skilled SQL Developer with MSBI expertise to design, develop, and maintain our data systems.

In this role, you will be responsible for building robust database structures and leveraging the full MSBI stack (SSIS, SSRS, and SSAS) to transform raw data into actionable business insights.

The ideal candidate is a problem-solver who thrives on optimizing complex queries and ensuring data integrity across the enterprise.

Key Responsibilities

• Database Development : Design and develop relational database schemas, stored procedures, views, and functions using T-SQL.
• ETL Engineering (SSIS) : Build and maintain complex ETL packages to extract data from various sources, transform it according to business logic, and load it into data warehouses.
• Reporting & Visualization (SSRS/Power BI) : Create, deploy, and manage paginated reports and interactive dashboards to support departmental decision-making.
• OLAP Cube Development (SSAS) : Design and maintain multi-dimensional (MOLAP) and tabular models to enable high-performance data analysis.
• Performance Tuning : Monitor and optimize database performance through index management, query plan analysis, and partition strategy.
• Data Integrity : Implement rigorous data validation checks and error-handling routines to ensure one source of truth.
  
  

Mandatory Skills

• SQL Developer with Power BI.
  
  

(ref:hirist.tech)

Skills

T-sql, Ssrs, Ssas, Power Bi, Msbi, SSIS, Sql