Hire the Best Business Intelligence Analysts
in the United Kingdom

• Price Labs optimisation • Finnancial Analysis • Increase occupancy • Listings optimisations Looking to increase your Airbnb or BDC revenue? I help short-term rental hosts and property managers improve occupancy, optimise pricing, and maximise property performance through data-driven strategies and automation. I have worked in the short term rental market for 5 1/2 years, managing a portfolio of over 100 units for my own company. Through the knowledge i have gained I have the expertise to help you increase your revenue and optimise your listings. what i offer: Pricing Strategy & Management – Optimising pricing through PriceLabs to help increase occupancy, improve revenue, and stay competitive within the local market. Financial & Performance Analysis – Analysing profit and loss data across individual units and property types to identify performance trends, revenue opportunities, and areas for improvement. OTA Listing Optimisation – Rewriting and improving Airbnb and BDC listings to enhance SEO, increase visibility, and improve booking conversion rates. PMS Setup & Optimisation – Experience working with Hostaway and Eviivo to configure and streamline property management systems, making listings and operations easier to manage. Property Investment Analysis – Analysing local market data, pricing trends, occupancy levels, and competitor performance to help assess whether potential rental or purchase opportunities are financially worthwhile. why work with me: - Personal and collaborative approach with every client - Take time to understand the client’s business, goals, and challenges - Clear and honest communication throughout projects - Easy to work with and responsive to client needs - Focus on building long-term working relationships Please book a consultation to find out more.

🏆 𝗧𝗔𝗟𝗘𝗡𝗧𝗘𝗗 𝗗𝗔𝗧𝗔 & 𝗣𝗢𝗪𝗘𝗥 𝗕𝗜 𝗦𝗣𝗘𝗖𝗜𝗔𝗟𝗜𝗦𝗧 🏆 | Power BI • API Integrations • SQL • Automation • Python • Data Engineering | Turning Complex Data into Clear Business Insights Hi, I’m Marcus, a data analyst and BI specialist with strong expertise in Power BI, data architecture, and API integrations. I help businesses transform raw, disconnected data into automated, scalable reporting solutions that drive smarter decisions. Many organisations struggle with fragmented systems and manual reporting. I specialise in connecting your data sources (including APIs, databases, and spreadsheets), building robust data models, and delivering intuitive dashboards that make insights easy to understand and act upon. Your data already contains answers, I help you unlock them. [𝗗𝗔𝗧𝗔 𝗩𝗜𝗦𝗨𝗔𝗟𝗜𝗦𝗔𝗧𝗜𝗢𝗡 & 𝗕𝗜] ✅ Power BI dashboards (end-to-end development) ✅ Data modelling (star schema, performance optimisation) ✅ DAX calculations & advanced measures ✅ Interactive executive dashboards & KPI reporting ✅ Storytelling with data & UX-focused design [𝗔𝗣𝗜 & 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗘𝗚𝗥𝗔𝗧𝗜𝗢𝗡𝗦] ✅ REST API integrations into Power BI, Python, and databases ✅ Automated data pipelines & scheduled refresh processes ✅ Extracting data from SaaS platforms (CRM, finance, marketing tools, etc.) ✅ ETL development using Python, SQL, and Power Query ✅ Data consolidation from multiple systems into a single source of truth [𝗗𝗔𝗧𝗔 𝗘𝗡𝗚𝗜𝗡𝗘𝗘𝗥𝗜𝗡𝗚 & 𝗔𝗨𝗧𝗢𝗠𝗔𝗧𝗜𝗢𝗡] ✅ SQL (Microsoft SQL Server & cloud platforms) ✅ Python automation & scripting ✅ Power Query (M) transformations ✅ Report automation & workflow optimisation ✅ Performance tuning & scalable architecture [𝗦𝗘𝗖𝗨𝗥𝗜𝗧𝗬 & 𝗚𝗢𝗩𝗘𝗥𝗡𝗔𝗡𝗖𝗘] ✅ Row-Level Security (RLS) implementation ✅ Secure login & access control models ✅ Data access monitoring dashboards 📂 Past Projects: ►►► marcus07957 github io ◄◄◄ 𝗛𝗢𝗪 𝗜 𝗪𝗢𝗥𝗞 ✔ Understand your business goals first ✔ Design the right architecture and data flow ✔ Build scalable, automated solutions ✔ Communicate clearly throughout the project ✔ Deliver documented, production-ready systems My focus is not just building dashboards — it’s delivering robust, secure, and maintainable data solutions that continue providing value long after the project ends. 𝗪𝗛𝗬 𝗖𝗟𝗜𝗘𝗡𝗧𝗦 𝗛𝗜𝗥𝗘 𝗠𝗘 ✅ Unlimited revisions ✅ Fast turnaround ✅ Clear communication ✅ Video walkthroughs & documentation ✅ Long-term reliability ✅ Client satisfaction first [𝗧𝗘𝗦𝗧𝗜𝗠𝗢𝗡𝗜𝗔𝗟𝗦] ⭐⭐⭐⭐⭐ "Marcus was hired to help absorb some additional, time critical work that was requested of my team. Marcus showed a lot of due diligence in understand the requirements of the project, regarding soft skills, he listened, took notes when necessary and was confident to question and challenge some aspects of the project. Marcus was able to deliver weekly updates in an agile way, by showing what areas he had worked on and took feedback to make changes to the end product. This was delivered with in a professional matter and he was able to go above and beyond what was expected of him. I cant recommend Marcus highly enough and as iterated before, his eye for detail and providing options helped deliver our project in a timely manner. I am very happy with the outcome and would hire Marcus again." ⭐⭐⭐⭐⭐ "I had the pleasure of working alongside Marcus, and I can confidently say he's an exceptional data analyst. His ability to quickly grasp new concepts and adapt them to the business needs very quickly made him a real asset to my team. Marcus's proactive nature is evident in his approach to every task, he anticipates needs and then takes the initiative. His passion for data analytics is contagious, driving not only his work but also inspiring those around him. Combine this with his personable nature, and you have a colleague who not only delivers excellent results but also fosters a collaborative and enjoyable work atmosphere. I highly recommend Marcus for any data-focused role." If you’re looking for someone who can connect your systems, automate your reporting, and deliver powerful insights through Power BI, I’d love to help. Let’s discuss your project. With respect, Marcus S.

