We are currently seeking a Lead - 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 be a skilled on Advance Excel, SQL, Python and support on Reporting and Analytics applications. The candidate needs to have strong 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 SSISSSRS 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)
- 2+ years experience in Reporting and Analytics with Python, SQL and excel must have prior experience on Relational Database and BI developer using SQL server, SSIS, Power BI, Tableau, Advance Excel.
Skill Set: Good to have:
- Experience on Design and develop relational database models/schemas and Query performance tuning and write ad-hoc SQL queries.
- Exposure to Snowflake would be ab added advantage
- Experience 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
