Dimensional modelling and abstraction layer concepts and practical experience in UDM and BISM.
Microsoft SQL Server Integration Services including the ability to develop ETL processes to load data warehouse applications. Other ETL tools (e.g. Informatica) a plus.
OLAP technologies: multi-dimensional and Tabular databases with the ability to design and deploy cubes create calculated members and KPIs, and a working knowledge of MDX and DAX. Advanced Proficiency in securing OLAP databases.
Thorough understanding of the application of the various modes of SSAS (Multi-Dimensional, Tabular and PowerPivot instances)
Microsoft SQL Server Reporting Services including the ability to design and develop reports using SQL Server or Analysis Services data sources.
SQL Server performance tuning, backup and recovery, and other administrative functions.
Azure Big Data tools (Azure Data Warehouse, Azure Data Factory, Azure Data Lake), highly desired
Dashboard design with a working knowledge of Tableau, PowerBI, and QlikSense; including the ability to design and develop scorecards and dashboards
Understanding of modern data warehousing and big data tools and architectures.
MPP technology, architectures, services and appliances like, Microsoft Analytic Platform System, Hadoop, HBase and HDInsight a major plus.
Preferred understanding of Master Data Management (MDM).
Preferred knowledge of vendors besides Microsoft, like QlikView, Birst, Tibco Spotfire, Business Objects etc., in the business intelligence tools market and understanding of their capabilities.
Preferred knowledge of general roadmap of Business Intelligence and Big Data tools
Preferred knowledge of SAP or Oracle ERP systems
Familiarity with Agile development methodologies
Familiarity with Source Control Technologies (ex. GitHub) and build management
Microsoft, Tableau, AWS and Hadoop (Hortonworks, Claudera, MapR, etc.), certifications a plus.
Additional Skills & Competencies:
Bachelor’s Degree in Computer Science, or equivalent work experience.
Experienced in problem solving, and able to follow a methodical implementation process.
Excellent interpersonal and organizational skills, ability to handle diverse situations, multiple projects and rapidly changing priorities.
Ability to communicate with clients at all levels.
Work directly with business development teams during project envisioning (e.g., proposal generation, statements of work, RFP/RFQ creation and delivery) to come up with the best solution for given requirements, with the ability to provide reasonably accurate estimates for projects.