Senior Microsoft BI Consultant

Submit your resume

Job description

The Senior Microsoft BI Consultant will be responsible for development, rollout and support of client-facing business intelligence solutions. In this role, you will leverage Microsoft BI components to implement bespoke combinations of dimensional data models, semantic data models, integrations, visualizations, security and governance. You will also work closely with the client to gather business requirements, craft logical architectures and document solutions.

Specific responsibilities

  • Craft data and analytics solutions that scale and adapt to accommodate growth using Microsoft BI components
  • Author custom-fit database models using SQL Server and Azure
  • Develop flexible semantic models that incisively tell a client’s data story using Power BI and SSAS
  • Create informative and interactive data visualizations/models using Power BI
  • Provide detailed documentation and knowledge-transfer services to customers
  • Perform project management activities including project documentation, business requirements and project tracking


  • Bachelor’s degree in Computer Science, Business Administration or related field
  • 4+ years of customer-facing consulting experience
  • 8+ years of data warehousing and business intelligence implementation experience
  • Strong aptitude for modern business intelligence solution development using Power BI, SQL Server and Azure components (e.g. Azure Analysis Services, Azure Synapse Analytics)
  • Strong understanding of T-SQL language (understanding of other flavors such as PL/SQL a bonus)
  • Strong understanding of data integration concepts using Azure Data Factory
  • Strong understanding of dimensional data modeling concepts as well as data warehouse design and lifecycle management principles
  • Strong understanding of semantic data modeling concepts and tabular model development using SSAS Tabular and Power BI
  • Strong experience with Power BI Desktop, including related languages (e.g. DAX, M) and tools (e.g. Tabular Editor and DAX Studio)
  • Ability to discuss and design solution architecture involving Microsoft components
  • Experience with data modeling tools (e.g. Toad Data Modeler, ERwin)
  • Ability to steward client conversations and document requirements
  • Understanding of security best practices
  • Understanding of data governance principles
  • Strong analytical, quantitative, problem solving and organizational skills
  • Attention to detail and ability to coordinate multiple tasks, set priorities and meet deadlines


Love where you live? A live anywhere, work anywhere policy has been our model from founding over 20 years ago. We won’t ask you to move, and much of our work is delivered remotely.

Send your resume to [email protected]

Connect with Senturus

Sign up to be notified about our upcoming events

Back to top