Data/ BI Architect

Project overview

About Our Client

A well-established UK-based international investment organisation with a global footprint, delivering impactful programmes across multiple regions.

Job Description

As a Data Architect, you will bring your experience in Microsoft Fabric and Azure data technologies to the organisation, and your core responsibilities include:

The Successful Applicant

Background and skills

Competencies and aptitude

What's on Offer

• Hands-on architecture role with real delivery impact
• Work closely with developers on a modern Azure data platform
• Actively delivering work for key business programs advising and supporting the further adoption of the data platform.
• Designing, building and providing guidance for the use and management of data specifically around our data hub, Enterprise Data Warehouse and Power BI and Fabric Analytics and Reporting tools.
• Defining the data technology architecture, model/schema, including metadata, integration and business intelligence or data warehouse architecture.
• Coordinating changes across business change, technology change management process, incident management and problem management process.
• Ensuring traceability of requirements on data through design, build, testing and scope changes.
• Providing input into data dictionaries and the evolution of these and other related data assets such as the organisations Common/Logical Data Model.
• Several years of experience in a senior BI data architecture role.
• Expert in dimensional modelling (logical and physical) using Kimball methodology and an excellent understanding of all data concepts, metadata management, data quality management and data governance.
• Experience in end-to-end BI architecture design in an Azure environment: ingestion → storage → transformation → consumption.
• Proven record working with SQL relational databases, data warehouses, query authoring (SQL) as well as working familiarity with a variety of other databases.
• Highly experienced in building and optimizing data queries. Good with manipulating, processing and preparing datasets/semantic models.
• Experienced in working with data engineering technologies including ADLS, ADF, Azure SQL, and Azure Synapse, Power BI/Fabric and DAX.
• Good working knowledge of languages such as Python/PySpark.
• Previously created or enhanced CI/CD build and release pipelines using Azure DevOps and GI T.
• Knowledge of other scripting languages such as YAML, PowerShell, Terraform etc.
• Ability to quickly learn, implement, and utilise new technologies.
• Analytical and problem-solving. Combines and organises information into meaningful patterns; identifies underlying relationships, causes and effects; and combines pieces of information to form conclusions or general rules.
• Communications. Excellent oral and written communication skills.
• Detail-oriented. Consistently takes a thorough, accurate, organised and quality-centred approach.
• Organisation and prioritising. Can effectively address projects, requests and competing priorities. Owning deliverables through to implementation.
• Self-learning mindset. Desires to learn new skills and is willing to share knowledge with the team.
• Provide problem diagnosis and technical assistance.
• £750-£850 per day (Inside IR35)
• Hybrid working (2-3 days in London)
• Initial 6-month contract with extension potential

Project details

• Start: flexible
• Location: City of London, GB
• Rate: 94-106 EUR/h