Get reliable data pipelines, trusted dashboards, and a single source of truth your team can actually use. I’m a Senior Data Engineer and BI Consultant with 9+ years of experience designing, building, and maintaining modern data platforms across AWS, GCP, Microsoft Fabric, Power BI and Data Studio. I help businesses move from scattered files, broken pipelines, slow reports, and unreliable dashboards to clean, automated analytics systems that support faster and better decision-making. I specialize in cloud data engineering, data warehousing, lakehouse architecture, dbt transformations, and business intelligence solutions that are production-ready, scalable, and easy to maintain. 𝐇𝐞𝐫𝐞’𝐬 𝐖𝐡𝐚𝐭 𝐈 𝐂𝐚𝐧 𝐃𝐨 𝐅𝐨𝐫 𝐘𝐨𝐮: ✅ Design and build automated data pipelines across AWS, GCP, and Microsoft Fabric. ✅ Build modern data warehouses and lakehouses using Redshift, BigQuery, Databricks, Synapse, S3, and Apache Iceberg ✅ Develop clean transformation layers using dbt, SQL, PySpark, Python, and Power Query. ✅ Implement reliable data models using Kimball Multi-Dimensional Modeling, and Data Vault 2.0 ✅ Build streaming pipeline using Amazon MSK, and Kafka ✅ Build executive dashboards in Power BI, Looker Studio, Tableau, Excel, and Google Sheets. ✅ Improve slow reports, broken pipelines, poor data quality, and unreliable analytics workflows. ✅ Document systems clearly so your team can understand, maintain, and scale them. 𝐒𝐤𝐢𝐥𝐥𝐬 𝐓𝐡𝐚𝐭 𝐌𝐚𝐭𝐭𝐞𝐫: ➡️ Cloud Data Engineering: AWS, GCP, Microsoft Fabric, Azure ➡️ Data Warehousing: Redshift, BigQuery, Snowflake, Synapse Analytics ➡️ Data Lakes & Lakehouse: Amazon S3, ADLS, GCS, Delta Lake, Medallion Architecture ➡️ Data Transformation: dbt, SQL, Python, PySpark, Pandas, Power Query ➡️ Orchestration & Automation: Airflow, AWS Glue, Azure Data Factory, Cloud Dataflow ➡️ BI & Analytics: Power BI, Looker Studio, Excel, Google Sheets ➡️ Data Modeling: Kimball, Data Vault 2.0, Star Schema, Semantic Layers 𝐓𝐨𝐨𝐥𝐬 𝐈 𝐔𝐬𝐞: Power BI, Looker Studio, dbt, Python, SQL, PySpark, Airflow, AWS Glue, AWS DMS, Lambda, Redshift, Athena, BigQuery, Snowflake, Microsoft Fabric, Azure Data Factory, Synapse Analytics, Amazon S3, ADLS, GCS, GitAction, CI/CD. 𝐖𝐡𝐚𝐭 𝐘𝐨𝐮 𝐂𝐚𝐧 𝐄𝐱𝐩𝐞𝐜𝐭: ✅ Clean, automated data pipelines ✅ A reliable single source of truth ✅ Fast SQL and Python processing ✅ Dashboards that are clear, useful, and adopted by the business ✅ Strong data quality, testing, and documentation ✅ Clear communication and dependable delivery ✅ A complete BI package, not just another dashboard Whether you need a new pipeline, a scalable data warehouse, a lakehouse, a dbt project, a Power BI dashboard, or a full end-to-end analytics system, I can help you design it properly and deliver it with confidence. Send me a message with your current data challenge, and let’s discuss how to turn it into a reliable analytics solution.

