BI Architect

N Consulting Limited; London; On-site; GBP 125,000 - 150,000; Full time

Job summary

An established industry player is seeking an Engineering Lead for their Analytics team. This role focuses on architecting and developing analytical data products, specifically within the investment domain. The ideal candidate will leverage over 12 years of IT experience, with a strong emphasis on building data marts and BI solutions using GCP and Big Query. You will collaborate with business and IT stakeholders to create effective reporting solutions and establish best practices for self-service capabilities. If you thrive in a dynamic environment and are passionate about data analytics, this opportunity is perfect for you.

Qualifications

• 12+ years of IT experience with 8+ years in building Analytical data products.
• 4+ years of experience in GCP and Big Query.

Responsibilities

• Develop reporting data mart based on reporting requirements.
• Architect BI solutions including reporting mart and semantic model design.
• Establish self-serve capability from reporting datamart.

Skills

Analytical data products

BI Architect

GCP

Big Query

Data mart design

Stakeholder interaction

Investment domain knowledge

Job description

Customer Role: Engineering Lead – Analytics Role – BI Architect

Location: London

Job Description: Engineering Lead – Analytics

Key Responsibilities:

1. 12+ years of experience in IT with 8+ years of experience in building Analytical data products.
2. Develop reporting data mart based on the reporting requirements.
3. Experience in the development of Role play dimensions, Aggregate fact tables, Bridge tables, Conformed dimensions.
4. Experience in architecting the BI solution for an enterprise which includes reporting mart design and semantic model design.
5. Experience in interacting with Business and IT stakeholders to define reporting data mart design.
6. 4+ years of experience in GCP and Big Query.
7. Experience in building datamart on Big Query.
8. Experience in establishing self-serve capability from the reporting datamart and suggesting best practices.
9. Understanding of investment domain having created datamarts on fund management, Holdings, and cash flow.