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/2008R2 TSQL, MySQL, 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, 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