Power BI and SQL Server Architect

  • Posted 7 days ago | Updated 1 day ago

Overview

Remote
$100,000 - $120,000
Full Time

Skills

Power BI
SQL

Job Details

Cloud Solution Architect for Power BI, SQL Server

We are seeking a skilled and experienced Data Platform architect with expertise in Power BI, Tabular Data Modeling, Data Warehousing, SQL Reporting Services, and SQL Server engine. Ideal candidate will be responsible for designing and implementing effective Power BI solutions, with a focus on Power BI Embedded, tabular data modeling, report development, data warehouse integration, analytics and DAX expertise. For SQL Server, there should be a strong focus on Performance, High Availability, and Failover Clustering.

Ideal candidate will play a key role in design, development and optimization of Power BI and SQL Server implementations along with assisting in migration and modernization of solutions to Azure.

Skills/ Job expertise needed:

  • Enterprise level support and administration focused specifically on:
    • Power BI, Power BI Embedded, SQL Server Reporting Services, Tabular Data Modeling, SQL performance and tuning optimization, Clustering, Always On Availability groups, High Availability.
  • Extensive experience with Power BI development including Power BI embedded skills and Tabular Data Modeling
  • Power BI solution design, PBI embedded development skills and Performance optimization skills are required.
  • Proficiency in DAX for developing complex calculations and measures.
  • Strong understanding of Data Warehouse concepts and experience with integration of data warehouse.
  • Previous Consulting and/or customer facing roleSolving performance problems, query tuning, and optimization
  • SQL Server on IaaS experience on Azure/ Other public cloud required.
  • All versions of SQL Server (2014 and onwards)
  • Architectural experience for Data Platform
  • Architecting for High Availability and Disaster recovery solutions using FCI, Always on Availability groups
  • Delivering and/or authoring technical training
  • Advanced Microsoft certifications preferred.
  • Azure data factory, Azure SQLDB, Azure SQLDB Managed Instance, Azure Synapse knowledge is a plus.

Technical Skills:

Mandatory

  • Power BI Solution design and Power BI Embedded development.
  • Tabular Data modeling and database design.
  • Optimize Tabular Data Models
  • Troubleshoot slow running Power BI and paginated reports.
  • DAX, Power Query M Language, development and optimization
  • Paginated Report Development (SQL Server Reporting Services)
  • Power BI Service, Power BI Desktop skills
  • Data connectivity best practices to SQL, Analysis Service, Oracle, MySQL, Azure, AWS and other services.
  • Familiar with Power BI REST API to programmatically interact with Power BI Service.
  • Power BI Row Level security along with other Security features.
  • Develop PowerShell scripts to automate administrative tasks.
  • Build data pipelines using Power Query to transform data.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.