Develop SSRS Reports and dashboards using Microsoft Reporting Services platform (SSRS), Microsoft SQL, MS Excel, pivot tables, and other tools Analysis Services Cubes and relational databases.
Development of complex SQL Code (stored procedures, triggers, views, and functions)
Modify/Create/maintain and optimize ETL processes using SSIS
Create Data extraction and Import programs using SSIS
Interact with all stakeholders not limited to IT to ensure an accurate and comprehensive understanding of business requirements
Implement user stories
Help train the team
Qualification
Experience using SSRS & SSIS to create automated reports
MS Excel must be able to use and create basic formulas, link to data sources and relational data models
5+ Years of experience in database design, and development and Extensive experience with report development using various tools (SSRS, PowerBi, Excel, desktop databases)
Experience in SQL environments, which includes security, index and user management, and release migration
Experience in designing and developing Reports & ETL solutions using SQL Server SSIS/SSRS/SSAS
Skills: microsoft sql,triggers,pivot tables,stored procedures,relational databases,ssrs,ssis,user stories,analysis services cubes,sql code,data extraction,train the team,import programs,etl processes,microsoft sql ssrs,views,sql,ms excel,functions