Offer summary

Qualifications:

8-20 years of experience with MSBI tools like SSIS, SSRS, and SSAS., Strong knowledge of SQL/TSQL performance tuning and debugging complex queries., Experience in Agile/Scrum teams and developing BI applications using the MS BI stack., Good verbal and written communication skills, with client-facing experience..

Key responsibilities:

Debug and tune ETL processes to ensure efficient data movement.

Develop complex SSIS, SSRS, and SSAS objects based on customer needs.

Analyze and improve existing dashboards and reporting systems.

Provide training and expertise to business users on utilizing SSAS cubes for reporting.

Job description

Job Description

Job Title: Senior Technical Specialist

Location: Mumbai/Hyderabad/Bangalore

Requirements

Over all 8-20 Years of experience in to MSBI Tools like SSIS, SSRS, and SSAS.
Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data.
Analyse and develop strategies and approach to import and transfer data between source, staging, and ODS/Data Warehouse destinations.
Analyse existing SQL queries for performance improvements.
Strong experience in implementing the Data Integrations using SSIS, Reporting using SSRS and SSAS is a MUST.
Strong knowledge and proven history of SQL / TSQL performance tuning.
Should be able to develop and debug complex SQL and TSQL queries.
Suggest new queries as an outcome of fine-tuned techniques.
Critical thinker and problem-solving skills.
Experience working on an Agile/Scrum team preferred.
Develop the Complex SSIS, SSRS and SSAS object as per the customer need.
Should have strong knowledge on Datawarehouse skill.
Develops advanced BI applications using the MS BI stack including SSAS, SSIS, T-SQL/stored procedures as well as MDX.
Analyses and improves existing dashboards, reports and reporting systems.
Assists in designing extensions to our Data Warehouse 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.
Works closely with the Data Architecture team and provides technical design recommendations on the data mart structures which support analytical applications.
Provides and owns the technical details for implementation and maturing of BI solutions.
Designs functional specs for BI front end applications including dash boards and reporting, considering appropriate data flow and capture.
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.
Proficient in SQL coding.
Triage the Production issues and work on the code fixes.
Must have good verbal and written communication skills.
Must be client-facing.
Must be independent and a self-starter.
Knowledge on Python / PySPark is preferred.
Knowledge on cloud computing (Azure) is an advantage.
Knowledge on other reporting tools like PowerBI is an advantage.

About Us

Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.

Required profile