Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the development of analytical data products and reporting data marts.
- Company: Join a forward-thinking tech company in London, focused on innovative analytics solutions.
- Benefits: Enjoy flexible working options and a vibrant corporate culture with great perks.
- Why this job: Be part of a dynamic team shaping the future of data analytics in finance.
- Qualifications: 12+ years in IT, with 8+ years in analytics and strong GCP/Big Query experience.
- Other info: Ideal for those passionate about data and eager to make an impact in the investment domain.
The predicted salary is between 72000 - 108000 £ per year.
Customer Role: Engineering Lead – Analytics Role – BI Architect
Location: London
Job Description: Engineering Lead – Analytics
Key Responsibilities:
- 12+ years of experience in IT with 8+ years of experience in building Analytical data products.
- Develop reporting data mart based on the reporting requirements.
- Experience in the development of Role play dimensions, Aggregate fact tables, Bridge tables, Conformed dimensions.
- Experience in architecting the BI solution for an enterprise which includes reporting mart design and semantic model design.
- Experience in interacting with Business and IT stakeholders to define reporting data mart design.
- 4+ years of experience in GCP and Big Query.
- Experience in building datamart on Big Query.
- Experience in establishing self-serve capability from the reporting datamart and suggesting best practices.
- Understanding of investment domain having created datamarts on fund management, Holdings, and cash flow.
Contact Detail:
N Consulting Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI Architect
✨Tip Number 1
Make sure to showcase your experience with GCP and Big Query during networking events or conversations. Highlight specific projects where you've built datamarts, as this will resonate well with potential employers looking for a BI Architect.
✨Tip Number 2
Engage with online communities and forums related to BI architecture and analytics. Sharing your insights and asking questions can help you connect with industry professionals who might have leads on job openings, including ours at StudySmarter.
✨Tip Number 3
Attend industry conferences or webinars focused on analytics and BI solutions. These events are great for networking and often provide opportunities to meet hiring managers or recruiters from companies like us who are looking for experienced candidates.
✨Tip Number 4
Consider reaching out directly to current employees in similar roles at companies you're interested in. Informational interviews can give you insider knowledge about the company culture and the specific skills they value, which can be beneficial when applying through our website.
We think you need these skills to ace BI Architect
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your relevant experience in building analytical data products and your expertise in GCP and Big Query. Use specific examples that demonstrate your skills in architecting BI solutions and interacting with stakeholders.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for the role of BI Architect. Mention your 12+ years of IT experience and how it aligns with the key responsibilities outlined in the job description. Be sure to express your understanding of the investment domain.
Highlight Key Projects: In your application, include details about specific projects where you developed reporting data marts or established self-serve capabilities. This will help demonstrate your practical experience and problem-solving skills.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a role that involves data accuracy and reporting.
How to prepare for a job interview at N Consulting Limited
✨Showcase Your Technical Expertise
As a BI Architect, it's crucial to demonstrate your deep understanding of analytical data products. Be prepared to discuss your experience with reporting data marts, role play dimensions, and aggregate fact tables. Highlight specific projects where you've successfully implemented these concepts.
✨Communicate with Clarity
You'll likely be interacting with both business and IT stakeholders during the interview. Practice explaining complex technical concepts in simple terms. This will show your ability to bridge the gap between technical and non-technical teams, which is essential for this role.
✨Prepare for GCP and Big Query Questions
Given the emphasis on GCP and Big Query in the job description, make sure you brush up on your knowledge of these platforms. Be ready to discuss your hands-on experience, including any challenges you've faced and how you overcame them while building datamarts.
✨Understand the Investment Domain
Since the role involves creating datamarts related to fund management, holdings, and cash flow, it’s beneficial to have a solid grasp of the investment domain. Research common terminologies and practices in this field so you can speak confidently about your relevant experience.
