Business Intelligence and Power BI @ Infobeans

• Develop requirements, wireframes, and dashboards for varied audiences related to financial and project management related metrics.
• These dashboards will pull from multiple data sources and require the need to format and aggregate data.
• Produce compelling and informative visualizations using various native and custom chart types. Create and maintain relationships between visuals, filters, bookmarks, and numeric/field parameters.
• Design strategic visual interactions that enhance the end-users experience using cross- filtering and cross- highlighting.
• Write and optimize DAX expressions to create measures and calculated columns.
• Create effective data models. Maintain relationship cardinality and cross- filtering between tables.
• Manage online deployment pipelines to test and publish Power BI reports. Manage user roles and implement row-level security to restrict data access.
• Clean, transform, reshape, and aggregate data from different sources such as Excel, SQL Server, SharePoint, etc. Create dynamic, reusable queries using parameters.

Why you will love this role

• Besides a competitive package, an open workspace full of smart and pragmatic team members, with ever-growing opportunities for professional and personal growth
• Be a part of a learning culture where teamwork and collaboration are encouraged, diversity is valued and excellence, compassion, openness and ownership is rewarded

We would like you to bring along

• Strong Power BI expertise with in-depth understanding of dataflows, datasets and integration with backend databases
• Python exposure will be a huge plus.
• M Language Knowledge of different data types and data structures like values, records, tables, lists, etc.
• Familiarity with built-in functions and the ability to write custom functions. Understand native query folding to optimize performance.
• SQL Experience writing and optimizing queries. Strong understanding of relational databases.
• Familiarity with common filtering functions (CALCULATE, FILTER, etc.) and iteration functions (SUMX, AVERAGEX, etc.)
• Understand the use cases for Import, DirectQuery, Dual, and Live data storage modes.