Job Description :
Design and develop requirements, wireframes, and interactive dashboards for diverse stakeholders, focusing on financial and project management metrics. These dashboards will integrate data from multiple sources and require advanced formatting and data aggregation techniques.
Experience in the banking domain is highly preferred.
Top 3 Skills : 1. Power BI
- Visualization : Build compelling, user-friendly dashboards using a variety of native and custom visuals. Implement interactivity through filters, bookmarks, and parameter-based controls. Design strategic visual experiences using cross-filtering and cross-highlighting techniques.
- DAX Language : Write and optimize DAX expressions to create complex measures and calculated columns. Proficient in using core filtering functions (CALCULATE, FILTER) and iterators (SUMX, AVERAGEX, etc.).
- Data Modeling : Design robust data models with accurate relationships and filtering behavior. Understand and apply appropriate storage modes including Import, DirectQuery, Dual, and Live.
- Deployment & Security : Manage deployment pipelines, test and publish Power BI reports, configure user roles, and implement row-level security to ensure data integrity and access control.
2. Power Query
Data Transformation : Clean, reshape, and aggregate data from various sources such as Excel, SQL Server, SharePoint, etc. Build reusable and dynamic queries using parameters.M Language : Strong grasp of M language concepts including values, records, lists, and tables. Skilled in using built-in functions, writing custom logic, and leveraging query folding for performance optimization.3. SQL
Database Proficiency : Write efficient and optimized SQL queries. Solid understanding of relational database structures, indexing, joins, and performance tuning techniques.