Job ID:
3049
Job Title:
Power BI and SQL Server Architect
Location:
Dallas, TX
Duration:
6 Months + Extension
Hourly Rate:
Depending on Experience (DOE)
Work Authorization:
US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, L2-EAD, GC-EAD
Client:
To Be Discussed Later
Employment Type:
W-2, 1099, C2C
Role: Power BI and SQL Server Architect
Bill Rate: $80/hour C2C
Location: Dallas, TX
Duration: 12+ months/ long-term
Interview Criteria: Telephonic + Teams
Direct Client Requirement
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:
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.
NOTE: Thank you for visiting our jobs page. Please submit your application using the Apply Now link. Our recruitment team is currently reviewing all applications thoroughly. We will be in touch with candidates who are shortlisted for the next stage of the interview process.
Valiant Technologies LLC
166 Geary St
San Francisco, CA 94108
We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate based on race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.