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
- 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
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
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.