Senior BI Engineer - R01569560

Brillio 2; Bengaluru; On-site; INR 1,000,000 - 1,600,000; Full time

Job summary

Brillio 2 is looking for a Senior BI Engineer to design, build, and maintain Power BI reports, dashboards, and KPI scorecards that deliver actionable insights for business stakeholders.

You will optimize data models, connect diverse data sources, and implement DAX calculations to ensure reporting accuracy while collaborating with UX/UI teams to create compelling visuals and uphold data governance.

Qualifications

• 2–4 years hands-on BI engineering experience with Power BI, SQL, and PowerApps.
• Design, develop, and maintain BI reports, dashboards, and KPI scorecards for stakeholders.
• Build and optimize Analysis Services models and data warehouse alignment.
• Connect to diverse data sources and implement DAX calculations for accuracy.
• Architect reporting solutions from wireframes to scalable analytics.
• Implement row-level security and data governance in BI solutions.
• Collaborate with UX/UI teams for impactful visualizations and timely delivery.
• Engage stakeholders to deliver tailored analytics with high-quality outputs.

Responsibilities

• Design, develop, and maintain Power BI reports and dashboards.
• Optimize SSAS/SSRS/SSIS models for standards compliance.
• Connect to multiple data sources and transform data for BI needs.
• Implement advanced DAX calculations for reporting accuracy.
• Architect scalable analytics solutions based on client needs.
• Enforce row-level security and data governance integration.
• Improve dashboard performance for large datasets.
• Collaborate with UX/UI teams for effective visualizations.
• Engage stakeholders to deliver tailored analytics outputs.

Skills

Data analysis

SQL

Python

Exploratory data analysis

Data storytelling

Communication

Insight generation

Education

Bachelor's degree in Computer Science/IT/Data Analytics

Microsoft Certified: Data Analyst Associate (Power BI)

Microsoft Certified: Azure Data Engineer Associate

Tools

Power BI Desktop

Power BI Premium

Power BI Server

Power BI Services

SSAS

SSRS

SSIS

SQL

PowerApps

Excel VBA

Job description

Senior BI Engineer

• Data Analysis, SQL, Python, Exploratory Data Analysis, Data Storytelling & Insight Generation, Excel VBA, Insight Generation, Communication & Articulation: Vocal & Written
• BI Foundation: Business Consultant
• Experience Range: 2 to 4 years of hands-on experience in Power BI, SQL, and PowerApps, including practical exposure to BI engineering projects
• Key Responsibilities:
  1. 1. Design, develop, and maintain Power BI reports, dashboards, and KPI scorecards to deliver actionable insights for business stakeholders
  2. 2. Build and optimize Analysis Services reporting models, ensuring compatibility with data warehouse standards and supporting both tabular and multidimensional models
  3. 3. Connect to diverse data sources, import and transform data for business intelligence, and implement advanced calculations using DAX to enhance reporting accuracy
  4. 4. Architect reporting solutions based on client requirements, translating wireframes and requirement documents into scalable analytics solutions
  5. 5. Implement and manage row-level security, integrating analytics with data governance, quality, and security platforms to ensure compliance and data protection
  6. 6. Optimize dashboard and query performance to efficiently handle large and multiple datasets, ensuring timely delivery of analytics outputs
  7. 7. Collaborate with UX/UI teams to design impactful visualizations, leveraging Power BI product capabilities for enhanced user experience
  8. 8. Engage with internal and external stakeholders to understand business challenges, deliver tailored analytics solutions, and ensure high-quality client outputs
• Required Skills:
  1. Power BI Desktop, Power BI Premium, Power BI Server, and Power BI Services
  2. SQL and query performance tuning
  3. DAX for advanced calculations
  4. Microsoft Business Intelligence Stack (SSAS, SSRS, SSIS)
  5. Data modeling for BI and ETL development
  6. Row-level security implementation in Power BI
  7. Connecting, importing, and transforming data from multiple sources
  8. Multidimensional and relational database design
  9. PowerApps and Power Automate
• Preferred Skills:
  1. Experience in supply chain domain analytics
  2. Azure Synapse and MS SQL DB
  3. Data extraction, ingestion, and processing of large distributed datasets
  4. Leading large-scale data warehousing and analytics projects
  5. Python for data analysis and exploratory data analysis
• Desired Qualifications:
  1. Bachelor's degree in Computer Science, Information Technology, Data Analytics, or a related discipline
  2. Microsoft Certified: Data Analyst Associate (Power BI)
  3. Microsoft Certified: Azure Data Engineer Associate or equivalent certification in SQL/Business Intelligence