Senior Analytics Engineer - Team Leader

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