Hybrid BI Specialist

at Brillio

• Job title: BI Specialist
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Azure, ETL, Python, SQL, SSIS
• Location requirements: Hybrid, Bangalore, India

About the role

• BI Specialist designing and developing data integration and reporting solutions using Microsoft BI tools. Collaborating with stakeholders in Bangalore to deliver enterprise-level analytics and dashboards.

Responsibilities

• Design, develop, and deploy SSIS packages for data extraction, transformation, and loading. • Implement incremental loads, error handling, logging, and performance tuning. • Integrate data from multiple sources such as SQL Server, Excel, flat files, and APIs. • Schedule and monitor ETL jobs using SQL Server Agent. • Ensure data quality and consistency across systems. • Develop and maintain SSRS reports including tabular, matrix, drill-down, and parameterized reports. • Create paginated reports for operational and financial reporting. • Configure report subscriptions and automated report delivery. • Implement report security and manage deployment across environments. • Optimize report performance and dataset queries. • Design and develop interactive dashboards and reports using Power BI. • Create complex DAX measures and calculated columns. • Develop optimized data models using star schema and best practices. • Implement Row-Level Security (RLS). • Publish and manage reports in Power BI Service. • Collaborate with business stakeholders to gather reporting requirements.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or related field. • 4+ years of experience in Microsoft BI stack development. • Strong expertise in Power BI (Desktop & Service) • Hands-on experience with SSIS and SSRS • Advanced knowledge of T-SQL (joins, CTEs, stored procedures, indexing, window functions) • Strong understanding of data warehousing concepts (Star Schema, Fact/Dimension modeling) • Experience with SQL Server database management • Performance tuning and query optimization skills. • Preferred / Good to Have • Experience with Azure Data Factory or Azure SQL • Exposure to SSAS (Tabular/Multidimensional) • Knowledge of DevOps / CI-CD deployment • Experience in Agile development environment • Basic scripting knowledge (PowerShell or Python).