Data Engineer

Redrock Consulting Ltd; Greater London; On-site; GBP 50,000 - GBP 70,000; Full time

Job summary

A consulting firm in data analytics in Greater London seeks a Power BI Specialist with strong expertise in data manipulation, M code proficiency, and advanced DAX calculations. The role involves creating dynamic reports and presenting clear insights using advanced Power BI features, translating complex financial data into effective reporting solutions. Competitive compensation and opportunities for professional growth are offered.

Qualifications

• Advanced data manipulation and transformation using Power Query.
• Proficient use of M code in the Advanced Editor.
• Design and management of complex data models and relationships.

Responsibilities

• Create dynamic report interactions in Power BI.
• Present disparate data sources in a user-friendly manner.
• Translate financial requirements into reporting solutions.

Skills

Power Query

M code

DAX calculations

Finance knowledge

Tools

Power BI

Job description

• Advanced data manipulation and transformation using Power Query (building tables, merging queries, shaping data).
• Proficient use of M code in the Advanced Editor.
• Design and management of complex data models and relationships, including reports sourcing from 20+ spreadsheets.
• Development of advanced DAX calculations and queries, including variables and nested logic.

Power BI Front-End

• Creation of dynamic report interactions (e.g. toggles between Budget and Forecast views).
• Presentation of disparate data sources in a clear, seamless user experience.
• Use of advanced Power BI features such as bookmarks, layers, and conditional formatting to enhance usability and insight.

Domain Knowledge

• Strong understanding of finance and accountancy concepts, with the ability to translate financial requirements into effective reporting solutions.