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
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.
- Performance Tuning: Conducting in-depth performance analysis and optimization, including query tuning, indexing strategies, and resource management to ensure efficient database operations.
- Troubleshooting: Diagnosing and resolving complex database issues, including deadlocks, performance bottlenecks, and connectivity problems.
- 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.
- Performance Optimization: Implementing best practices for cube design and optimization, including partitioning, aggregations, and indexing to enhance query performance and scalability.
- Advanced Analytics: Utilizing Data Analysis Expressions (DAX) and Multidimensional Expressions (MDX) to create complex calculations and business logic within cubes.
- 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.
- Advanced Features: Leveraging advanced Power BI features such as row-level security, custom visuals, and Power BI Service for sharing and collaboration.
- Integration: Integrating Power BI with other Microsoft tools and services, such as Azure, SQL Server, and SharePoint, to provide comprehensive business intelligence solutions.
- The ideal candidate should have extensive experience with SQL Server, Analysis Services, and Power BI, along with strong skills in data modelling, ETL processes, and report development.
- They should also be proficient in scripting languages such as T-SQL and PowerShell, and have a deep understanding of data warehousing concepts and methodologies.
Job Details
| Posted Date: | 2025-03-19 |
| Job Location: | Kuwait – Al Kuwait |
| Job Role: | Hospitality and Tourism |
| Company Industry: | IT Services |
Preferred Candidate
| Nationality: | Egypt |
JobDXB.com, in partnership with the 7 states of the UAE (Abu Dhabi, Dubai, Sharjah, Ajman, Umm Al Quwain, Ras Al Khaimah, and Fujairah), is a leading job portal based in the country, connecting job seekers with opportunities across various industries in the region.
While we strive to provide a platform for employers and candidates to connect, it's essential to note that the content of job postings may vary, and we do not take responsibility for their accuracy or legitimacy. We advise applicants to exercise caution and diligence when applying for positions, ensuring thorough research and verification before proceeding with any application. Your career journey is important to us, and we encourage you to navigate it with care and discernment.