At a Glance
- Tasks: Lead the design and migration of data solutions using Microsoft Fabric and Azure technologies.
- Company: Join Intellias, a leader in digital solutions with 20 years of innovation.
- Benefits: Enjoy a competitive salary, flexible work options, and opportunities for professional growth.
- Why this job: Make a real impact by shaping the future of data architecture in a dynamic environment.
- Qualifications: 5+ years in data warehousing, strong T-SQL skills, and experience with Azure Data Factory.
- Other info: Diverse team culture with a commitment to equal opportunity and career advancement.
The predicted salary is between 48000 - 72000 £ per year.
Get AI-powered advice on this job and more exclusive features. Dive deep into Digital! For 20 years Intellias has been developing top-tier digital solutions for the world's leading companies, keeping them in line with the latest technology trends. Join in and provide innovations for the future!
Required Experience & Skills
- 5+ years with Azure SQL Data Warehouse / Synapse dedicated SQL pools or similar MPP DW.
- Strong T-SQL skills (complex queries, DDL/DML, performance tuning).
- Solid data warehousing background (facts/dimensions, SCDs, star/snowflake).
- Hands-on ETL/ELT experience with Azure Data Factory / Synapse pipelines or similar.
- Working knowledge of Microsoft Fabric (Warehouse, Lakehouse, OneLake, Data Factory, workspaces).
- Proven track record in data platform migrations (on-prem or cloud → modern DW/lakehouse).
- Experience mentoring or leading engineers, defining standards and reviewing designs.
- Strong communication skills; able to explain options and trade-offs to non-technical stakeholders.
Nice to Have
- Production experience with Fabric (shortcuts, notebooks, Delta-based Lakehouse workloads).
- Strong Power BI skills (models on Fabric Warehouse/Lakehouse, Direct Lake).
- DevOps/CI-CD for data platforms (Git integration, automated deployments).
- Familiarity with Microsoft Purview or other catalog/lineage tools.
- Microsoft certifications (Azure Data Engineer, Solutions Architect, Power BI, Fabric when available).
Responsibilities
- Guide the team through assessment of the current SQL DW/Synapse environment, dependencies, and risks.
- Define the target Fabric architecture (Warehouse vs Lakehouse, OneLake layout, environments).
- Create a migration playbook: standards, templates, and reusable patterns for schema, data, and pipelines.
- Provide hands-on support on complex areas: T-SQL refactoring, schema migration, initial & incremental loads.
- Help re-platform or design Data Factory / pipeline solutions in Fabric.
- Establish data validation and performance patterns (row counts, checksums, query parity).
- Set and socialize security & governance patterns (RBAC, RLS/CLS, sensitivity labels, dev/test/prod).
- Coach, mentor, and perform code/pipeline reviews, raising the team's Fabric skills.
- Communicate status, risks, and technical decisions to engineering and business stakeholders.
Seniority level: Mid-Senior level
Employment type: Full-time
Job function: Consulting
Industries: IT Services and IT Consulting
We're committed to diversity and equal opportunity. Applications are welcome from all qualified individuals.
MS Fabric Data Architect in London employer: Intellias
Contact Detail:
Intellias Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land MS Fabric Data Architect in London
✨Tip Number 1
Network like a pro! Reach out to folks in your industry on LinkedIn or at local meetups. We all know that sometimes it’s not just what you know, but who you know that can help you land that dream job.
✨Tip Number 2
Prepare for those interviews! Research the company and practice common interview questions. We suggest you also think about how your skills with Azure SQL and data warehousing can solve their problems – show them you’re the perfect fit!
✨Tip Number 3
Don’t forget to follow up after your interviews! A quick thank-you email can go a long way. It shows you’re genuinely interested and keeps you fresh in their minds – we all appreciate a little courtesy!
✨Tip Number 4
Apply through our website! We’ve got loads of opportunities waiting for you, and applying directly can sometimes give you an edge. Plus, it’s super easy to keep track of your applications with us!
We think you need these skills to ace MS Fabric Data Architect in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the MS Fabric Data Architect role. Highlight your experience with Azure SQL Data Warehouse, T-SQL skills, and any hands-on ETL/ELT work you've done. We want to see how your background aligns with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data architecture and how your skills can help us innovate at StudySmarter. Keep it concise but impactful – we love a good story!
Show Off Your Projects: If you've worked on relevant projects, don't hesitate to showcase them! Whether it's a migration playbook or a complex data pipeline, we want to see your hands-on experience. Include links or descriptions that demonstrate your expertise.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly from us. Plus, it shows you're keen on joining the StudySmarter team!
How to prepare for a job interview at Intellias
✨Know Your Tech Inside Out
Make sure you’re well-versed in Azure SQL Data Warehouse, Synapse, and Microsoft Fabric. Brush up on your T-SQL skills and be ready to discuss complex queries and performance tuning. The more confident you are with the tech stack, the better you'll impress the interviewers.
✨Showcase Your Experience
Prepare specific examples from your past work that highlight your hands-on experience with ETL/ELT processes and data platform migrations. Be ready to explain how you’ve tackled challenges and what innovations you brought to the table. Real-world examples resonate well!
✨Communicate Clearly
Since strong communication skills are a must, practice explaining technical concepts in simple terms. Think about how you would describe your work to non-technical stakeholders. This will show that you can bridge the gap between tech and business effectively.
✨Be Ready to Mentor
As mentoring is part of the role, think about your leadership style and how you’ve helped others grow in their careers. Prepare to discuss your approach to coaching and how you ensure quality through code reviews and design standards.