Job Description :
Role: BI Architect
Duration: 6+ months
Location: Kansas City, MO
  • 5+ years of experience in Microsoft BI stack
  • Experience in performance tuning of Power BI reports/dashboards, scheduling Reports/Direct query etc.
  • Knowledge of Power BI setup and deployment architecture design. Gateway administration.
  • In-depth experience with Microsoft analytics Stack (SQL Server, SSAS Tabular, SSRS, Power BI, Power Query, DAX, SQL and T-SQL)
  • Advanced knowledge Power BI
  • Proficient in DAX, M language
  • Experience in Extraction, Transformation, and Loading (SSIS)
  • Experience in Tabular/OLAP Model (Microsoft SSAS), Azure Analysis Services
  • In-depth experience with Associated Development Tools - Visual Studios Data Tools, SQL Server Management Studio, SQL Server Data Tools, Microsoft TFS
  • Good knowledge of Power Platform including Power Apps and Power Automate
  • Implementation of access control and knowledge of security mechanisms for report access
  • Experience with cube development using SSAS
  • Understanding of Azure and its data services. Cloud and on-premise understanding.
  • Expertise with administering Azure Data Factory, Azure Data Lake, Azure SQL DW, and Azure SQL environments
  • Proficiency required with Microsoft Flow and Microsoft Power Apps setup and usage
  • Knowledge of working with database client tools such as Toad
  • Database Design especially relational database
  • Knowledge of dimensional modeling and data warehousing concepts.
  • Proficient in Microsoft Office Suite and O365
  • Superior documentation and organizational skills. Must be detail-oriented.
  • Excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources
  • Must possess and demonstrate excellent verbal, written, and interpersonal communications skills.
  • Must be an adaptable self-starter and work with minimal supervision. Must be able to handle multiple projects and organize time effectively.
  • Must be willing to put in extra time and effort if need be. Go above and beyond the requirements of the job and strive to exceed expectations.

Preferred skills:

  • Knowledge of Data Mining, Clustering and Statistical Modelling
  • Oracle knowledge


  • Bachelor's degree or higher from a reputed university in engineering, IT, economics, math, statistics, science, or other related fields
  • Minimum of 7 years experience in an Architect level role in business intelligence

Similar Jobs you may be interested in ..