Description

You will develop and maintain BI applications within the Customer Engagement area, focusing on tools such as Climate Change Tracking Tool and Green loans.

Responsibilities

• Develop tabular in-memory data models using SQL Server Analysis Services.
• Create dashboards and data visualizations using on-premise PowerBI.
• Source and analyze data across various databases including SQL Server and Oracle.
• Configure data connectors and manage refresh jobs within the SQL Server Database Engine.
• Implement Row Level Security (RLS) and manage complex data models.

Required Skills

• 5+ years of experience in business intelligence development.
• Expert knowledge of SQL, SQL Server, and Oracle.
• Expertise in SQL Server Analysis Services (SSAS) including DAX and M languages.
• Advanced proficiency in PowerBI dashboard creation and data visualization.
• Experience with on-premise PowerBI Report Server.
• Knowledge of setting up ODBC data connectors.
• Knowledge of setting up refresh jobs in SQL Server Database Engine.
• Ability to implement Row Level Security (RLS) at an advanced level.
• Any Graduate degree.

Preferred Skills

• Experience with SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
• Experience working with large datasets in a corporate setting.
• Knowledge of Python or other OOP languages.
• Experience with Snowflake or other data warehouse technologies.
• Background in the banking domain.

Key Skills

Education

Any Graduate