Data Analyst in City of London

Data Analyst in City of London

City of London Full-Time 55000 - 65000 £ / year (est.) No home office possible
Stanton House

At a Glance

  • Tasks: Develop and maintain data pipelines, integrate systems, and support BI reporting.
  • Company: Join a growing organisation in the dynamic real estate sector.
  • Benefits: Competitive salary, hybrid work model, and opportunities for professional growth.
  • Why this job: Make a real impact by improving data quality and enabling insightful reporting.
  • Qualifications: Strong SQL skills, experience with ETL/ELT, and proficiency in BI tools.
  • Other info: Collaborative environment with a focus on data maturity and automation.

The predicted salary is between 55000 - 65000 £ per year.

Stanton House is partnering with a growing organisation in the real estate space to hire a Data & Integration Analyst who will play a key role in developing their data platform, improving system integrations, and enabling high‑quality reporting across the business.

In this role, you’ll build and maintain data pipelines, integrate multiple SaaS systems, support BI reporting, and ensure data is accurate, accessible, and trusted. You’ll work closely with both technical teams and business stakeholders to deliver meaningful insights and automate key data processes.

Key Responsibilities
  • Support the development and maintenance of the data warehouse
  • Organise and model data to enable reporting, analytics, and dashboards
  • Maintain documentation for core datasets
  • Build and enhance BI dashboards and reports (e.g., Power BI)
  • Work with stakeholders to gather reporting and data requirements
  • Ensure reporting outputs are accurate, consistent, and reliable
  • Design and maintain data integrations between core systems
  • Build and manage ETL/ELT pipelines
  • Use APIs and integration tools to automate data flows
  • Monitor and troubleshoot pipelines to ensure accuracy and uptime
  • Implement integrations across key platforms (e.g., CRM, finance, property/asset management, marketing, operational systems)
  • Automate workflows to improve cross‑system data consistency
  • Monitor and improve data quality across all systems
  • Resolve data issues with system owners
  • Contribute to data standards, documentation, and governance processes
  • Identify opportunities to automate manual data and reporting tasks
  • Improve efficiency and reliability of data workflows
  • Support initiatives that advance the organisation’s data maturity
Experience Required
  • Strong SQL and relational database experience
  • Hands‑on experience with ETL/ELT and API integrations
  • Proficiency with BI tools (Power BI, Metabase, etc.)
  • Experience working with multiple SaaS platforms
  • Data modelling and documentation
  • Experience with low‑code integration tools (e.g., Zapier) beneficial
  • Background in property, real estate, hospitality, or multi‑site operations is beneficial

Data Analyst in City of London employer: Stanton House

Stanton House is an exceptional employer, offering a dynamic work environment in the heart of London where innovation meets collaboration. As a Data & Integration Analyst, you will not only contribute to the development of a cutting-edge data platform but also enjoy opportunities for professional growth and skill enhancement within a supportive team culture. With a focus on employee well-being and a commitment to advancing data maturity, this role provides a unique chance to make a meaningful impact in the real estate sector while enjoying the benefits of a hybrid working model.
Stanton House

Contact Detail:

Stanton House Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Analyst in City of London

✨Tip Number 1

Network like a pro! Reach out to folks in the real estate and data analytics space on LinkedIn. Join relevant groups, attend meetups, and don’t be shy about asking for informational interviews. You never know who might have the inside scoop on job openings!

✨Tip Number 2

Show off your skills! Create a portfolio showcasing your data projects, especially those involving SQL, ETL processes, and BI dashboards. This will give potential employers a taste of what you can do and set you apart from the crowd.

✨Tip Number 3

Prepare for interviews by brushing up on common data-related questions and scenarios. Be ready to discuss your experience with data integrations and how you've tackled data quality issues in the past. Practice makes perfect!

✨Tip Number 4

Don’t forget to apply through our website! We’ve got loads of opportunities that might just be the perfect fit for you. Plus, it’s a great way to get noticed by our hiring team directly!

We think you need these skills to ace Data Analyst in City of London

Data Pipeline Development
System Integration
Business Intelligence Reporting
Data Accuracy Assurance
Data Warehouse Maintenance
Data Modelling
Power BI
ETL/ELT Processes
API Integration
Data Quality Monitoring
Documentation Skills
Automation of Data Workflows
SQL
SaaS Platform Experience
Low-Code Integration Tools

Some tips for your application 🫡

Tailor Your CV: Make sure your CV is tailored to the Data Analyst role. Highlight your experience with SQL, ETL/ELT processes, and BI tools like Power BI. We want to see how your skills match what we're looking for!

Showcase Your Projects: Include specific projects where you've built data pipelines or integrated systems. This gives us a clear picture of your hands-on experience and how you can contribute to our data platform.

Be Clear and Concise: When writing your cover letter, keep it clear and to the point. Explain why you're interested in the role and how your background makes you a great fit. We appreciate straightforward communication!

Apply Through Our Website: Don't forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can't wait to hear from you!

How to prepare for a job interview at Stanton House

✨Know Your Data Tools

Make sure you brush up on your SQL and BI tools like Power BI before the interview. Be ready to discuss how you've used these tools in past projects, as they'll want to see your hands-on experience with data modelling and reporting.

✨Understand the Business Context

Familiarise yourself with the real estate industry and the specific challenges it faces regarding data integration and reporting. This will help you connect your technical skills to their business needs during the interview.

✨Prepare for Technical Questions

Expect questions about ETL/ELT processes and API integrations. Prepare to explain your approach to building and troubleshooting data pipelines, as well as how you ensure data quality and reliability across systems.

✨Showcase Your Problem-Solving Skills

Be ready to share examples of how you've automated workflows or resolved data issues in previous roles. Highlighting your ability to improve efficiency and contribute to data governance will impress the interviewers.

Data Analyst in City of London
Stanton House
Location: City of London

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>