Data Analyst

Burns Sheehan; England; Hybrid; GBP 80,000 - 100,000; Part time

Job summary

A UK-based consultancy is seeking a Data Analyst to manage and innovate market data analytics in a dynamic environment. This role emphasizes collaboration with engineering teams and external data providers to improve data workflows and create actionable dashboards. Candidates should have strong experience with Excel, Power Query, SQL, and Power BI, as well as familiarity with real estate data structures. The position offers a contract of £425 a day for 6 months, located in London with hybrid work options.

Benefits

Dynamic work environment

Significant ownership over data products

Collaboration with a talented team

Qualifications

• Strong experience with Excel, Power Query, SQL, and Power BI.
• Knowledge of ETL processes, data modeling, and multi-layered architecture.
• Familiarity with real estate data structures and data warehouse environments.

Responsibilities

• Manage the ingestion and transformation of data via SharePoint and Power BI dataflows.
• Identify inefficiencies and implement process improvements.
• Monitor data quality and develop dashboards.

Skills

Excel

Power Query

SQL

Power BI

Tools

Azure SQL

SharePoint

Job description

Data Analyst – Market Data & Analytics

Location: London/Soho one day a week

Employment Type: Contract £425 a day - Outside IR35 - 6 months

Are you ready to take ownership of a fast-evolving data product in a start-up‑style environment? We’re looking for a Data Analyst to join an innovative market data initiative, helping shape how real estate data is structured, visualized, and leveraged across the business.

This is a unique opportunity to work with cutting‑edge tools like Azure SQL, Power BI, and the Power Platform, with significant influence over workflows, dashboards, and data strategy.

What You’ll Do

• Manage the ingestion and transformation of Excel‑based datasets via SharePoint and Power BI dataflows.
• Maintain consistency in formatting, templates, and field definitions across multiple data sources.
• Identify inefficiencies and implement process improvements to reduce manual effort.
• Monitor data quality, handle errors, and develop dashboards to ensure accuracy and governance.
• Build and maintain data transformation logic using Power Query and SQL within a multi‑layered architecture.
• Collaborate with engineering teams and external data providers to resolve discrepancies and integration challenges.
• Support the creation of actionable Power BI dashboards for business insights, underwriting, and strategic decision‑making.

What We’re Looking For

• Strong experience with Excel, Power Query, SQL, and Power BI.
• Knowledge of ETL processes, data modeling, and multi‑layered architecture.
• Familiarity with real estate data structures, SharePoint, and data warehouse environments.
• GIS experience is a plus, with potential to expand into geospatial analysis.
• A detail‑oriented, proactive problem solver with strong communication skills and a passion for data integrity.

Why You’ll Love This Role

• Significant ownership over the data products you help build.
• Work in a dynamic, fast‑paced, start‑up‑style environment.
• Collaborate with a talented team on innovative solutions impacting real estate analytics.
• Opportunity to shape processes, dashboards, and data strategy from the ground up.