Business Intelligence and Power BI Professional

Job Description

What will your role look like 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.