Business Intelligence Lead

Job Location :

Bangalore / Noida / Indore Experience :

8-12 Years

Qualification :

Hands on with Database technologies like Oracle, MS SQL Server 2000 / 2005 / 2008R2 TSQL, MySQL, PostgreSQL Competent in writing efficient SQL queries, stored procedures, PL / SQL Experience in any scripting language like Java, Python, R, etc. Experienced in developing reports, dashboards and analytics using any ofthe contemporary reporting and BI tools like - Crystal reports, Business Objects, Microsoft Reporting Services (SSRS) or Microsoft Analysis services (MSAS), Tableau, MicroStrategy, Qlik, PoweBI, SpotFire Experience in creating ETL jobs using any ETL platform like Informatica, SSIS, etc. Experience in data modeling, schema design and data mart / data warehouse design Experience in designing and implementing OLAP Cubes for slicing and dicing Experience in creating interactive BI dashboards, reports, and KPI analytics Experience in designing and implementing Data Science (AI, ML) use cases using Python, R Experience in complete SDLC, project management concepts and Agile delivery methodology Excellent communication skills and listening ability

Responsibilities :

Understand customer requirements, problem statements and business use cases. Document customer requirements, design ETL jobs, query objects, data marts, reports, and dashboards. Document technical design. Experienced in translating business requirements into design Develop and test ETL jobs, query objects, data marts, reports, and dashboards Understand Customers business domain and existing database schema Design OLAP cubes, SQL reports, interactive Charts and Dashboards Write stored procedures, functions, packages, scripts, and complex SQLs Review existing report design, database schema, SQL code and provide recommendations to enhance performance, operational aspects etc. Work closely with customers for solution fine tuning and troubleshooting production issues Efficient in task monitoring and status reporting to senior management, customers, and stakeholders Excellent problem analysis and resolution skills which may require debugging at OS, database, or network level, if needed Understanding of cloud deployment architecture and Big Data platforms would be added advantage (good to have)