State Street

Senior Analytics Engineer – Team Leader

24 December 2024
Apply Now
Deadline date:
£61000 - £114000 / year

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