Roles & Responsibilities
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
Test customized systems
Fix problems with customized systems
Collaborate with teams to develop reports
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
analysis services,etl processes,microsoft reporting services,databases,sql,ssrs,ssis,ms excel,data,relational databases,data extraction,sql code,analysis services cubes