Senior Consultant - SQL Server Analysis & Power BI

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.