IT Recruiter at Apidel Technologies Pvt Ltd
Views:307 Applications:23 Rec. Actions:Recruiter Actions:0
Apidel Technologies - BI Reporting Analyst - T-SQL/MDX (8-10 yrs)
Position : BI Reporting Analyst
Location : Pune
Please find below Job Description : BI Reporting
Technical Requirements :
- 3+ year experience with dimensional modelling
- Expert at TSQL and MDX coding
- Proficient understanding of Microsoft SQL server
- Microsoft Analysis Services creating and modifying data cubes
- Microsoft Reporting Services
- Microsoft Office (Excel, PPT, Word, Access)
- Project Management tools
- Ability to provide excellent customer service and customer relations
- Proven ability to manage multiple priorities and manage deadlines
- Excellent problem-solving skills
Qualifications : An engineering Degree in computer science or equivalent practical experience
Others : Experience in BFSI sector would be an added advantage.
Responsibilities and job related expectations :
- Elicit, document, and analyze reporting needs and requirements. Analyze data and reporting solutions to understand business impact, correlations/discrepancies, and to propose changes/alternate solutions.
- Develop and maintain a variety of report types, including but not limited to tabular, drill down, matrix, charts or dashboards
- Recommend and make changes need to drive user self service
- Ability to create or modify data cubes
- Delivery of report changes, testing, and deployment with adequate documentation in relation with the request for change or additional requirements
- Business analysis of reporting requirements.
- Provide technical documentation on the recommendation made and on the modification to existing reports due to the new user requirements.
- Write queries, views, stored procedures or MDX to extract data to build reports
- Create scripts for importing, exporting, analyzing, mapping and converting data
- Monitor performance of reports and taking corrective action to optimize or improve the performance of the reports when necessary