Associate

Role Objective

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, Pythonand 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