← Back to jobs

American Technology Group LLC Logo
Power BI and SQL Server Architect
Posted On: 1 day ago
Experience: 5+ years
Availability: Hybrid
Openings: 2
Category: Power BI Architect
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

You will architect and administer enterprise-level solutions focused on Power BI and SQL Server.

This role is on-site.

Responsibilities

  • Design and optimize Power BI solutions, including Tabular Data Modeling and embedded development.
  • Tune and resolve performance issues for SQL Server, optimizing queries and data models.
  • Architect high-availability and disaster recovery solutions using FCI and Always On Availability groups.
  • Develop data pipelines using Power Query M and build solutions integrating various data sources.
  • Author technical training and solve complex performance problems across the data stack.

Required Skills

  • 5+ years of experience in a relevant architectural or consulting role.
  • Expert proficiency in Power BI solution design and Power BI Embedded development.
  • Deep expertise in Tabular Data Modeling, database design, and optimizing data models.
  • Strong command of DAX for complex calculations and measures.
  • Proven experience with SQL Server performance tuning, clustering, and High Availability features.
  • Experience with data connectivity to SQL, Oracle, MySQL, Azure, and AWS.
  • Proficiency in Power Query M and developing data transformation pipelines.
  • Familiarity with Power BI REST API for programmatic interaction.
  • Ability to develop PowerShell scripts for administrative automation.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs