Description
- Strong experience with SQL 2008 R2 and/or 2012
- Microsoft Business Intelligence tools (SQL Analysis Services (MOLAP, MDX, Tabular), SSIS, SSRS)
- Reporting: SQL Server Reporting Services
- ETL: Integration Services or a similar tool
- Experience integrating BI components such as SSRS with SharePoint (2010 or 2013)
- Extensive experience in developing BI applications such as business area dashboards or large enterprise applications such as an Enterprise Information Portal and its components
- Experience conducting current state/future state/gap analysis and roadmap planning
- A working knowledge of security within SQL Server and the business intelligence tools
- Experience with query tools, report writers and OLAP tools (Reporting Services, Business Objects, Cognos, Hyperion Reports/Analyzer)
- Strong understanding of dimensional modeling and design (Star Schema, Snowflake Schema)
- Experience with "self-service" BI applications such as Power BI, including PowerPivot and Power View
- Achievement of professional certifications