Brillio

BI Specialist

Brillio

full-time

Posted on:

Location Type: Hybrid

Location: Bangalore • India

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AzureETLPythonSQLSSIS

About the role

  • 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).
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SSISSSRSPower BIT-SQLDAXdata warehousingperformance tuningquery optimizationAzure Data FactoryAzure SQL
Soft Skills
collaborationcommunication