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