Role Description The resource should possess expert-level competency in their field. In addition to this, the following should also be considered as part of the profile:

- Must have expertise level in MSBI (SSIS, SSAS, SSRS), Power BI Desktop, Power BI Report Builder, Power Apps, Power Automate, Power BI Rest API, and Power BI embedded.
- Must have strong experience with MS SQL Server and Oracle (19c, 18c, 12c/11g/10g), Postgres Databases • Expert SQL & PL/SQL proficiency to conduct data analysis, validations, and discovery.
- Extensive experience in writing complex SQL reports in Oracle, ensuring performance optimization.
- Should have worked on data warehouse and BI technologies.
- Robust experience in Microsoft Azure cloud technologies.
- Must have expertise level in Star Schema and Snowflake Schema methodologies.




- Strong analytical problem-solving ability and Strong interpersonal skills • Excellent verbal and written communication skills and a proven ability to interact professionally with a diverse group • High level of initiative with a proven ability to work independently • Acquaintance in full-lifecycle data warehousing projects and underlying components • Prior experience building Power BI dashboards and reporting analytics on Cloud platforms.
- Acquaintance with tools like Microsoft Analysis Services and Composite Data Virtualization.
- Familiarity with relational databases and analyzing and performing complex queries • Proficiency in systems and data analysis and designing.
- BSc. in Computer Science, Engineering, Management Information Systems, or another related field.
- Minimum 5+ years of experience in Business Intelligence development and Microsoft technologies.

📌 Business Intelligence Specialist (Bengaluru)
🏢 CAPCO
📍 Bengaluru