Summary:

The Senior BI Engineeris responsible for building, implementing and supporting Microsoft BI solutions. The right individual will have demonstratedproficiency in all stages of BI project work (requirements and logical design, physical design, implementation, testing and deployment). The Senior BI Engineer should have advanced knowledge of BI implementation methodologies and will have had in-depth experience with the Microsoft BI Stack (SSIS, SSRS and SSAS). 

Duties and Responsibilities:

• Data gathering, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs. 

• Create written communication materials that effectively summarize findings and support recommendations.

• Drive quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT).

Education and Experience:

• 5 years Business Intelligence experience. 

• BA/BS degree in computer science, information technology, engineering or related field.

Required Skills:

Core Competency Requirements

The Senior BI Engineer should have expert level understandingin the various technologies needed to implement Microsoft BI solutions. The engineer must have proven, industry experience with the Microsoft BI stack and exposure to other technologies is a plus (Halo BI, Oracle, SAP BW, SAP Business Objects, etc.).

Preferred Competency Requirements 

• 5 years of database design and integration experience with SQL Server databases.

• Relational Database and SQL Language.

• Extraction, Transformation and Loading (ETL) experience (Microsoft SSIS).

• Analytics/OLAP Cube Development (Microsoft SSAS).

• Report Development (Microsoft SSRS).

• Advanced knowledge of project management methodologies and best practices.

• Excellent verbal and written communication skills.

• Multi-Dimensional Expression (MDX).

• Query/Solution performance tuning and optimization.

• Troubleshooting and incident resolution.

• Dimensional Modeling (Kimball Methodology).

• Data Warehouse/Solution Design.

• Predicative Modelling