MSBI Developer
Core
Design and development of Data Warehouse/Data Marts and critical line-of-business applications using Microsoft BI tools.
Role type
MSBI Developer (SSIS, SSRS, SQL)
Builds
Data warehouses, data marts, SSIS packages, and standardized/customized reports
Domain
Enterprise Resource Planning (ERP) and Business Intelligence
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SSIS package development, SSRS report development, T-SQL, SQL Server 2008/R2/2012, Data Warehouse design, SDLC, Agile methodologies
Preferred skills
SSAS, MDX queries, Master Data Management (MDM) tools
Technologies
SSIS, SSRS, SQL Server, T-SQL, SSAS, MDX, MDM
Responsibilities
Analysis and gathering requirements for development projects, Creating tables and relationships in the data warehouse, Creating SSIS packages to migrate large amounts of data, Developing standard and customized reports using SSRS, Creating databases, tables, indexes, views, stored procedures, and triggers, Performance tuning of queries
Seniority
Mid-level (3-7 years experience)