Mid level BI Developer with hands-on years of experience with the entire Microsoft BI solution lifecycle and demonstrated knowledge of data warehousing with emphasis on reporting and data analytic issues through the entire project lifecycle. The BI Developer will participate in a variety of tasks across multi-functional areas such as:
Possess experience in writing and tuning SQL queries, view, stored procedures, and functions.
Responsible for creating Microsoft SQL Server Integration Services packages, scripts, and other elements to move data from the source databases. Extract, transform, and load (ETL) data from various source systems to the data warehouse covering a variety of technical scenarios encountered in the construction of complex data warehousing solutions.
SQL Server Analysis Services (SSAS) 2005/2008 design and build experience that covers the following features required to ensure high-performing, scalable solutions: multi-tier infrastructures, partitioning, aggregations, proactive caching, actions, role and data-level security.
Create key performance indicators, calculations, and metrics.
Proven experience sourcing data from a variety of applications, creating OLAP models, and generating multi-dimensional cubes using SSAS.
Knowledge and practical experience with at least one of the following front-end reporting tools: SQL Server Reporting Services (SSRS), Performance Point (PPS). Should be able to develop reports and dashboards using SSRS and Performance Point Services for Sharepoint 2010.
Must possess a strong desire to work hands-on developing database, reports and performance management solutions across a range of industries and functional disciplines.
Demonstrated problem solving and quantitative skills, combined with excellent written and verbal communication skills are necessary. Experience with documentation including process flows and data dictionaries.
Team player with strong organizational, multi-tasking, communication, and time-management skills.