🚀 What I Do I design and deliver end-to-end systems—from ingestion pipelines and external APIs to admin dashboards and infrastructure automation. Whether you're building a modern data stack or need clean backend APIs to power your frontend, I can help. 🔧 Core Services Data Engineering: • Snowflake ELT pipelines & external functions (AWS Lambda / Azure Functions) • Real-time ingestion with Snowpipe, cost optimization • Infrastructure-as-code with Terraform Backend/API Dev: • FastAPI, Python, .NET, Postgres • Secure & scalable APIs, webhook processors, SaaS integrations Full-stack Development: • React / .NET admin panels, user portals, reporting tools • UI/UX optimizations and clean architecture DevOps & Automation: • CI/CD, cloud provisioning, serverless architecture (AWS/GCP/Azure) • Monitoring and performance tuning 💼 Notable Projects • Built internal Snowflake platform with external functions + real-time ingestion for large gaming company • Created admin dashboards & reporting pipelines used by 100+ users across teams • Restored 40 TB of data from Elasticsearch backup in a complex cloud migration • Reduced cloud costs by 96% via infra redesign 🤝 Why Work With Me? Clients appreciate my ability to: • Take ownership from architecture to delivery • Communicate clearly & deliver fast • Write code that's easy to hand off or scale I currently work full-time, but I take on freelance projects for companies who want top-tier engineering without micromanagement. 📩 Let’s talk about how I can help your team move faster.

✅ Top Rated Plus Consultant. 🥇 Top 1% available on Upwork. 📈 500% + ROI utilising process automation, datawarehousing, data analytics and visualisation. 📊 Developing visually appealing PowerBI dashboards, reducing manual dependencies, developing modern solutions and optimising existing processes. 🤝 Working with startups to enterprise clients, ensuring everyone has an equal opportunity to take advantage of their greatest commodity, data. Getting the most from your existing data or planning your data strategy can be a difficult task. Knowing what data is valuable or bringing data from disparate sources to get a true view of your business can be a manual and laborious task that takes a lot of your available time to be able to make informed decisions. Working with us, you are guaranteed to reduce the time to make informed decisions with scalable, dynamic and optimised solutions. Reducing time to value and ensuring you have a solution that can provide value for the long term. We can't help everyone but we may be a great fit, if you: 💥 Are investing in getting the most from your data. (Processes to Visulisation). 💥 Require modern data solutions that add value to your business. 💥 Reduce manual dependencies and have scalable, optimised solutions developed for your needs. 💥 Want to utilise Azure or AWS to take advantage of Cloud Architecture. 💥 Want to automate new or existing processes in Power Automate, MS Flow or Azure Logic Apps. 💥 Need ETL Pipelines in Azure Data Factory, Synapse Pipelines, AWS Glue or SSIS. 💥 Want modern data solutions that make your data easily accessible to everyone who needs it, when they need it. Utilising MS SQL, PostgreSQL or MySQL in the cloud or on-premise. 💥 Visually appealing dashboards in Power BI, Power Apps, Google Data Studio or Tableau. Benefits of working with us: ✅ Top Rated Plus. The top 1% of freelancers on Upwork. ✅ 100% success rate. ✅ Multiple 5 star reviews and 100% long term clients, building strong dependable relationships. ✅ Put our client's needs first and provide tailored solutions to ensure the finished product is a great fit. ✅ Experience working across multiple industries with start-ups to global $2 billion turnover clients. ✅ Over 15 years of industry experience across Business Intelligence, Information Security and Infrastructure Architecture. Industries we have worked in: ⭐ Manufacturing ⭐ Marketing ⭐ Financial (Investment and management) ⭐ Healthcare ⭐ Retail (Ecommerce and Physical) ⭐ Consulting ⭐ Breweries ⭐ Education ⭐ Customer Behavior/Insights ⭐ Automotive ⭐ Legal Services ⭐ Film Production Working with companies located in: 🌎 United States (PST to EST, GMT -8 to GMT -5) 🌎 United Kingdom (GMT) 🌎 Spain (CET, GMT +1) 🌎 Netherlands (CET, GMT +1) 🌎 Israel (IST, GMT+2) 🌎 Australia (ACT, GMT + 11) 🔭 My Background. I started my career in IT working with national companies in the UK developing there infrastructure to ensure they had a secure and robust core architecture. I then moved to a global company implementing global projects in a demanding environment. While at the global company, I took on my first BI project to forecast sales based on the last 13 years of sales data, increasing cold call sales to a 86% success rate and reducing costs by $120,000 per year. After that project I started my BI Consultancy journey working with over 20 companies in the last 7 years, many of which are still clients today, with a common goal in mind to provide excellent service and ensure everyone can get the most from their data regardless of the size of starting point of the company. In 2021 I started Lookthru Analytics formally due to growing demand and existing client base, to ensure we can continue to provide that same mantra of service, bring on like minded professionals to broaden and strengthen the core offering. From there we've gone from strength to strength and constantly look for improvements in our own work and in what we can take advantage of. 📞 Whats next? If you have made it this far, I think it's time for a call to see how we can help?

