Business Intelligence Specialist

Capco; Bengaluru; On-site; INR 1,400,000 - 2,400,000; Full time

Job summary

Capco in Bengaluru, India seeks an experienced BI Developer to build and optimize data warehousing and analytics solutions. You will design and deliver Power BI dashboards, integrate MSBI components, and collaborate with stakeholders across Azure cloud platforms.

The role requires strong SQL/PL/SQL, Oracle and PostgreSQL experience, plus expertise in star and snowflake schemas and data modeling. Independent, proactive professionals will thrive in this team-oriented environment.

Qualifications

• 5+ years of experience in BI development and Microsoft technologies.
• Expertise in MSBI, Power BI, SQL/PLSQL across relational databases.
• Experience with data warehousing, cloud platforms, and Azure.
• Strong analytical, communication, and independent working skills.

Responsibilities

• Develop BI solutions and dashboards on cloud platforms.
• Perform data analysis, validations, and discovery with SQL/PL/SQL.
• Design star and snowflake schema data models.
• Collaborate with stakeholders and maintain performance-optimized reports.

Skills

MSBI

SSIS

SSAS

SSRS

Power BI Desktop

Power Apps

Power Automate

Power BI Rest API

Power BI Embedded

MS SQL Server

Oracle

PostgreSQL

PL/SQL

SQL

Data Warehousing

Azure

Star Schema

Snowflake Schema

Education

BSc in Computer Science

Engineering background

Management Information Systems

Related field

Tools

Microsoft Analysis Services

Composite Data Virtualization

Cloud platforms (Azure)

Job 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.
• Strong 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.