This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Senior Microsoft BI Consultant
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
Qualifications
- 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
Location
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 jobs@senturus.com