BI Developer at Britehouse

Job description

Requirements:

• Solid knowledge and understanding of writing SQL statements.
• Knowledge of SSIS.
• Knowledge of SSAS and MDX.
• Knowledge of Reporting Services.
• Solid knowledge of the Microsoft office package.
• PowerPivot and PowerView
• A solid knowledge of SQL, stored procedures, triggers, cursors and general scripting.
• Minimum of 4 years SSIS experience.
• Minimum of 4 years’ experience in building and maintaining OLAP cubes in analysis services
• SQL data warehousing
• Tableau front end
• MDX (analysis services) would be advantages
• A demonstrated experience in complex reports, master reports and cube reporting.
• 3 – 5 years experience in database design and the normalization of data structures – must have developed a star schema and facilitated a team effort.
• 2- 3 years’ experience in PowerPivot and Power view
• 2 – 4 years experience in Database administration.
• A passion for the industry and be willing to do self – study
• Advantageous (nice-to-have):
• Knowledge of SharePoint PerformancePoint and PowerPivot.
• 1 year of project management experience