At a Glance
- Tasks: Transform real estate data with Excel, Power BI, and SQL in a dynamic team.
- Company: Leading European logistics real estate firm launching innovative projects.
- Benefits: Competitive pay of £425/day, flexible 3 days on-site, and growth opportunities.
- Why this job: Make a real impact on data analysis in a startup-style environment.
- Qualifications: Proficient in Excel, Power Query, SQL, and Power BI; strong communication skills.
- Other info: Join a small, innovative team focused on practical solutions and ownership.
The predicted salary is between 30000 - 50000 £ per year.
A leading European logistics real estate firm is seeking a Data Analyst. Operating across a vast network of warehouse spaces and transportation hubs, this established company is launching a cutting-edge, startup-style project that will transform how real estate data is structured, visualized, and leveraged across the business.
The Data Analyst's role: This is a high-ownership position where you'll have significant impact on solutions that shape real estate data analysis. You'll work within a small, innovation-focused team of 3-4 people maximum, requiring genuine engagement with the project rather than just task execution. This isn't about moving data around – we need someone who understands what the data means and can work independently without constant guidance.
Data Analyst Key Responsibilities:
- Manage Excel-based datasets through SharePoint and Power BI dataflows, ensuring smooth transitions from raw inputs to structured outputs.
- Identify inefficiencies in current workflows and propose enhancements to reduce manual effort and streamline operations.
- Monitor data errors, develop error-handling protocols, and maintain governance standards with comprehensive audit trails.
- Build transformation logic using Power Query and SQL, supporting evolution of the medallion architecture (Bronze, Silver, Gold layers).
- Work closely with the Data Engineering team and liaise with external data providers to resolve discrepancies and integration challenges.
- Support Power BI dashboard development, ensuring visualizations meet business needs for underwriting and strategic analysis.
Data Analyst Requirements:
- Strong proficiency in Excel, Power Query, SQL, and Power BI – the core toolkit for this role. Experience with data modeling and ETL processes essential.
- Clear, efficient communicator who makes complex topics simpler, not more complicated. We value clarity over technical rambling.
- High work ethic with genuine ownership mentality. Must see value in the project and understand how everything ties together, not just tick boxes.
- Comfortable taking on full tasks independently without step-by-step guidance. We need someone who grasps concepts quickly and won't require constant explanation.
- Real estate data experience welcomed but not essential – we can provide background to engaged candidates who show willingness to learn.
- Preference for iterative, practical solutions over over-engineering with latest technologies. Focus on doing the project right rather than using cool tech.
Are you a detail-oriented data professional who thrives in startup environments within established companies? Do you excel at understanding data meaning and working with genuine ownership?
Data Analyst in City of London employer: Burns Sheehan
Contact Detail:
Burns Sheehan 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 people in the industry, attend meetups, and connect with professionals on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data analysis projects, especially those using Excel, Power BI, and SQL. 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 practising common data analyst questions and scenarios. Be ready to discuss how you've tackled inefficiencies or improved workflows in past roles. We want to see that ownership mentality in action!
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, we love candidates who take the initiative to engage directly with us. Don’t miss out on this opportunity!
We think you need these skills to ace Data Analyst in City of London
Some tips for your application 🫡
Show Off Your Skills: Make sure to highlight your proficiency in Excel, Power BI, SQL, and Power Query. We want to see how you can manage datasets and create visualisations that make data easy to understand.
Keep It Clear and Concise: When writing your application, aim for clarity. Avoid technical jargon that complicates things. We appreciate straightforward communication that gets to the point without unnecessary fluff.
Demonstrate Ownership: We’re looking for someone who takes initiative and shows genuine engagement with their work. Share examples of how you've taken ownership of projects in the past and made a real impact.
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and get the ball rolling on your potential future with us.
How to prepare for a job interview at Burns Sheehan
✨Know Your Tools Inside Out
Make sure you’re well-versed in Excel, Power BI, SQL, and Power Query. Brush up on your data modelling and ETL processes, as these are crucial for the role. Be ready to discuss specific examples of how you've used these tools to solve real problems.
✨Show Your Ownership Mentality
This role requires a high level of ownership, so be prepared to share instances where you've taken initiative in past projects. Highlight how you’ve identified inefficiencies and proposed practical solutions, demonstrating your proactive approach to data analysis.
✨Communicate Clearly and Effectively
Practice explaining complex data concepts in simple terms. The interviewers will appreciate clarity over technical jargon. Think about how you can convey your ideas succinctly, especially when discussing your past experiences with data.
✨Demonstrate Your Problem-Solving Skills
Be ready to tackle hypothetical scenarios or case studies during the interview. Show how you would approach data discrepancies or integration challenges, and emphasise your ability to work independently without needing constant guidance.