BI Lead - SQL/ETL (8-10 yrs)

Job Title : BI Lead

Location : Bangalore

Experience : 8 to 10 Years

Job Description :

We are looking for an experienced BI Lead to design, develop, and optimize Power BI reports and dashboards that drive key business decisions. The ideal candidate will have a strong background in data visualization, SQL, reporting tools, and cloud-based data solutions.

Key Responsibilities :

- Report & Dashboard Development : Design, develop, and optimize Power BI, MS SSRS, and Tableau reports & dashboards based on business requirements.

- Data Analysis & Mapping : Analyze existing reports and data structures, ensuring accurate data representation.

- SQL & Data Modeling : Strong SQL skills with an ability to understand DB models, table relationships, and KPI creation.

- Cloud-Based Reporting : Develop reports based on data stored in cloud-based Data Lakes and Data Warehouses (AWS/Azure).

- Data Visualization : Generate effective visualizations, graphs, and interactive dashboards.

- Customization & Modifications : Customize and modify Power BI / SSRS reports as per business needs.

- Publishing & Distribution : Hands-on experience in publishing Power BI reports with appropriate security settings.

- Filters & Parameters : Work with different types of filters, parameters, calculation fields, action sets, and interactive dashboard elements.

- Data Source Integration : Work with various data sources like RDBMS, APIs, Cloud DB services (AWS preferred), ODBC connections.

- ETL & Data Preparation : Basic knowledge of ETL concepts, data analysis, and Power BI Data Extracts & Power BI Prep.

- Data Security : Knowledge of data security and governance in Power BI / SSRS reports.

Process Improvement : Drive improvements in dashboard performance and reporting processes.

- Agile & SDLC Practices : Work within Agile teams, SDLC methodologies, and manage multiple priorities effectively.

- Debugging & Troubleshooting : Strong debugging and problem-solving skills for reporting issues.

Technical and Professional Expertise :

- Hands-on experience with Power BI, MS SSRS, Tableau, and Excel Macros.

- Strong SQL skills with experience in data modeling and KPI creation.

- Experience with ODBC, API connections, and cloud-based reporting solutions.

- Knowledge of custom charts, dual-axis reports, data blending, and interactive dashboards.

- Understanding of dimensional modeling and ETL concepts.

- Proficiency in data security principles for reporting tools.

- Strong analytical and communication skills.