Power BI and SQL Server Architect

Cloud Hybrid Technologies, LLC; Dallas (TX); On-site; USD 90,000 - 140,000; Full time

Job summary

Cloud Hybrid is seeking a senior Power BI specialist to lead enterprise BI designs, develop embedded analytics, and optimize SQL Server data delivery. The role focuses on tabular modeling, DAX calculations, and paginated reports within an Azure-based data platform.

You will collaborate with clients to design scalable BI solutions, ensure performance, security, and reliability across Power BI services, SSRS, and data warehouses.

Qualifications

• Extensive experience with Power BI development and embedded analytics.
• Strong skills in DAX, Power Query M, and paginated reports.
• Experience with Tabular Data Modeling and data warehouse integration.
• SQL Server expertise (2014+), including performance tuning and HA/DR.
• Azure cloud experience (Azure SQL DB, Synapse, Data Factory) preferred.
• Familiar with Always On/FCI for high availability.

Skills

Power BI

Power BI Embedded

SSRS

Tabular Data Modeling

DAX

Data Warehouse

SQL Performance Tuning

Always On / HA

Azure (Data Factory, SQL DB, Synapse)

Power BI REST API

Row-Level Security

PowerShell

Power Query M

Paginated Reports

Job description

• 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.
• Troubleshoot slow running Power BI and paginated reports.
• DAX, Power Query M Language, development and optimization
• Paginated Report Development (SQL Server Reporting Services)
• 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.

Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract