Senior Consultant - SQL Server Analysis & Power BI

confidential; Kuwait; On-site; KWD 30,000 - 60,000; Full time

Job summary

An established industry player is seeking a skilled SQL Server and Power BI Engineer to design and maintain advanced business intelligence solutions. This role involves optimizing SQL Server databases, developing multidimensional models, and creating interactive reports. The ideal candidate will possess extensive experience in SQL Server, Analysis Services, and Power BI, along with a strong foundation in data modeling and ETL processes. Join a dynamic team where your expertise will drive impactful business decisions and enhance operational efficiency. If you are passionate about data and analytics, this opportunity is perfect for you.

Qualifications

• 8-12 years of experience in SQL Server, Analysis Services, and Power BI.
• Strong skills in data modelling, ETL processes, and report development.

Responsibilities

• Administer and optimize SQL Server databases ensuring high availability.
• Design and develop multidimensional models using SQL Server Analysis Services.
• Create interactive reports and dashboards using Power BI.

Skills

SQL Server

Power BI

Analysis Services

T-SQL

PowerShell

Data Analysis Expressions (DAX)

Multidimensional Expressions (MDX)

Data modelling

ETL processes

Education

Bachelor’s in Information Technology

Tools

Power BI

SQL Server

Azure

SharePoint

Job description

The role of an SQL Server core and Analysis Services and Power BI Engineer level 400 involves advanced technical responsibilities in designing, developing, and maintaining business intelligence solutions.

Key responsibilities

1. SQL Server: Database Management:
   Administering and optimizing SQL Server databases, ensuring high availability, disaster recovery, and data integrity. This includes configuring and managing SQL Server instances, performing backups, and implementing security measures.
2. Performance Tuning:
   Conducting in-depth performance analysis and optimization, including query tuning, indexing strategies, and resource management to ensure efficient database operations.
3. Troubleshooting:
   Diagnosing and resolving complex database issues, including deadlocks, performance bottlenecks, and connectivity problems.
4. Analysis Services: Cube Development:
   Designing and developing multidimensional and tabular models using SQL Server Analysis Services (SSAS). This involves creating and managing dimensions, hierarchies, measures, and calculated members.
5. Performance Optimization:
   Implementing best practices for cube design and optimization, including partitioning, aggregations, and indexing to enhance query performance and scalability.
6. Advanced Analytics:
   Utilizing Data Analysis Expressions (DAX) and Multidimensional Expressions (MDX) to create complex calculations and business logic within cubes.
7. Power BI: Report Development:
   Creating interactive and visually appealing reports and dashboards using Power BI. This includes connecting to various data sources, transforming data using Power Query, and building data models.
8. Advanced Features:
   Leveraging advanced Power BI features such as row-level security, custom visuals, and Power BI Service for sharing and collaboration.
9. Integration:
   Integrating Power BI with other Microsoft tools and services, such as Azure, SQL Server, and SharePoint, to provide comprehensive business intelligence solutions.

Ideal Candidate Qualifications

• Extensive experience with SQL Server, Analysis Services, and Power BI, along with strong skills in data modelling, ETL processes, and report development.
• Proficient in scripting languages such as T-SQL and PowerShell, and have a deep understanding of data warehousing concepts and methodologies.

Skills

• Requirement open for Egyptians based in Egypt.
• Minimum 8-12 years’ experience in the relevant field.
• Required Bachelor’s in Information Technology or relevant field.
• Software knowledge of Power BI, Azure, SQL Server, SharePoint, etc.