Job Description :
The BI Developer will join the Data and Reporting team and help us implement our vision for a modern enterprise data and reporting platform using the Microsoft technology stack. The ideal candidate should be detail oriented, have a passion for data and science, and be familiar with concepts and works by Kimball, Inmon, Edward Tufte, and Stephen Few. The candidate should be driven to continuously learn and improve.

Responsibilities

Build ad-hoc, canned, and self-service reports and dashboards that expose key business insights.
Develop ETL applications for moving and transforming data across our data environments.
Write and optimize OLTP and OLAP database queries.


Required Skills & Experience

A Computer Science related degree or five or more years of experience in business intelligence development.

Be proficient in at least two of the following software packages:
Microsoft SQL Server Reporting Services (SSRS)
Microsoft SQL Server Integration Services (SSIS)
Microsoft SQL Server Analysis Services (SSAS)

Experience writing complex set based T-SQL queries working in Microsoft SQL Server.
Experience optimizing SQL queries by analyzing query plans and effectively using indexes.
Knowledge of MDX is a plus.
The ability to communicate effectively with both business and technical team members.
An understanding of the best practices for visualizing data.
Participation in the SQL PASS community is a plus.

Client : Kansas City Life