Business intelligence lead

Experience : 8-12 Years Job Location : Noida / Indore / Mumbai

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 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 skills)

Qualifications

Hands on with Database technologies like Oracle, MS SQL Server 2000 / 2005 / 2008 R2 TSQL, My SQL, Postgre SQL Competent in writing efficient SQL queries, stored procedures, PL / SQL

Experience in any scripting language like Java, Python, R, etc.

Experience in all flavors of operating systems like Windows, Linux, Mac etc.

Experienced in developing reports, dashboards and analytics using any of the contemporary reporting and BI tools like - Crystal reports, Business Objects, Microsoft Reporting Services (SSRS) or Microsoft Analysis services (MSAS), Tableau, Micro Strategy, Qlik, Powe BI, Spot Fire

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