𝗔𝘃𝗮𝗶𝗹𝗮𝗯𝗹𝗲 𝘁𝗼𝗱𝗮𝘆 May 5 💡 𝐅𝐫𝐞𝐞 𝟑𝟎-𝐦𝐢𝐧 𝐬𝐭𝐫𝐚𝐭𝐞𝐠𝐲 𝐜𝐚𝐥𝐥: I’ll show you how to unify Power BI, SQL, ETL, and warehouse reporting into one trusted source of truth. Get answers in minutes, remove manual reporting, and give leadership real-time visibility. I’m a Business Intelligence Specialist with over 12 years of experience designing, building, and optimizing enterprise-grade data systems. I specialize in cloud architecture (AWS, GCP, Azure), data warehousing, and BI solutions that help businesses unlock insights, cut costs, and scale with confidence. I’ve delivered projects across 𝐟𝐢𝐧𝐚𝐧𝐜𝐞, 𝐡𝐞𝐚𝐥𝐭𝐡𝐜𝐚𝐫𝐞, 𝐞-𝐜𝐨𝐦𝐦𝐞𝐫𝐜𝐞, 𝐚𝐧𝐝 𝐫𝐞𝐬𝐞𝐚𝐫𝐜𝐡, with a strong focus on security, performance, and business impact. 𝐇𝐞𝐫𝐞’𝐬 𝐖𝐡𝐚𝐭 𝐈 𝐂𝐚𝐧 𝐃𝐨 𝐅𝐨𝐫 𝐘𝐨𝐮: - Design and implement data warehouses and lakes using best practices (Kimball, BIML, SQL Server, Snowflake). - Develop ETL/ELT pipelines with SSIS, Python, and cloud-native tools for reliable, automated data flows. - Build interactive dashboards and analytics in Power BI, helping teams move from raw data to actionable insights. - Run security reviews and cost optimization across cloud platforms to reduce spend without compromising performance. - Deliver custom CRM and analytics solutions tailored for industries like pharma, pensions, and financial services. 𝐒𝐤𝐢𝐥𝐥𝐬 𝐓𝐡𝐚𝐭 𝐌𝐚𝐭𝐭𝐞𝐫: - Cloud & DevOps: AWS, GCP, Azure, Terraform, CI/CD, GitHub - Data Engineering & Warehousing: SQL Server (SSIS, SSAS, SSRS), Snowflake, Data Lakes, Kimball Methodology - Analytics & BI: Power BI, DAX, SQL, Python - Security & Optimization: Cloud security reviews, cost reduction strategies 𝐓𝐨𝐨𝐥𝐬 𝐈 𝐔𝐬𝐞 Power BI, SQL Server, Python, Snowflake, Terraform, AWS, GCP, Azure, React, React Native, GitHub CI/CD, SSIS, SSAS, SSRS 𝐖𝐡𝐚𝐭 𝐂𝐥𝐢𝐞𝐧𝐭𝐬 𝐒𝐚𝐲 “Delivered a payment processing solution handling £10M+ monthly transactions with zero downtime. Reliable, detail-oriented, and excellent communicator - will rehire for our next project.” If your dashboards are unclear, your data pipelines fragile, or your cloud costs out of control, I’ll fix that. 📩 𝐒𝐞𝐧𝐝 𝐦𝐞 𝐚 𝐦𝐞𝐬𝐬𝐚𝐠𝐞, 𝐚𝐧𝐝 𝐰𝐞’𝐥𝐥 𝐛𝐨𝐨𝐤 𝐲𝐨𝐮𝐫 𝐟𝐫𝐞𝐞 𝐬𝐭𝐫𝐚𝐭𝐞𝐠𝐲 𝐜𝐚𝐥𝐥.