2+ years experience in MS Power BI to help create and manage BI and analytics solutions that turn data into knowledge.
2 years of experience in Data warehousing with specific experience in BI report development
Connect, import, shape, and transform data for business intelligence (BI)
Experience in developing Visualization reports and dashboards using MS-Power BI
Visualize data, author reports, and schedule automated refresh of reports
Experience working with DAX (PowerPivot). Advanced DAX skills is a plus
Experience in SQL Server database 2016, Develop and execute database queries and conduct analyses
Expertise in 1) SQL & T-SQL skills, 2) Coding and debugging skills.
SSAS Tabular/Multi-Dimensional cube experience is required.
Familiarity with Data Integration and testing
Good verbal and written communication skills
Ability to work independently in a continually changing environment
Interacting with business users on a regular basis to know the requirements and to understand the business.
Highly proficient in the use of T-SQL for developing complex Stored Procedures, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins.
Highly proficient in OLAP system(s) design and development of SSAS 2014 Cubes and MDX query.
Experience in Tabular and Multidimensional Cube creations in SQL Server 2014 and deployment on SharePoint.
Handled Performance Tuning and Optimization on SQL Server/SSIS/SSAS/SSRS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
Created Data-driven Packages/framework in SSIS 2014 as part of automating the process.
Assess the risks and recommend/ install service packs or hot fixes when needed.
Should be familiar with JSON and XML format data.
End to end understanding of data flow integration from WEB API (JSON format data) to Service Bus (Buffering and Queuing) to loading SQL Server DB tables.
Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
Understanding of C# and ASP.net coding language and SharePoint.
Understanding of SQL Server DBA related activities.
Understanding of Microsoft Azure.
Understanding of TFS (Team foundation server) source control tool for version maintenance and sprint planning.
The employee will have an end to end responsibility of the business solution towards the user community.
Develop, implement and support of chosen solution support planning and development of solutions selected, support implementation plan of a solution, define projects, participate in governance forums, manage business stakeholders, propose improvements on project execution
Drive excellence in solution delivery/consultation share knowledge, mentor, coach; stay updated with business and technology trends; evolve, document and keep updated best practices for development, development process and deployment (including testing standards)
Convert Design into deliverables by applying best practices (working with the fellow developers, architect and PM)
Perform testing, ensure testing standards are followed.
Support / Facilitate Application Operations.
The employee will have an end to end responsibility of the analytical solution towards the user community.