99 Nazztec Jobs
BI Lead - SQL/ETL (8-10 yrs)
Nazztec
posted 21hr ago
Key skills for the job
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.
Functional Areas: Software/Testing/Networking
Read full job description