Job Description :
Position : MSBI Lead/ Architect – Tabular and SSAS
Location : Columbus, IN
Duration : 12+ months Contract
Job Description:
Tabular Modelling
Strong on SSIS/SSRS/SSAS
Conceptual knowledge on Power BI
Knowledge on SharePoint (Added advantage)
Good Communication
Total Experience: 11 -13 years
Experience in end-to-end DW Design, Development and implementation of at least 3 DW projects.
Experience in handling complex integrations and provided stand-alone solutions usning MSBI stack
Hands on knowledge in SSIS, SSAS and SSRS using Tabular (Mandatory) and MDX
SSRS - Reporting using parameters, Sub reports, Drill Down Reports, expressions and report development using Tabular modelling and MDX
SSIS - Development and deployment of SSIS using various sources like Oracle/SQL Server/Flat Files/SAP systems.
SSAS - Working knowledge of SSAS using tabular (mandatory)
MDS - MUST HAVE Working knowledge of MDS
Must Have - Extensive work on SSRS including reports using MDX queries.
Good to Have - Knowledge on Report migration, Subscription, Data extract from SAP systems
Ability to work closely with client to understand requirements and get it done from developers.
Handle team of MSBI resources located at various geographies and review their work.
Ability to take ownership of complete release and delivery.
Mandate to have good exposure on Tabular Modelling Power BI & Sharepoint knowledge Have worked on Security model implementation used in MSBI