Associate - BI Analytics

Job Description

We are currently seeking a Associate - BI Analytics to contribute to Analytics & BI Development process. This is a hands-on technical and Individual Contributor role. This position requires that the candidate having knowledge on Advance Excel, SQL, Python and support on Reporting and Analytics applications. The candidate needs to have a strong acumen on technical knowledge and be very structured and analytical in his/her approach. Essential Duties and Responsibilities Primary responsibility involves advanced SQL and advanced Excel report design and development. Publishing and scheduling SSIS\SSRS report as per the business requirements. Will be responsible for END TO END BI & Visualization solutions development and projects delivery across multiple clients. Drive the development and analysis of data, reporting automation, Dash boarding, and business intelligence programs. Would be supporting in consulting engagement and should be able to articulate and architect the solution effectively to bring-in the values which data analytics & visualization solution can deliver. Good understanding of database management systems and ETL (Extract, transform, load) framework Connecting to data sources, importing data and transforming data for Business Intelligence. Experience in using advance level calculations on the data set. Responsible for design methodology and project documentation. Able to properly understand the business requirements and develop data models accordingly by taking care of the resources. Should have knowledge and experience in prototyping, designing, and requirement analysis. Qualifications Graduate (BE-BTEC Computer science / BCA/ MCA/ MSc Computers) or have an equivalent academic qualification Good communication Skills ( both written & verbal) Skill Set: Good to have: Academic exposure on design and develop relational database models/schemas and Query performance tuning and write ad-hoc SQL queries. Academic exposure to Snowflake would be ab added advantage Academic exposure with advanced query design, stored procedures, views, functions. Ability to communicate with technical and business resources at many levels in a manner that supports progress and success. Understanding of Python and different libraries - Pandas, Numpy etc Exposure to Cloud Computing such as Microsoft Azure Good knowledge/expertise on different versions of .Microsoft Sql Server 2008, 2012, 2016, 2017, 2020