Mid Power BI Developer

Capco; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Capco, a Wipro company, is a global technology and management consulting firm energizing the financial services sector through data-driven insights. The Mid Power BI Developer role covers designing BI solutions, building dashboards, and optimizing data pipelines across cloud platforms.

Ideal candidates bring 5+ years in BI with MSBI and Microsoft tech, strong SQL/PLSQL skills, and experience with Azure. The position involves on-site collaboration in Bengaluru with a 12:30–9:30 PM shift and ample

Qualifications

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

Responsibilities

• Role involves designing and developing BI solutions using MSBI and Power BI.
• Develop complex SQL queries and data models to support analytics.
• Create Power BI dashboards and reports for cloud platforms.
• Collaborate with cross-functional teams to deliver data-driven insights.
• Ensure performance optimization of data pipelines and reports.

Skills

SSIS

SSAS

SSRS

Power BI Desktop

Power BI Report Builder

Power Apps

Power Automate

Power BI Rest API

Power BI Embedded

MS SQL Server

Oracle

Postgres

Azure

Star Schema

Snowflake Schema

Data Warehouse

Education

BSc in Computer Science

BSc in Engineering

Management Information Systems

Tools

MS SQL Server

Oracle

PostgreSQL

Azure Cloud

Job description

“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount . With our presence across 32 cities across globe, we support 100+ clients acrossbanking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.

WHY JOIN CAPCO?

You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.

MAKE AN IMPACT

Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.

#BEYOURSELFATWORK

Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.

CAREER ADVANCEMENT

With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.

DIVERSITY & INCLUSION

We believe that diversity of people and perspective gives us a competitive advantage.

Role Description:

Job Title: Mid Power BI Develoepr

Shift Time: 12.30 - 9.30 PM

Overview:

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

If you are keen to join us, you will be part of an organization that values your contributions, recognizes your potential, and provides ample opportunities for growth. For more information, visit www.capco.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube.