Job Description
The Senior Power BI Engineer position is an integral part of the analytics & reporting team at CRPM. The primary goal of the PBI resource is to support the existing team of PBI while learning and improving their existing analytics skills.
- Power BI Developer Roles and Responsibilities:
- 3 to 6 years of relevant experience as a detail-oriented Business Intelligence or Data analyst
- Experience working with data visualization tools such as Power BI (Dashboard Layout / Formatting, DAX, Power Query)
- Perform DAX queries and functions in Power BI along with transformation of data using POWER QUERY functions
- Excellent in analytical thinking for translating data into informative visuals and reports
- Create relationships between data and develop tabular and other multidimensional data models
- Experience with data analysis using Excel and other tools
- Experience working as part of a cross-functional team
- Familiarity with data warehouses and database concepts
- Eagerness to learn new topics and explore opportunities to identify and improve process inefficiencies
- The ability to build strong relationships across the organization at all levels and are a team player
- Excellent communication and presentation skills, with the ability to translate sophisticated analytical concepts to a non-data fluent audience
- Good exposure to PBI REST APIs and power BI embed
- Good to have knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, PolyBase, Visual Studio, etc
- Able to implement row level security on data and understand application security layer models in Power BI
- Person should have great knowledge and working experience of below tools and techniques:
- Extensive hands-on experience on Power BI Desktop
- Data Modelling Power Query Transformation Fair Understanding of M-Query Create and Invoke Functions RLS Services Side Features Deployment Pipeline Share and Collaborate Features Power BI REST APIs Data Gateways
- Direct vs Import Data Storage Mode
- Should have good knowledge on data modelling techniques
- Should have good understanding of Performance analyser using DAX studio
- Good to know tools and skills:
- SQL Query Writing
- ETL Understanding
- Power Automate
- MS Flow
- Power BI Report Builder OR SSRS
State Street's Speak Up Line