Flag this message Opening for Technical Analyst,exp-3-9yrs(SSAS,SSRS,SSIS)

Exp req-SSAS,SSRS,SSIS experience with MDX and SQL queries experience Job Title: Technical Analyst Job Description: This position is for an individual contributor, who will be working with a team of Reporting Specialist and would carry out following role • Working closely with the SMEs (Subject Matter Experts), the Reporting Specialist: • Identifying and documenting all business, technical, product and process requirements • Design and develop MSOLAP application/tool as per process/product requirement agreed with business and deliver as per timelines • Troubleshoot SSAS/SSIS/SSRS coding as per business priority and requirement. • Maintenance of SSAS cube, SSIS ETL packages and SSRS reports after delivery to business. • Document key learnings from challenges and critical issues faced in project. • Document technical and process knowledge to build process repository • Analyzing and understanding the current state processes to ensure that the context and implications of change are understood by the clients and the project team • Developing an understanding of how present and future business needs will impact the solution • Developing a Requirements Management Plan and disseminating the Plan to all stakeholders • Working with clients to prioritize and rationalize requirements. Qualifications: • Diploma in IT or Bachelor Degree in IT • 3-4+ years of experience in the areas given. Skill Requirements: 1. Mandatory to have at least one year hands on experience in a. Designing and developing SSAS cube, writing and troubleshooting MDX queries. b. Designing and developing SSIS packages. c. Designing, developing and troubleshooting SSRS reports d. Developing and maintaining SQL Queries. 2. Preferred to have a. VBA(MS-Access/Excel) b. Experience in DB design & optimization 3. Analytical and problem solving skills a. Ability to pay attention to details and analyze rationally. b. Ability to investigate, follow up and resolve reporting issues (e.g. quality, timeliness, accuracy issues) c. Ability to grasp, learn and apply new domain knowledge quickly, and relate to business reports. 4. Communications & Teamwork a. Good communications (Listening, Written and Verbal) skills and good mastery in English. b. Able to communicate complex technical concepts in plain English using layman’s terms. c. Strong team player, with ability to share knowledge & workload among team members, and always meet commitments. d. Assisting the project manager by managing client expectations through careful and proactive communications regarding requirements and changes e. Being well organized and knowing good processes to complete the work needed for the project. 5. Data Quality and Administration a. Good understanding of data quality and accuracy issues in Reporting and able to recommend solutions to rectify the issues. b. Attention to details and good head for figures. 6. Desirable but not mandatory to have at least 1 year of Business Reporting experience a. Understand business reporting process (e.g. investigate requirements – identify data sources, design business model, develop report, and extract, validate & publish results) b. Familiar with at least some reporting tools. Freshers do not apply If anyone with relevant experience is interested send me your updated cv to my mail id-ankita.kalita@hp.com