Primary Responsibilities

• Develop the ETL using SSIS and the reporting using Power BI / SSRS/ Tableau

• Develops advanced BI applications using the MS BI stack including SSAS, SSIS, T-SQL/stored procedures as well as MDX

• SSRS report development / deployment

• Analyzes and improves existing dashboards, reports and reporting systems

• Designs and develops Business Intelligence solutions using multidimensional cubes including MOLAP and ROLAP

• Provides training and expertise to business users and other stakeholders on utilizing SSAS cubes for their reporting needs

• Designs functional specs for BI front end applications including dash boards and reporting, considering appropriate data flow and capture

• Works closely with the Data Architecture team and provides technical design recommendations on the data mart structures which support analytical applications

• Works with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions

• Identifies problem trends and corrective actions and documenting these through modification of existing best practices guidelines

• Provides expertise and guidance to other developers in the use of the toolset

• Perform the day-to-day functions such as running of existing programs, applications, jobs, reviewing logs for errors, writing or editing software and code, performing testing activities, and updating documentation

Skillsets Required/Qualifications :

• 2+ years of experience in in creating SQL scripting from scratch

• 2+ years of experience in building an SSIS script from scratch and connecting SQL to a data source

• 2+ years of experience in building an SSRS report from scratch.

• 2+ years of experience in working on ground up projects.